开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > WEB源码(ASP,PHP,...) > 查看源码
ODepartment.aspx.cs
资源名称：OAJP.rar　[点击查看]
上传用户：jdb8708888
上传日期：2013-05-29
资源大小：19971k
文件大小：12k
源码类别：

WEB源码(ASP,PHP,...)

开发平台：

C#

ODepartment.aspx.cs：源码内容
  1. using System;
  2. using System.Collections;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Data.SqlClient;
  6. using System.Drawing;
  7. using System.Web;
  8. using System.Web.SessionState;
  9. using System.Web.UI;
  10. using System.Web.UI.WebControls;
  11. using System.Web.UI.HtmlControls;
  14. namespace UDS.SubModule.Department
  15. {
  16. /// <summary>
  17. /// ODepartment 的摘要说明。
  18. /// </summary>
  19. public class ODepartment : System.Web.UI.Page
  20. {
  21. protected System.Web.UI.WebControls.Label title_add;
  22. protected System.Web.UI.WebControls.Label addDepartmentName;
  23. protected System.Web.UI.WebControls.Label title_del;
  24. protected System.Web.UI.WebControls.Label delDepartmentName;
  25. protected System.Web.UI.WebControls.TextBox txtDepartmentName;
  26. protected System.Web.UI.WebControls.TextBox txtADepartmentName;
  27. protected System.Web.UI.WebControls.TextBox txtADepartmentRemark;
  28. protected System.Web.UI.WebControls.TextBox txtMDepartmentRemark;
  29. protected System.Web.UI.WebControls.TextBox txtOnDutyTime;
  30. protected System.Web.UI.WebControls.TextBox txtOffDutyTime;
  31. protected System.Web.UI.HtmlControls.HtmlInputButton cmdAdd;
  32. protected System.Web.UI.HtmlControls.HtmlInputButton cmdDelete;
  33. protected System.Web.UI.HtmlControls.HtmlInputButton cmdModify;
  34. protected System.Web.UI.WebControls.RegularExpressionValidator rev_OnDutyTime;
  35. protected System.Web.UI.WebControls.RegularExpressionValidator rev_uOnDutyTime;
  36. protected System.Web.UI.WebControls.RegularExpressionValidator rev_OffDutyTime;
  37. protected System.Web.UI.WebControls.RegularExpressionValidator rev_uOffDutyTime;
  39. private static int DeptID;//部门id
  40. private static string DepartmentName;//部门名称
  41. private static string DepartmentDescription;
  42. private static string OnDutyTime = "";
  43. private static int DisplayType;
  44. protected System.Web.UI.WebControls.LinkButton lbAddDepartment;
  45. protected System.Web.UI.WebControls.LinkButton lbDeleteDepartment;
  46. protected System.Web.UI.WebControls.LinkButton lbModifyDepartment;
  47. protected System.Web.UI.HtmlControls.HtmlTableCell TD1;
  48. protected System.Web.UI.HtmlControls.HtmlTable tabModify;
  49. protected System.Web.UI.HtmlControls.HtmlGenericControl FONT1;
  50. protected System.Web.UI.HtmlControls.HtmlGenericControl FONT2;
  51. protected System.Web.UI.HtmlControls.HtmlTable tabAdd;
  52. protected System.Web.UI.HtmlControls.HtmlTable tabDelete;
  53. protected System.Web.UI.WebControls.TextBox txtuOnDutyTime;
  54. protected System.Web.UI.WebControls.TextBox txtuOffDutyTime;
  55. protected System.Web.UI.WebControls.Literal litAMessage;
  56. protected System.Web.UI.WebControls.Literal litMMessage;
  57. protected System.Web.UI.WebControls.LinkButton lbMoveDepartment;
  58. protected System.Web.UI.WebControls.Label lblDepartment;
  59. protected System.Web.UI.WebControls.ListBox lstDeparment;
  60. protected System.Web.UI.WebControls.Button cmdMove;
  61. protected System.Web.UI.HtmlControls.HtmlTable tabMove;
  62. protected System.Web.UI.WebControls.Button cmdModifyReturn;
  63. protected System.Web.UI.WebControls.Button cmdDeleteReturn;
  64. protected System.Web.UI.WebControls.Button cmdAddReturn;
  65. protected System.Web.UI.WebControls.Button cmdMoveReturn;//上班时间
  66. private static string OffDutyTime = "";//下班时间
  67.         
  68. private void Page_Load(object sender, System.EventArgs e)
  69. {
  70. if(!Page.IsPostBack)
  71. {
  72. txtDepartmentName.Text = "";
  73. OnDutyTime = "";
  74. OffDutyTime = "";
  76. SqlDataReader dr;
  78. //得到部门ID
  79. DeptID=(Request.QueryString["DeptID"]==null?0:Int32.Parse(Request.QueryString["DeptID"].ToString()));
  81. UDS.Components.Department dp = new UDS.Components.Department();
  83. dr = dp.GetDepartmentInfo(DeptID);
  85. if(dr.Read())
  86. {
  87. DepartmentName = dr["Department_Name"].ToString();
  88. DepartmentDescription = dr["Department_Description"].ToString();
  89. }
  91. dr.Close();
  93. dr = dp.GetDepartmentDutyTime(DeptID);
  94. if(dr.Read())
  95. {
  96. OnDutyTime = DateTime.Parse(dr["OnDutyTime"].ToString()).ToShortTimeString();
  97. OffDutyTime = DateTime.Parse(dr["OffDutyTime"].ToString()).ToShortTimeString();
  98. }
  100. if(Request.QueryString["DisplayType"] !=null)
  101. DisplayType = Int32.Parse(Request.QueryString["DisplayType"].ToString());
  102. else
  103. DisplayType = 0;
  104. // 显示不同表格
  105. switch(DisplayType)
  106. {
  107. case 0:
  108. tabAdd.Visible = true;
  109. tabDelete.Visible = false;
  110. tabModify.Visible = false;
  111. tabMove.Visible =false;
  113. lbAddDepartment.BackColor = Color.FromArgb(0xf0f0f0);
  114. lbDeleteDepartment.BackColor = Color.FromArgb(0xffffff);
  115. lbModifyDepartment.BackColor = Color.FromArgb(0xffffff);
  116. lbMoveDepartment.BackColor  = Color.FromArgb(0xffffff);
  118. addDepartmentName.Text = DepartmentName;
  119. break;
  120. case 1:
  121. tabAdd.Visible = false;
  122. tabDelete.Visible = true;
  123. tabModify.Visible = false;
  124. tabMove.Visible =false;
  125. lbAddDepartment.BackColor = Color.FromArgb(0xffffff);
  126. lbDeleteDepartment.BackColor = Color.FromArgb(0xf0f0f0);
  127. lbModifyDepartment.BackColor = Color.FromArgb(0xffffff);
  128. lbMoveDepartment.BackColor  = Color.FromArgb(0xffffff);
  130. delDepartmentName.Text  = DepartmentName;
  131. break;
  132. case 2:
  133. tabAdd.Visible = false;
  134. tabDelete.Visible = false;
  135. tabModify.Visible = true;
  136. tabMove.Visible =false;
  138. txtDepartmentName.Text = DepartmentName;
  139. txtMDepartmentRemark.Text = DepartmentDescription;
  141. lbAddDepartment.BackColor = Color.FromArgb(0xffffff);
  142. lbDeleteDepartment.BackColor = Color.FromArgb(0xffffff);
  143. lbModifyDepartment.BackColor = Color.FromArgb(0xf0f0f0);
  144. lbMoveDepartment.BackColor  = Color.FromArgb(0xffffff);
  146. txtuOnDutyTime.Text  = OnDutyTime;
  147. txtuOffDutyTime.Text  = OffDutyTime;
  148. break;
  149. case 3:
  150. tabAdd.Visible = false;
  151. tabDelete.Visible = false;
  152. tabModify.Visible = false;
  153. tabMove.Visible =true;
  155. lbAddDepartment.BackColor = Color.FromArgb(0xffffff);
  156. lbDeleteDepartment.BackColor = Color.FromArgb(0xffffff);
  157. lbModifyDepartment.BackColor = Color.FromArgb(0xffffff);
  158. lbMoveDepartment.BackColor  = Color.FromArgb(0xf0f0f0);
  160. lblDepartment.Text = DepartmentName;
  161. BindDepartment();
  162. break;
  163. default:
  164. break;
  165. }
  167. }
  168. }
  170. #region Web Form Designer generated code
  171. override protected void OnInit(EventArgs e)
  172. {
  173. //
  174. // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
  175. //
  176. InitializeComponent();
  177. base.OnInit(e);
  178. }
  180. /// <summary>
  181. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  182. /// 此方法的内容。
  183. /// </summary>
  184. private void InitializeComponent()
  185. {    
  186. this.lbAddDepartment.Click += new System.EventHandler(this.lbAddDepartment_Click);
  187. this.lbDeleteDepartment.Click += new System.EventHandler(this.lbDeleteDepartment_Click);
  188. this.lbModifyDepartment.Click += new System.EventHandler(this.lbModifyDepartment_Click);
  189. this.lbMoveDepartment.Click += new System.EventHandler(this.lbMoveDepartment_Click);
  190. this.cmdAdd.ServerClick += new System.EventHandler(this.cmdAdd_ServerClick);
  191. this.cmdAddReturn.Click += new System.EventHandler(this.cmdReturn_Click);
  192. this.cmdDeleteReturn.Click += new System.EventHandler(this.cmdReturn_Click);
  193. this.cmdModifyReturn.Click += new System.EventHandler(this.cmdReturn_Click);
  194. this.cmdMove.Click += new System.EventHandler(this.cmdMove_Click);
  195. this.cmdMoveReturn.Click += new System.EventHandler(this.cmdReturn_Click);
  196. this.cmdDelete.ServerClick += new System.EventHandler(this.cmdDelete_ServerClick);
  197. this.cmdModify.ServerClick += new System.EventHandler(this.cmdModify_ServerClick);
  198. this.Load += new System.EventHandler(this.Page_Load);
  200. }
  201. #endregion
  203. private void BindDepartment()
  204. {
  205. UDS.Components.Database db = new UDS.Components.Database();
  206. SqlDataReader dr_department = null;
  207. db.RunProc("sp_GetAllDepartment",out dr_department);
  208. lstDeparment.DataSource = dr_department;
  209. lstDeparment.DataTextField = "Department_Name";
  210. lstDeparment.DataValueField = "Department_ID";
  211. lstDeparment.DataBind();
  212. }
  214. private void cmdAdd_ServerClick(object sender,System.EventArgs e)
  215. {
  216. if(txtADepartmentName.Text.Trim()!="")
  217. {
  218. long NewDeptID = UDS.Components.Department.Add(DeptID,txtADepartmentName.Text,txtADepartmentRemark.Text);
  219. if(DeptID>0)
  220. {
  221. if((txtOnDutyTime.Text.Trim()!="")&&(txtOffDutyTime.Text.Trim()!=""))
  222. {
  223. if(UDS.Components.Department.AddDutyTime(NewDeptID,DateTime.Parse(txtOnDutyTime.Text),DateTime.Parse(txtOffDutyTime.Text))!=0)
  224. Response.Write("<script laguage='javascript'>alert('添加部门出错！');</script>");
  225. else
  226. Response.Redirect("ListView.aspx?DeptID=" +DeptID + "&Refresh=1");
  227. }
  228. else
  229. Response.Redirect("ListView.aspx?DeptID=" +DeptID + "&Refresh=1");
  230. }
  231. else
  232. Response.Write("<script laguage='javascript'>alert('添加部门出错！');</script>");
  233. }
  234. else
  235. {
  236. litAMessage.Text ="请输入部门";
  237. }
  238. }
  240. private void cmdDelete_ServerClick(object sender,System.EventArgs e)
  241. {
  242. switch(UDS.Components.Department.Delete(DeptID))
  243. {
  244. case 0:
  245. Response.Redirect("ListView.aspx?DeptID="+DeptID+"&Refresh=1");
  246. break;
  247. case -1:
  248. Response.Write("<script laguage='javascript'>alert('有下级子部门，不能删除！');</script>");
  249. break;
  250. case -2:
  251. Response.Write("<script laguage='javascript'>alert('部门有成员，不能删除！');</script>");
  252. break;
  253. default:
  254. break;
  255. }
  257. }
  259. private void cmdModify_ServerClick(object sender,System.EventArgs e)
  260. {
  261. if(txtDepartmentName.Text.Trim()!="")
  262. {
  263. if((UDS.Components.Department.Modify(DeptID,txtDepartmentName.Text,txtMDepartmentRemark.Text)==0))
  264. {
  265. if((txtuOnDutyTime.Text.Trim()!="")&&(txtuOffDutyTime.Text.Trim()!=""))
  266. {
  267. if((UDS.Components.Department.UpdateDutyTime(DeptID,DateTime.Parse(txtuOnDutyTime.Text),DateTime.Parse(txtuOffDutyTime.Text))!=0))
  268. {
  269. Response.Write("<script laguage='javascript'>alert('修改部门出错！');</script>");
  270. return;
  271. }
  272. }
  273. else
  274. {
  275. UDS.Components.Department.DeleteDutyTime(DeptID);
  276. }
  277. Response.Redirect("ListView.aspx?DeptID="+DeptID+"&Refresh=1");
  278. }
  279. else
  280. Response.Write("<script laguage='javascript'>alert('修改部门出错！');</script>");
  281. }
  282. else
  283. litMMessage.Text ="请输入部门";
  284. }
  286. private void Operation_SelectedIndexChanged(object sender, System.EventArgs e)
  287. {
  289. }
  291. private void lbAddDepartment_Click(object sender, System.EventArgs e)
  292. {
  293. Server.Transfer("ODepartment.aspx?DeptID=" + DeptID.ToString() + "&DisplayType=0");
  294. }
  296. private void lbDeleteDepartment_Click(object sender, System.EventArgs e)
  297. {
  298. Server.Transfer("ODepartment.aspx?DeptID=" + DeptID.ToString() + "&DisplayType=1");
  299. }
  301. private void lbModifyDepartment_Click(object sender, System.EventArgs e)
  302. {
  303. Server.Transfer("ODepartment.aspx?DeptID=" + DeptID.ToString() + "&DisplayType=2");
  304. }
  306. private void lbMoveDepartment_Click(object sender, System.EventArgs e)
  307. {
  308. Server.Transfer("ODepartment.aspx?DeptID=" + DeptID.ToString() + "&DisplayType=3");
  309. }
  311. private void cmdMove_Click(object sender, System.EventArgs e)
  312. {
  313. UDS.Components.Department dept = new UDS.Components.Department();
  315. switch(dept.MoveDeparement(DeptID,Int32.Parse(lstDeparment.Items[lstDeparment.SelectedIndex].Value)))
  316. {
  317. case 0:
  318. Response.Write("<script laguage='javascript'>alert('移动到" + lstDeparment.Items[lstDeparment.SelectedIndex].Text +" 部门成功！');</script>");
  319. Response.Redirect("ListView.aspx?DeptID="+DeptID+"&Refresh=1");
  320. break;
  321. case -1:
  322. Response.Write("<script laguage='javascript'>alert('不能移动到下级部门！');</script>");
  323. break;
  324. default:
  325. break;
  326. }
  328. }
  330. private void cmdReturn_Click(object sender, System.EventArgs e)
  331. {
  332. Server.Transfer("Listview.aspx?DeptID=" + DeptID.ToString());
  333. }
  336. }
  337. }