12345市长热线标准版-后端

T_Bus_WorkOrderReport.cs 4.3KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace CallCenterApi.BLL
  8. {
  9. public class T_Bus_WorkOrderReport
  10. {
  11. /// <summary>
  12. /// 区域
  13. /// </summary>
  14. /// <param name="dt"></param>
  15. /// <returns></returns>
  16. public List<Model.T_Bus_WorkOrderReport> DataTableToAreaList(DataTable dt)
  17. {
  18. List<Model.T_Bus_WorkOrderReport> list = new List<Model.T_Bus_WorkOrderReport>();
  19. if (dt.Rows.Count > 0)
  20. {
  21. foreach (DataRow r in dt.Rows)
  22. {
  23. list.Add(new Model.T_Bus_WorkOrderReport
  24. {
  25. WorkOrderId = r["F_WorkOrderId"] == DBNull.Value ? "" : r["F_WorkOrderId"].ToString(),
  26. WorkOrderState = r["F_WorkState"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_WorkState"]),
  27. FieldId = r["F_SourceArea"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_SourceArea"]),
  28. FieldName = r["F_AreaName"] == DBNull.Value ? "" : r["F_AreaName"].ToString()
  29. });
  30. }
  31. }
  32. return list;
  33. }
  34. /// <summary>
  35. /// 部门
  36. /// </summary>
  37. /// <param name="dt"></param>
  38. /// <returns></returns>
  39. public List<Model.T_Bus_WorkOrderReport> DataTableToDeptList(DataTable dt)
  40. {
  41. List<Model.T_Bus_WorkOrderReport> list = new List<Model.T_Bus_WorkOrderReport>();
  42. if (dt.Rows.Count > 0)
  43. {
  44. foreach (DataRow r in dt.Rows)
  45. {
  46. list.Add(new Model.T_Bus_WorkOrderReport
  47. {
  48. WorkOrderId = r["F_WorkOrderId"] == DBNull.Value ? "" : r["F_WorkOrderId"].ToString(),
  49. WorkOrderState = r["F_WorkState"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_WorkState"]),
  50. FieldId = r["F_MainDeptId"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_MainDeptId"]),
  51. FieldName = r["F_DeptName"] == DBNull.Value ? "" : r["F_DeptName"].ToString()
  52. });
  53. }
  54. }
  55. return list;
  56. }
  57. /// <summary>
  58. /// 工单类型
  59. /// </summary>
  60. /// <param name="dt"></param>
  61. /// <returns></returns>
  62. public List<Model.T_Bus_WorkOrderReport> DataTableToTypeList(DataTable dt)
  63. {
  64. List<Model.T_Bus_WorkOrderReport> list = new List<Model.T_Bus_WorkOrderReport>();
  65. if (dt.Rows.Count > 0)
  66. {
  67. foreach (DataRow r in dt.Rows)
  68. {
  69. list.Add(new Model.T_Bus_WorkOrderReport
  70. {
  71. WorkOrderId = r["F_WorkOrderId"] == DBNull.Value ? "" : r["F_WorkOrderId"].ToString(),
  72. WorkOrderState = r["F_WorkState"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_WorkState"]),
  73. FieldId = r["F_InfoType"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_InfoType"]),
  74. FieldName = r["F_Value"] == DBNull.Value ? "" : r["F_Value"].ToString()
  75. });
  76. }
  77. }
  78. return list;
  79. }
  80. /// <summary>
  81. /// 工单来源
  82. /// </summary>
  83. /// <param name="dt"></param>
  84. /// <returns></returns>
  85. public List<Model.T_Bus_WorkOrderReport> DataTableToSourceList(DataTable dt)
  86. {
  87. List<Model.T_Bus_WorkOrderReport> list = new List<Model.T_Bus_WorkOrderReport>();
  88. if (dt.Rows.Count > 0)
  89. {
  90. foreach (DataRow r in dt.Rows)
  91. {
  92. list.Add(new Model.T_Bus_WorkOrderReport
  93. {
  94. WorkOrderId = r["F_WorkOrderId"] == DBNull.Value ? "" : r["F_WorkOrderId"].ToString(),
  95. WorkOrderState = r["F_WorkState"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_WorkState"]),
  96. FieldId = r["F_InfoSource"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_InfoSource"]),
  97. FieldName = r["F_Value"] == DBNull.Value ? "" : r["F_Value"].ToString()
  98. });
  99. }
  100. }
  101. return list;
  102. }
  103. }
  104. }