DZKJTaskOneView.aspx.cs 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. using LYFZ.WeixinServiceDate.DAL;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Web;
  6. using System.Web.UI;
  7. using System.Web.UI.WebControls;
  8. using System.Data;
  9. namespace LYFZ.WeixinServers.DZKJ
  10. {
  11. public partial class DZKJTaskOneView : System.Web.UI.Page
  12. {
  13. public System.Text.StringBuilder TaskStatisticsViewListHtmlTb = new System.Text.StringBuilder();
  14. public string PagingInfoHtml = "";
  15. string Account = "";
  16. public string CompanyName = "";
  17. // string Token = "";
  18. int viewtype = -1;
  19. DateTime ExecDate = DateTime.Now;
  20. DAL_DZKJ_TaskExecutionStatistics dzkjTaskDal = new DAL_DZKJ_TaskExecutionStatistics();
  21. protected void Page_Load(object sender, EventArgs e)
  22. {
  23. if (Request.QueryString["viewtype"] != null)
  24. {
  25. try
  26. {
  27. viewtype = Convert.ToInt32(Request.QueryString["viewtype"].ToString());
  28. }
  29. catch { }
  30. }
  31. string ManagerProgramVersion = "爆客系统V1.8.3.1或更低";
  32. string SmallEifVersion = "小精灵V1.3.3或更低";
  33. if (Request.QueryString["Account"] != null)
  34. {
  35. Account = Request.QueryString["Account"].ToString();
  36. try
  37. {
  38. DataRow dzkjRow = Global.DZKJ_CustomerAccountDataTable.Rows.Find(Account);
  39. if (dzkjRow != null)
  40. {
  41. CompanyName = dzkjRow["CompanyName"].ToString();
  42. if (dzkjRow["ManagerProgramVersion"] != null && dzkjRow["ManagerProgramVersion"].ToString().Trim().Length > 1)
  43. {
  44. ManagerProgramVersion = "爆客系统V" + dzkjRow["ManagerProgramVersion"].ToString();
  45. }
  46. if (dzkjRow["SmallEifVersion"] != null && dzkjRow["SmallEifVersion"].ToString().Trim().Length > 1)
  47. {
  48. SmallEifVersion = "小精灵" + dzkjRow["SmallEifVersion"].ToString();
  49. }
  50. }
  51. }
  52. catch {
  53. CompanyName = "未知企业名";
  54. }
  55. }
  56. switch (viewtype)
  57. {
  58. case 0: CompanyName = CompanyName + "&nbsp;&nbsp;&nbsp;<br />帐号:&nbsp;&nbsp;【" + Account + "】&nbsp;&nbsp;<br />时间:" + ExecDate.ToString("yyyy年") + "&nbsp;&nbsp;<br />版本号:" + ManagerProgramVersion + "/"+SmallEifVersion+"&nbsp;统计"; break;
  59. case 1: CompanyName = CompanyName + "&nbsp;&nbsp;&nbsp;<br />帐号:&nbsp;&nbsp;【" + Account + "】&nbsp;&nbsp;<br />时间:" + ExecDate.ToString("yyyy年MM月") + "&nbsp;&nbsp;&nbsp;<br />版本号:" + ManagerProgramVersion + "/" + SmallEifVersion + "&nbsp;统计"; break;
  60. case 2: CompanyName = CompanyName + "&nbsp;&nbsp;&nbsp;<br />帐号:&nbsp;&nbsp;【" + Account + "】&nbsp;&nbsp;<br />时间:" + ExecDate.ToString("yyyy年MM月dd日") + "&nbsp;&nbsp;&nbsp;<br />版本号:" + ManagerProgramVersion + "/" + SmallEifVersion + "&nbsp;统计"; break;
  61. }
  62. try
  63. {
  64. if (Request.QueryString["ExecDate"] != null)
  65. {
  66. ExecDate = Convert.ToDateTime(Request.QueryString["ExecDate"].ToString());
  67. }
  68. }
  69. catch { }
  70. System.Data.DataTable tb = dzkjTaskDal.GetTaskExecutionOneDataTable(viewtype, ExecDate, Account);
  71. if (tb != null)
  72. {
  73. if (tb.Rows.Count > 0)
  74. {
  75. float maxExecutionCount = 0;
  76. if (tb.Rows[0]["ExecutionCount"] != null && !string.IsNullOrEmpty(tb.Rows[0]["ExecutionCount"].ToString()))
  77. {
  78. maxExecutionCount = Convert.ToInt32(tb.Rows[0]["ExecutionCount"].ToString());
  79. }
  80. if (maxExecutionCount > 10000)
  81. {
  82. maxExecutionCount = maxExecutionCount+1000;
  83. }
  84. else if (maxExecutionCount > 1000 && maxExecutionCount <= 10000)
  85. {
  86. maxExecutionCount = maxExecutionCount + 100;
  87. }
  88. else if (maxExecutionCount > 100 && maxExecutionCount <= 1000)
  89. {
  90. maxExecutionCount = maxExecutionCount + 10;
  91. }
  92. else if (maxExecutionCount <= 100)
  93. {
  94. maxExecutionCount = 100;
  95. }
  96. foreach (DataRow row in tb.Rows)
  97. {
  98. float ExecutionCount = 0;
  99. if (row["ExecutionCount"] != null && !string.IsNullOrEmpty(row["ExecutionCount"].ToString()))
  100. {
  101. ExecutionCount = Convert.ToInt32(row["ExecutionCount"].ToString());
  102. }
  103. float percentage = Convert.ToSingle((ExecutionCount / maxExecutionCount) * 100);
  104. /* if (ExecutionCount > 0 && percentage <= 0)
  105. {
  106. percentage = 1;
  107. }*/
  108. TaskStatisticsViewListHtmlTb.Append("<tr>"
  109. + " <td>" + row["Features"].ToString() + "</td>"
  110. + " <td>" + ExecutionCount.ToString() + "</td>"
  111. + " <td><div style=\"width:100%;height:16px; background-color:rgba(189, 246, 189, 0.1)\"><div style=\"width:" + percentage.ToString("n6") + "%;height:16px; background-color:green;\"></div></div></td>"
  112. + " </tr>");
  113. }
  114. }
  115. else {
  116. TaskStatisticsViewListHtmlTb.Append("<tr>"
  117. + " <td>当前时间内未使用</td>"
  118. + " <td></td>"
  119. + " <td></td>"
  120. + " <td></td>"
  121. + " </tr>");
  122. }
  123. }
  124. else {
  125. TaskStatisticsViewListHtmlTb.Append("<tr>"
  126. + " <td>数据查询失败</td>"
  127. + " <td></td>"
  128. + " <td></td>"
  129. + " <td></td>"
  130. + " </tr>");
  131. }
  132. }
  133. }
  134. }