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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > .net编程 > 查看源码
SchAddUp.aspx.cs
资源名称：ASP[1].NET.rar　[点击查看]
上传用户：autodoor
上传日期：2022-08-04
资源大小：9973k
文件大小：13k
源码类别：

.net编程

开发平台：

Others

SchAddUp.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  4. using System.Web.UI.WebControls;
  5. using System.Web.UI.HtmlControls;
  7. using qminoa.Common.Data;
  8. using qminoa.DA.Schedule;
  9. namespace qminoa.Webs.Schedule
  10. {
  11. public class SchAddUp : qminoa.Webs.PageBase
  12. {
  13. protected System.Web.UI.WebControls.Image Image1;
  14. protected System.Web.UI.WebControls.TextBox txtSubject;
  15. protected System.Web.UI.WebControls.TextBox txtPlace;
  16. protected System.Web.UI.WebControls.TextBox txtScheType;
  17. protected System.Web.UI.WebControls.Image Image2;
  18. protected System.Web.UI.WebControls.Image Image3;
  19. protected System.Web.UI.WebControls.DropDownList dropPlace;
  20. protected System.Web.UI.WebControls.DropDownList dropType;
  21. protected System.Web.UI.WebControls.TextBox txtFDate;
  22. protected System.Web.UI.WebControls.TextBox txtTDate;
  23. protected System.Web.UI.WebControls.DropDownList dropFDate;
  24. protected System.Web.UI.WebControls.DropDownList dropTDate;
  25. protected System.Web.UI.WebControls.TextBox txtRemind;
  26. protected System.Web.UI.WebControls.CheckBox chkRemind;
  27. protected System.Web.UI.WebControls.TextBox txtContent;
  28. protected System.Web.UI.WebControls.LinkButton cmdType;
  29. protected System.Web.UI.WebControls.LinkButton cmdPlace;
  30. protected System.Web.UI.WebControls.CheckBox chkPrivte;
  31. protected System.Web.UI.WebControls.DropDownList dropRequenCate;
  32. protected System.Web.UI.WebControls.CheckBox chkRepeat;
  33. protected System.Web.UI.WebControls.TextBox txtUpToDate;
  34. protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
  35. protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
  36. protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
  37. protected System.Web.UI.WebControls.Label lblAuthorV;
  38. protected System.Web.UI.WebControls.Label lblCDateV;
  39. protected System.Web.UI.WebControls.ImageButton cmdSchedMsgDel;
  40. protected System.Web.UI.WebControls.TextBox txtOtherMan;
  41. protected System.Web.UI.WebControls.RangeValidator RangeValidator5;
  42. protected System.Web.UI.WebControls.RangeValidator RangeValidator6;
  43. protected System.Web.UI.WebControls.RangeValidator RangeValidator7;
  44. protected System.Web.UI.WebControls.RangeValidator RangeValidator8;
  45. protected System.Web.UI.WebControls.ImageButton cmdSaveExi;
  46. protected System.Web.UI.WebControls.ImageButton cmdDel;
  47. protected System.Web.UI.WebControls.ImageButton cmdExit;
  48. protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
  49. protected System.Web.UI.HtmlControls.HtmlButton cmdScheOMan;
  50. protected System.Web.UI.WebControls.CheckBox chkImp;
  52. private ScheduleDA scheduleDadaAccess = new ScheduleDA();
  53. private int scheid = 0;
  54. private static string reurl = "";
  55. private static DateTime date = new DateTime();
  57. private void Page_Load(object sender, System.EventArgs e)
  58. {
  59. this.PageBegin("我的日程",false);
  60. reurl = Request.QueryString["reurl"];
  61. if(Request.QueryString["day"] != null)
  62. {
  63. date = DateTime.Parse(Request.QueryString["day"]);
  64. }
  65. if(Request.QueryString["id"] != null)
  66. {
  67. scheid = Int32.Parse(Request.QueryString["id"]);
  68. }
  69. cmdSchedMsgDel.Attributes.Add("onclick", "return confirm('确定要删除吗？');");
  70. if(!IsPostBack)
  71. {
  72. txtRemind.Enabled = chkRemind.Checked;
  73. txtUpToDate.Enabled = chkRepeat.Checked;
  74. dropRequenCate.Enabled = chkRepeat.Checked;
  75. txtFDate.Text = date.ToString("d");
  76. txtTDate.Text = date.ToString("d");
  77. dropPlace.DataSource = scheduleDadaAccess.dropPlacebind();
  78. dropPlace.DataBind();
  79. dropType.DataSource = scheduleDadaAccess.dropTypebind();
  80. dropType.DataBind();
  81. dropPlace.SelectedIndex = 0;
  82. dropType.SelectedIndex = 0;
  83. if(Request.QueryString["id"] != null)
  84. {
  85. scheid = Int32.Parse(Request.QueryString["id"]);
  86. FillPage();
  87. if(scheduleDadaAccess.IsMySchedule(Convert.ToInt16(this.Empid),scheid) == 0)
  88. {
  89. cmdDel.Visible = true;
  90. }
  91. else
  92. {
  93. cmdSaveExi.Visible = false;
  94. cmdDel.Visible = false;
  95. ReadOnly();
  96. }
  97. }
  98. }
  99. }
  101. private void ReadOnly()
  102. {
  103. txtSubject.ReadOnly = true;
  104. txtPlace.ReadOnly = true;
  105. txtScheType.ReadOnly = true;
  106. txtFDate.ReadOnly = true;
  107. txtTDate.ReadOnly = true;
  108. txtContent.ReadOnly = true;
  109. txtOtherMan.ReadOnly = true;
  110. txtUpToDate.ReadOnly = true;
  111. txtRemind.ReadOnly = true;
  112. dropPlace.Enabled = false;
  113. dropType.Enabled = false;
  114. dropFDate.Enabled = false;
  115. dropTDate.Enabled = false;
  116. chkRemind.Enabled = false;
  117. chkPrivte.Enabled = false;
  118. chkRepeat.Enabled = false;
  119. dropRequenCate.Enabled = false;
  120. cmdPlace.Enabled = false;
  121. cmdType.Enabled = false;
  122. cmdScheOMan.Disabled = false;
  123. }
  125. #region Web Form Designer generated code
  126. override protected void OnInit(EventArgs e)
  127. {
  128. //
  129. // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
  130. //
  131. InitializeComponent();
  132. base.OnInit(e);
  133. }
  135. /// <summary>
  136. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  137. /// 此方法的内容。
  138. /// </summary>
  139. private void InitializeComponent()
  140. {    
  141. this.cmdSaveExi.Click += new System.Web.UI.ImageClickEventHandler(this.cmdSaveExi_Click);
  142. this.cmdDel.Click += new System.Web.UI.ImageClickEventHandler(this.cmdDel_Click);
  143. this.cmdExit.Click += new System.Web.UI.ImageClickEventHandler(this.cmdExit_Click);
  144. this.dropPlace.SelectedIndexChanged += new System.EventHandler(this.dropPlace_SelectedIndexChanged);
  145. this.dropType.SelectedIndexChanged += new System.EventHandler(this.dropType_SelectedIndexChanged);
  146. this.dropFDate.SelectedIndexChanged += new System.EventHandler(this.dropFDate_SelectedIndexChanged);
  147. this.chkRemind.CheckedChanged += new System.EventHandler(this.chkRemind_CheckedChanged);
  148. this.cmdType.Click += new System.EventHandler(this.cmdType_Click);
  149. this.cmdPlace.Click += new System.EventHandler(this.cmdPlace_Click);
  150. this.chkRepeat.CheckedChanged += new System.EventHandler(this.chkRepeat_CheckedChanged);
  151. this.cmdSchedMsgDel.Click += new System.Web.UI.ImageClickEventHandler(this.cmdSchedMsgDel_Click);
  152. this.Load += new System.EventHandler(this.Page_Load);
  154. }
  155. #endregion
  157. private void FillPage()
  158. {
  159. DataTable empTB = (new ScheduleDA()).cpMySch(scheid).Tables[0];
  160. DataRow row = empTB.Rows[0];
  161. txtSubject.Text = row[ScheduleData.SUBJECT_FIELD].ToString();
  162. txtScheType.Text = row[ScheduleData.SCHTYPE_FIELD].ToString();
  163. txtPlace.Text = row[ScheduleData.PLACE_FIELD].ToString();
  164. txtFDate.Text = DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).ToString("d");
  165. txtTDate.Text = DateTime.Parse(row[ScheduleData.TDATE_FIELD].ToString()).ToString("d");
  166. string txtfdate_time = DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Hour + ":" + DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Minute;
  167. string txttdate_time = DateTime.Parse(row[ScheduleData.TDATE_FIELD].ToString()).Hour + ":" + DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Minute;
  168. for(int i = 0;i < dropFDate.Items.Count;i ++)
  169. {
  170. if(dropFDate.Items[i].Text.Trim('0') == txtfdate_time.Trim('0'))
  171. {
  172. dropFDate.SelectedIndex = i;
  173. }
  174. }
  175. for(int j = 0;j < dropTDate.Items.Count;j ++)
  176. {
  177. if(dropTDate.Items[j].Text.Trim('0') == txttdate_time.Trim('0'))
  178. {
  179. dropTDate.SelectedIndex = j;
  180. }
  181. }
  182. chkRemind.Checked = bool.Parse(row[ScheduleData.REMINDFLAG_FIELD].ToString());
  183. txtRemind.Text = row[ScheduleData.REMINDDAY_FIELD].ToString();
  184. txtContent.Text = row[ScheduleData.CONTENT_FIELD].ToString();
  185. lblAuthorV.Text = row["EmpName"].ToString();
  186. lblCDateV.Text = DateTime.Parse(row[ScheduleData.CDATE_FIELD].ToString()).ToString("g");
  187. chkPrivte.Checked = bool.Parse(row[ScheduleData.PRIVFLAG_FIELD].ToString());
  188. chkRepeat.Checked = bool.Parse(row[ScheduleData.REPEATFLAG_FIELD].ToString());
  189. if(row[ScheduleData.REQUENCATE_FIELD] != DBNull.Value)
  190. dropRequenCate.SelectedIndex = Convert.ToInt16(row[ScheduleData.REQUENCATE_FIELD].ToString());
  191. if(row[ScheduleData.UPTODATE_FIELD] != DBNull.Value)
  192. txtUpToDate.Text = DateTime.Parse(row[ScheduleData.UPTODATE_FIELD].ToString()).ToString("d");
  193. txtRemind.Enabled = chkRemind.Checked;
  194. txtUpToDate.Enabled = chkRepeat.Checked;
  195. dropRequenCate.Enabled = chkRepeat.Checked;
  197. SqlCommand objcommand = new SqlCommand();
  198. SqlDataReader cpread;
  199. objcommand = scheduleDadaAccess.cpOtherManRead(scheid);
  200. objcommand.Connection.Open();
  201. cpread = objcommand.ExecuteReader();
  202. while(cpread.Read())
  203. {
  204. txtOtherMan.Text += cpread.GetValue(0).ToString() + ";";
  205. }
  206. cpread.Close();
  207. objcommand.Connection.Close();
  208. }
  210. private void cmdPlace_Click(object sender, System.EventArgs e)
  211. {
  212. txtPlace.Text = dropPlace.SelectedItem.Text;
  214. if (txtPlace.Visible == true)
  215. {
  216. txtPlace.Visible = false;
  217. dropPlace.Visible = true;
  218. }
  219. else
  220. {
  221. txtPlace.Visible = true;
  222. dropPlace.Visible = false;
  223. }
  224. }
  226. private void cmdType_Click(object sender, System.EventArgs e)
  227. {
  228. txtScheType.Text = dropType.SelectedItem.Text;
  230. if (txtScheType.Visible == true)
  231. {
  232. txtScheType.Visible = false;
  233. dropType.Visible = true;
  234. }
  235. else
  236. {
  237. txtScheType.Visible = true;
  238. dropType.Visible = false;
  239. }
  240. }
  242. private void dropFDate_SelectedIndexChanged(object sender, System.EventArgs e)
  243. {
  244. dropTDate.SelectedIndex = dropFDate.SelectedIndex;
  245. }
  247. private void cmdSaveExi_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  248. {
  249. ScheduleData scheData = new ScheduleData();
  250. DataTable scheTB = scheData.Tables[ScheduleData.SCHEDULE_TABLE];
  251. DataRow row = scheTB.NewRow();
  252. scheTB.Rows.Add(row);
  253. scheTB.AcceptChanges();
  254. row[ScheduleData.SUBJECT_FIELD] = txtSubject.Text;
  255. row[ScheduleData.PLACE_FIELD] = txtPlace.Text;
  256. row[ScheduleData.SCHTYPE_FIELD] = txtScheType.Text;
  257. row[ScheduleData.FDATE_FIELD] = DateTime.Parse(txtFDate.Text + " " + dropFDate.SelectedItem.Text);
  258. row[ScheduleData.TDATE_FIELD] = DateTime.Parse(txtTDate.Text + " " + dropTDate.SelectedItem.Text);
  259. row[ScheduleData.CONTENT_FIELD] = txtContent.Text;
  260. row[ScheduleData.REMINDFLAG_FIELD] = chkRemind.Checked;
  261. row[ScheduleData.PRIVFLAG_FIELD] = chkPrivte.Checked;
  262. row[ScheduleData.REPEATFLAG_FIELD] = chkRepeat.Checked;
  263. if(chkRemind.Checked == true)
  264. {
  265. row[ScheduleData.REMINDDAY_FIELD] = Int16.Parse(txtRemind.Text);
  266. }
  267. if(chkRepeat.Checked ==true)
  268. {
  269. row[ScheduleData.REQUENCATE_FIELD] = dropRequenCate.SelectedIndex;
  270. if(txtUpToDate.Text != "")
  271. {
  272. row[ScheduleData.UPTODATE_FIELD] = DateTime.Parse(txtUpToDate.Text);
  273. }
  274. }
  275. row[ScheduleData.EMPID_FIELD] = Convert.ToInt16(this.Empid);
  276. if(scheid == 0)
  277. {
  278. int _schid = scheduleDadaAccess.ScheduleAdd(scheData);
  279. SaveOtherSchedule(_schid);
  280. }
  281. else
  282. {
  283. row[ScheduleData.SCHID_FIELD] = scheid;
  284. scheduleDadaAccess.ScheduleUpdate(scheData);
  285. SaveOtherSchedule(scheid);
  286. }
  287. Response.Redirect(reurl+"?date="+date);
  288. }
  290. private void cmdDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  291. {    
  292. scheduleDadaAccess.cpSchDel(scheid);
  293. Response.Redirect(reurl+"?date="+date);
  294. }
  296. private void cmdExit_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  297. {
  298. Response.Redirect(reurl+"?date="+date);
  299. }
  301. private void SaveOtherSchedule(int schid)
  302. {
  303. scheduleDadaAccess.cpDelOtherMan(schid);
  304. string txtotherman;
  305. txtotherman = txtOtherMan.Text;
  306. string[] otherman = txtotherman.Split(new char[] {';'});
  307. for(int i = 0;i < otherman.Length - 1;i ++)
  308. {
  309. scheduleDadaAccess.cpOtherManAddUp(schid,otherman[i]);
  310. }
  311. }
  313. private void chkRepeat_CheckedChanged(object sender, System.EventArgs e)
  314. {
  315. dropRequenCate.Enabled = chkRepeat.Checked;
  316. txtUpToDate.Enabled = chkRepeat.Checked;
  317. }
  319. private void chkRemind_CheckedChanged(object sender, System.EventArgs e)
  320. {
  321. txtRemind.Enabled = chkRemind.Checked;
  322. }
  324. private void dropPlace_SelectedIndexChanged(object sender, System.EventArgs e)
  325. {
  326. dropPlace.Visible = false;
  327. txtPlace.Visible = true;
  328. txtPlace.Text = dropPlace.SelectedItem.Text;
  329. }
  331. private void dropType_SelectedIndexChanged(object sender, System.EventArgs e)
  332. {
  333. dropType.Visible = false;
  334. txtScheType.Visible = true;
  335. txtScheType.Text = dropType.SelectedItem.Text;
  336. }
  338. private void cmdSchedMsgDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  339. {
  340. scheduleDadaAccess.cpDelOtherMan(scheid);
  341. txtOtherMan.Text = "";
  342. }
  343. }
  344. }