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

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

.net编程

开发平台：

Others

TimeEntry.aspx.cs：源码内容
  1. using System;
  2. using System.Collections;
  3. using System.Data;
  4. using System.Text;
  5. using System.Web.UI.WebControls;
  7. using qminoa.BLL;
  8. using qminoa.Common.Data;
  9. using qminoa.BLL.PM;
  10. using qminoa.DA;
  12. namespace qminoa.Webs.PM
  13. {
  14. public class TimeEntry : qminoa.Webs.PageBase
  15. {
  16. protected qminoa.BLL.PM.TimeEntry _userInput = new qminoa.BLL.PM.TimeEntry(0, 0, 0, 0, DateTime.MinValue, null, -1M);
  17. protected DataTable _dayListTable = null;
  18. private PMUser  _user;
  19. private DateTime _weekEndingDate = DateTime.Today;
  20. private DateTime _weekStartingDate = DateTime.Today;
  22. protected System.Web.UI.WebControls.Button AddEntry;
  23. protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
  24. protected System.Web.UI.WebControls.Button Cancel;
  25. protected System.Web.UI.WebControls.DropDownList CategoryList;
  26. protected System.Web.UI.WebControls.DropDownList Days;
  27. protected System.Web.UI.WebControls.TextBox Description;
  28. protected System.Web.UI.WebControls.TextBox Hours;
  29. protected System.Web.UI.WebControls.DropDownList ProjectList;
  30. protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
  31. protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator1;
  32. protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
  33. protected System.Web.UI.WebControls.DataGrid TimeEntryGrid;
  34. protected System.Web.UI.WebControls.DropDownList UserList;
  35. protected System.Web.UI.WebControls.TextBox WeekEnding;
  36. protected System.Web.UI.WebControls.DropDownList BranchDropList;
  37. protected System.Web.UI.WebControls.DropDownList DepartmentDropList;
  39. private void Page_Load(object sender, System.EventArgs e)
  40. {
  41. this.PageBegin("项目管理",true);
  42. _user = new PMUser(Convert.ToInt16(this.Empid));
  43. if (!Page.IsPostBack)
  44. {
  45. BLL.PM.TimeEntry.FillCorrectStartEndDates(DateTime.Today, 
  46. ref _weekStartingDate, ref _weekEndingDate);
  47. WeekEnding.Text = _weekEndingDate.ToShortDateString();
  48. BindUserList();
  49. BindEntryFields();
  50. BindTimeSheet(_user.UserID, _weekStartingDate, _weekEndingDate);
  51. }
  52. else
  53. {
  54. BLL.PM.TimeEntry.FillCorrectStartEndDates(Convert.ToDateTime(WeekEnding.Text), 
  55. ref _weekStartingDate, ref _weekEndingDate);
  56. _dayListTable = BLL.PM.TimeEntry.GetWeek(Convert.ToDateTime(WeekEnding.Text));
  57. }
  58. }
  60. private void BindCategoryList()
  61. {
  62. if (ProjectList.SelectedItem != null) 
  63. {
  64. CategoryList.DataSource = Project.GetCategories(Convert.ToInt32(ProjectList.SelectedItem.Value));
  65. CategoryList.DataValueField = "CategoryID";
  66. CategoryList.DataTextField = "Abbreviation";
  67. CategoryList.DataBind();
  68. }
  69. }
  71. private void BindDates()
  72. {
  73. _dayListTable = BLL.PM.TimeEntry.GetWeek(Convert.ToDateTime(WeekEnding.Text));
  74. Days.DataSource = _dayListTable;
  75. Days.DataValueField = "Date";
  76. Days.DataTextField = "Day";
  77. Days.DataBind();
  78. Days.Items.FindByText(Convert.ToDateTime(DateTime.Today).ToString("ddd")).Selected= true;
  79. }
  81. private void BindEntryFields()
  82. {
  83. BindDates();
  84. BindProjectList();
  85. BindCategoryList();
  86. }
  88. private void BindProjectList()
  89. {
  90. if (ProjectList.SelectedItem != null)
  91. _userInput.ProjectID = Convert.ToInt32(ProjectList.SelectedItem.Value);
  93. ProjectList.DataSource = ListUserProjects();
  94. ProjectList.DataTextField = "Name";
  95. ProjectList.DataValueField = "ProjectID";
  96. ProjectList.DataBind();
  98. if (ProjectList.Items.FindByValue(_userInput.ProjectID.ToString()) != null)
  99. ProjectList.Items.FindByValue(_userInput.ProjectID.ToString()).Selected = true;
  100. }
  102. private void BindTimeSheet(int userID, DateTime start, DateTime end)
  103. {
  104. BindTimeSheet(userID, userID, start, end);
  105. }
  107. private void BindTimeSheet(int queryUserID, int userID, DateTime start, DateTime end)
  108. {
  109. TimeEntriesCollection entryList = BLL.PM.TimeEntry.GetEntries(queryUserID, userID, start, end);
  111. if (entryList != null) 
  112. {
  113. SortGridData(entryList, SortField, SortAscending);
  114. }
  115. TimeEntryGrid.DataSource = entryList;
  116. TimeEntryGrid.DataBind();
  117. }
  119. private void BindUserList()
  120. {
  121. DataTable empTB = (new EmpSystem()).GetEmpTB_By_EmpID(_user.UserID);
  122. DataRow row = empTB.Rows[0];
  123. int depID = (int)row[DepData.DEPID_FIELD];
  124. DataTable depTB = (new DepSystem()).GetDepTB_By_DepID(depID);
  125. row = depTB.Rows[0];
  126. int branchID = (int)row[DepData.BRANCHID_FIELD];
  128. AdminDB admin = new AdminDB();
  129. BranchDropList.DataSource=admin.GetAllBranch();
  130. BranchDropList.DataBind();
  131. BranchDropList.Items.FindByValue(branchID.ToString()).Selected=true;
  133. DepartmentDropList.DataSource=admin.GetDepByBranch(Int32.Parse(BranchDropList.SelectedItem.Value));
  134. DepartmentDropList.DataBind();
  135. DepartmentDropList.Items.FindByValue(depID.ToString()).Selected=true;
  137. UserList.DataSource = PMUser.GetUsers(_user.UserID, _user.Role,Int32.Parse(DepartmentDropList.SelectedItem.Value));
  138. UserList.DataBind();
  140. UserList.Items.FindByValue(_user.UserID.ToString()).Selected=true;
  141. }
  143. private void ClearEntryFields()
  144. {
  145. BindEntryFields();
  147. TimeEntryGrid.EditItemIndex = -1;
  149. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  150. Description.Text = string.Empty;
  151. Hours.Text = string.Empty;
  152. }
  154. protected CategoriesCollection ListGridCategories(int projectID)
  155. {
  156. return BLL.PM.Project.GetCategories(projectID);
  157. }
  159. protected ProjectsCollection ListUserProjects()
  160. {
  161. return BLL.PM.Project.GetProjects(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value));
  162. }
  164. private void SortGridData(TimeEntriesCollection list, string sortField, bool asc)
  165. {
  166. TimeEntriesCollection.TimeEntryFields sortCol = TimeEntriesCollection.TimeEntryFields.InitValue;
  168. switch(sortField)
  169. {
  170. case "EntryDate":
  171. sortCol = TimeEntriesCollection.TimeEntryFields.Day;
  172. break;
  173. case "ProjectName":
  174. sortCol = TimeEntriesCollection.TimeEntryFields.Project;
  175. break;
  176. case "CategoryName":
  177. sortCol = TimeEntriesCollection.TimeEntryFields.Category;
  178. break;
  179. case "Duration":
  180. sortCol = TimeEntriesCollection.TimeEntryFields.Hours;
  181. break;
  182. case "Description":
  183. sortCol = TimeEntriesCollection.TimeEntryFields.Description;
  184. break;
  185. default:
  186. break;
  187. }
  189. list.Sort(sortCol, asc);
  190. }
  192. #region Web Form Designer generated code
  193. override protected void OnInit(EventArgs e)
  194. {
  195. //
  196. // CODEGEN: This call is required by the ASP.NET Web Form Designer.
  197. //
  198. InitializeComponent();
  199. base.OnInit(e);
  200. }
  202. /// <summary>
  203. /// Required method for Designer support - do not modify
  204. /// the contents of this method with the code editor.
  205. /// </summary>
  206. private void InitializeComponent()
  207. {    
  208. this.WeekEnding.TextChanged += new System.EventHandler(this.WeekEnding_TextChanged);
  209. this.ProjectList.SelectedIndexChanged += new System.EventHandler(this.ProjectList_SelectedIndexChanged);
  210. this.AddEntry.Click += new System.EventHandler(this.AddEntry_Click);
  211. this.Cancel.Click += new System.EventHandler(this.Cancel_Click);
  212. this.BranchDropList.SelectedIndexChanged += new System.EventHandler(this.BranchDropList_SelectedIndexChanged);
  213. this.DepartmentDropList.SelectedIndexChanged += new System.EventHandler(this.DepartmentDropList_SelectedIndexChanged);
  214. this.UserList.SelectedIndexChanged += new System.EventHandler(this.UserList_OnChange);
  215. this.TimeEntryGrid.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.TimeEntryGrid_OnCancel);
  216. this.TimeEntryGrid.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.TimeEntryGrid_OnEdit);
  217. this.TimeEntryGrid.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.TimeEntryGrid_Sort);
  218. this.TimeEntryGrid.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.TimeEntryGrid_OnUpdate);
  219. this.TimeEntryGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.TimeEntryGrid_OnDelete);
  220. this.TimeEntryGrid.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.TimeEntryGrid_Itembound);
  221. this.Load += new System.EventHandler(this.Page_Load);
  223. }
  224. #endregion
  226. private void AddEntry_Click(object sender, System.EventArgs e)
  227. {
  228. Requiredfieldvalidator1.Validate();
  229. RequiredFieldValidator2.Validate();
  230. RangeValidator1.Validate();
  231. CompareValidator1.Validate();
  233. if (Requiredfieldvalidator1.IsValid && RequiredFieldValidator2.IsValid && CompareValidator1.IsValid && RangeValidator1.IsValid) 
  234. {
  235. BLL.PM.TimeEntry te = new BLL.PM.TimeEntry(0, 
  236. Convert.ToInt32(UserList.SelectedItem.Value), 
  237. Convert.ToInt32(ProjectList.SelectedItem.Value),
  238. Convert.ToInt32(CategoryList.SelectedItem.Value), 
  239. Convert.ToDateTime(Days.SelectedItem.Value), 
  240. Description.Text, Convert.ToDecimal(Hours.Text));
  241. te.Save(); 
  242. ClearEntryFields();
  243. }
  244. }
  246. private void Cancel_Click(object sender, System.EventArgs e)
  247. {
  248. ClearEntryFields();
  249. }
  251. private void ProjectList_SelectedIndexChanged(object sender, System.EventArgs e)
  252. {
  253. BindCategoryList();
  254. }
  256. private void TimeEntryGrid_Itembound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  257. {
  258. if (e.Item.ItemType == ListItemType.EditItem) 
  259. {
  260. DropDownList currentCbo = (DropDownList) e.Item.FindControl("EntryDays");
  261. currentCbo.SelectedIndex = currentCbo.Items.IndexOf(currentCbo.Items.FindByText(_userInput.Day));
  263. currentCbo = (DropDownList) e.Item.FindControl("EntryProjects");
  264. currentCbo.SelectedIndex = currentCbo.Items.IndexOf(currentCbo.Items.FindByText(_userInput.ProjectName));
  266. currentCbo = (DropDownList) e.Item.FindControl("EntryCategories");
  267. currentCbo.SelectedIndex = currentCbo.Items.IndexOf(currentCbo.Items.FindByText(_userInput.CategoryName));
  268. }
  269. }
  271. protected void TimeEntryGrid_OnCancel(Object sender, DataGridCommandEventArgs e)
  272. {
  273. TimeEntryGrid.EditItemIndex = -1;
  274. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  275. }
  277. protected void TimeEntryGrid_OnDelete(Object sender, DataGridCommandEventArgs e)
  278. {
  279. int entryLogID = Convert.ToInt32(TimeEntryGrid.DataKeys[(int)e.Item.ItemIndex]);
  280. BLL.PM.TimeEntry.Remove(entryLogID);
  281. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  282. }
  284. protected void TimeEntryGrid_OnEdit(Object sender, DataGridCommandEventArgs e)
  285. {
  286. TimeEntryGrid.EditItemIndex = e.Item.ItemIndex;
  287. _userInput.Day = ((Label) e.Item.FindControl("EntryDay")).Text;
  288. _userInput.ProjectName = ((Label) e.Item.FindControl("EntryProject")).Text.Trim();
  289. _userInput.ProjectID = Convert.ToInt32(((Label) e.Item.FindControl("EntryProjectID")).Text);
  290. _userInput.CategoryName = ((Label) e.Item.FindControl("EntryCategory")).Text.Trim();
  291. _userInput.Duration = Convert.ToDecimal(((Label) e.Item.FindControl("EntryDuration")).Text);
  292. _userInput.Description = ((Label) e.Item.FindControl("GridDescription")).Text.Trim();
  293. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  294. }
  296. protected void TimeEntryGrid_OnUpdate(Object sender, DataGridCommandEventArgs e)
  297. {
  298. DataGridItem item = TimeEntryGrid.Items[TimeEntryGrid.EditItemIndex];
  300. RequiredFieldValidator required = (RequiredFieldValidator) item.FindControl("RequiredFieldValidatorGridHours");
  301. CompareValidator comparer = (CompareValidator) item.FindControl("CompareValidatorGridHours");
  303. required.Validate();
  304. comparer.Validate();
  306. if (required.IsValid && comparer.IsValid) 
  307. {
  308. int entryLogID;
  309. int userID;
  310. int projectID;
  311. int categoryID;
  312. DateTime taskDate;
  313. string description;
  314. decimal duration;
  315. BLL.PM.TimeEntry te = null;
  317. entryLogID = Convert.ToInt32(TimeEntryGrid.DataKeys[(int)e.Item.ItemIndex]);
  318. userID = Convert.ToInt32(UserList.SelectedItem.Value);
  319. projectID = Convert.ToInt32(((DropDownList) e.Item.FindControl("EntryProjects")).SelectedItem.Value);
  320. categoryID = Convert.ToInt32(((DropDownList) e.Item.FindControl("EntryCategories")).SelectedItem.Value);
  321. taskDate = Convert.ToDateTime(((DropDownList) e.Item.FindControl("EntryDays")).SelectedItem.Value);
  322. description = ((TextBox) e.Item.FindControl("EntryDescription")).Text;//TTSecurity.CleanStringRegex(((TextBox) e.Item.FindControl("EntryDescription")).Text);
  323. duration = Convert.ToDecimal(((TextBox) e.Item.FindControl("EntryHours")).Text);
  325. te = new BLL.PM.TimeEntry(entryLogID, userID, projectID, categoryID, taskDate, description, duration);
  326. te.Save();
  328. TimeEntryGrid.EditItemIndex = -1;
  329. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  330. }
  331. }
  333. private void TimeEntryGrid_Sort(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
  334. {
  335. TimeEntryGrid.EditItemIndex = -1;
  336. SortField = e.SortExpression;
  337. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  338. }
  340. protected void UserProjects_OnChange(object sender, System.EventArgs e)
  341. {
  342. DataGridItem item = TimeEntryGrid.Items[TimeEntryGrid.EditItemIndex];
  344. if (item != null)
  345. {
  346. TextBox txt = (TextBox) item.FindControl("EntryHours");
  347. _userInput.Duration = Convert.ToDecimal(txt.Text);
  349. TextBox txtDesc = (TextBox) item.FindControl("EntryDescription");
  350. _userInput.Description = txtDesc.Text;
  352. DropDownList EntryDays = (DropDownList)item.FindControl("EntryDays");
  353. _userInput.EntryDate = Convert.ToDateTime(EntryDays.SelectedItem.Value);
  354. _userInput.Day = EntryDays.SelectedItem.Text;
  356. }
  357. DropDownList EntryProjects = (DropDownList) sender;
  358. _userInput.ProjectID = Convert.ToInt32(EntryProjects.SelectedItem.Value);
  359. _userInput.ProjectName = EntryProjects.SelectedItem.Text;
  360. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  361. }
  363. private void UserList_OnChange(object sender, System.EventArgs e)
  364. {
  365. TimeEntryGrid.EditItemIndex = -1;
  366. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  367. BindEntryFields();
  368. }
  370. private void WeekEnding_TextChanged(object sender, System.EventArgs e)
  371. {
  372. TimeEntryGrid.EditItemIndex = -1;
  373. BLL.PM.TimeEntry.FillCorrectStartEndDates(Convert.ToDateTime(WeekEnding.Text), 
  374. ref _weekStartingDate, ref _weekEndingDate);
  375. WeekEnding.Text = _weekEndingDate.ToShortDateString();
  376. BindEntryFields();
  377. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  378. }
  380. private void BranchDropList_SelectedIndexChanged(object sender, System.EventArgs e)
  381. {
  382. AdminDB admin = new AdminDB();
  383. DepartmentDropList.DataSource=admin.GetDepByBranch(Int32.Parse(BranchDropList.SelectedItem.Value));
  384. DepartmentDropList.DataBind();
  385. if(DepartmentDropList.Items.Count !=0)
  386. {
  387. UserList.DataSource = PMUser.GetUsers(_user.UserID, _user.Role,Int32.Parse(DepartmentDropList.SelectedItem.Value));
  388. UserList.DataBind();
  389. UserList.Items[0].Selected = true;
  390. TimeEntryGrid.EditItemIndex = -1;
  391. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  392. BindEntryFields();
  393. }
  394. else
  395. {
  396. BindTimeSheet(_user.UserID, 0, _weekStartingDate, _weekEndingDate);
  397. UserList.Items.Clear();
  398. ProjectList.Items.Clear();
  399. }
  400. }
  402. private void DepartmentDropList_SelectedIndexChanged(object sender, System.EventArgs e)
  403. {
  404. if(DepartmentDropList.Items.Count !=0)
  405. {
  406. UserList.DataSource = PMUser.GetUsers(_user.UserID, _user.Role,Int32.Parse(DepartmentDropList.SelectedItem.Value));
  407. UserList.DataBind();
  408. UserList.Items[0].Selected = true;
  409. TimeEntryGrid.EditItemIndex = -1;
  410. BindTimeSheet(_user.UserID, Convert.ToInt32(UserList.SelectedItem.Value), _weekStartingDate, _weekEndingDate);
  411. BindEntryFields();
  412. }
  413. else
  414. {
  415. BindTimeSheet(_user.UserID, 0, _weekStartingDate, _weekEndingDate);
  416. UserList.Items.Clear();
  417. ProjectList.Items.Clear();
  418. }
  419. }
  421. string SortField 
  422. {
  423. get 
  424. {
  425. object o = ViewState["SortField"];
  426. if (o == null) 
  427. {
  428. return String.Empty;
  429. }
  430. return (string)o;
  431. }
  433. set 
  434. {
  435. if (value == SortField) 
  436. {
  437. SortAscending = !SortAscending;
  438. }
  439. ViewState["SortField"] = value;
  440. }
  441. }
  443. bool SortAscending 
  444. {
  445. get 
  446. {
  447. object o = ViewState["SortAscending"];
  448. if (o == null) 
  449. {
  450. return true;
  451. }
  452. return (bool)o;
  453. }
  455. set 
  456. {
  457. ViewState["SortAscending"] = value;
  458. }
  459. }
  460. }
  461. }