/EQT_V1/EQTWebApp/TaskAdmin.aspx.cs

http://sgsoft-las.googlecode.com/ · C# · 121 lines · 92 code · 13 blank · 16 comment · 13 complexity · 862a5781eb3e5744fa8a21f2b3607cde MD5 · raw file

  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using EQT.Model;
  12. using EQT.Dal;
  13. using EQT.Bll;
  14. public partial class TaskAdmin : System.Web.UI.Page
  15. {
  16. private DaDept dalDept = new DaDept(DaCommon.DefaultDb);
  17. private DaEmployee daemp = new DaEmployee(DaCommon.DefaultDb);
  18. private DaReportAudit dara = new DaReportAudit(DaCommon.DefaultDb);
  19. protected void Page_Load(object sender, EventArgs e)
  20. {
  21. if (!Page.IsPostBack)
  22. {
  23. //??????????
  24. Utility.BindListCtl2Dic(DropDownListStatus, ContractStatusCollection.TesterGrpStatus);
  25. InitDefaultFitler();
  26. LoadTaskList();
  27. }
  28. }
  29. private void InitDefaultFitler()
  30. {
  31. DateTime default_begin_day = new DateTime(DateTime.Today.Year, 1, 1);
  32. TextBoxBegin.Text = default_begin_day.ToString(SiteConfig.DateFormat);
  33. TextBoxEnd.Text = DateTime.Now.AddDays(1).ToString(SiteConfig.DateFormat);
  34. DropDownListStatus.SelectedIndex = DropDownListStatus.Items.IndexOf(DropDownListStatus.Items.FindByValue(ContractStatus.ALL.ToString()));
  35. TextBoxReportId.Text = String.Empty;
  36. TextBoxCorpName.Text = String.Empty;
  37. }
  38. /// <summary>
  39. /// ??????
  40. /// </summary>
  41. private void LoadTaskList()
  42. {
  43. System.Text.StringBuilder sb = new System.Text.StringBuilder();
  44. //????????
  45. sb.Append(DaCoTestItem.SQL_GET_CO_TEST_ITEM);
  46. sb.Append(" WHERE ");
  47. sb.Append(Utility.GenerateQueryFilter2DateTime("Report_Create_Time", TextBoxBegin.Text, TextBoxEnd.Text));
  48. string filter = Utility.GenerateQueryFilterString("Report_ID", TextBoxReportId.Text, 2);
  49. if (filter != null) sb.AppendFormat(" AND {0} ", filter);
  50. filter = Utility.GenerateQueryFilterString("Corp_Name", TextBoxCorpName.Text, 2);
  51. if (filter != null) sb.AppendFormat(" AND {0} ", filter);
  52. sb.AppendFormat(" AND {0}", Utility.GenerateQueryFilterIntMaskAnd("Report_Status", "&", Int32.Parse(DropDownListStatus.SelectedValue)));
  53. string sql = sb.ToString();
  54. if (Utility.GlobalLog.IsDebugEnabled) Utility.GlobalLog.Debug(sql);
  55. int totalCount = 0;
  56. DataSet ds = DaCommon.GetPaginationData(sql,
  57. SiteConfig.PageSize, AspNetPager1.CurrentPageIndex - 1, "Report_Create_Time DESC", out totalCount);
  58. AspNetPager1.PageSize = SiteConfig.PageSize;
  59. AspNetPager1.RecordCount = totalCount;
  60. GridViewTestItems.DataSource = ds;
  61. GridViewTestItems.DataBind();
  62. }
  63. protected void AspNetPager1_PageChanged(object sender, EventArgs e)
  64. {
  65. LoadTaskList();
  66. }
  67. protected void btnFilterQuery_Click(object sender, EventArgs e)
  68. {
  69. AspNetPager1.CurrentPageIndex = 0;
  70. LoadTaskList();
  71. }
  72. protected void btnQueryAll_Click(object sender, EventArgs e)
  73. {
  74. AspNetPager1.CurrentPageIndex = 0;
  75. InitDefaultFitler();
  76. LoadTaskList();
  77. }
  78. /// <summary>
  79. /// ??????.????????????????????
  80. /// </summary>
  81. /// <param name="sender"></param>
  82. /// <param name="e"></param>
  83. protected void BtnAssignCoTestItem_Click(object sender, EventArgs e)
  84. {
  85. //????
  86. LoadTaskList();
  87. }
  88. /// <summary>
  89. /// ????????????????????????????
  90. /// </summary>
  91. /// <param name="sender"></param>
  92. /// <param name="e"></param>
  93. protected void GridViewTestItems_RowDataBound(object sender, GridViewRowEventArgs e)
  94. {
  95. if (e.Row.RowType == DataControlRowType.DataRow)
  96. {
  97. Button BtnAssignCoTestItem = e.Row.FindControl("BtnAssignCoTestItem") as Button;
  98. if (BtnAssignCoTestItem != null && BtnAssignCoTestItem.Visible)
  99. {
  100. DataRowView drv = e.Row.DataItem as DataRowView;
  101. int state = (int)drv["Test_Status"];
  102. BtnAssignCoTestItem.Visible = !(state >= (int)CoTestItemStatus.TestDone && state < (int)CoTestItemStatus.Untread);
  103. if(BtnAssignCoTestItem.Visible)
  104. BtnAssignCoTestItem.Attributes.Add("OnClick", "InvokePopSelectTester('" + drv["Item_Code"] + "','" + drv["Co_Item_ID"] + "')");
  105. }
  106. }
  107. }
  108. }