| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110 |
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace CallCenterApi.BLL
- {
- public class T_Bus_WorkOrderReport
- {
- /// <summary>
- /// 区域
- /// </summary>
- /// <param name="dt"></param>
- /// <returns></returns>
- public List<Model.T_Bus_WorkOrderReport> DataTableToAreaList(DataTable dt)
- {
- List<Model.T_Bus_WorkOrderReport> list = new List<Model.T_Bus_WorkOrderReport>();
- if (dt.Rows.Count > 0)
- {
- foreach (DataRow r in dt.Rows)
- {
- list.Add(new Model.T_Bus_WorkOrderReport
- {
- WorkOrderId = r["F_WorkOrderId"] == DBNull.Value ? "" : r["F_WorkOrderId"].ToString(),
- WorkOrderState = r["F_WorkState"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_WorkState"]),
- FieldId = r["F_SourceArea"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_SourceArea"]),
- FieldName = r["F_AreaName"] == DBNull.Value ? "" : r["F_AreaName"].ToString()
- });
- }
- }
- return list;
- }
- /// <summary>
- /// 部门
- /// </summary>
- /// <param name="dt"></param>
- /// <returns></returns>
- public List<Model.T_Bus_WorkOrderReport> DataTableToDeptList(DataTable dt)
- {
- List<Model.T_Bus_WorkOrderReport> list = new List<Model.T_Bus_WorkOrderReport>();
- if (dt.Rows.Count > 0)
- {
- foreach (DataRow r in dt.Rows)
- {
- list.Add(new Model.T_Bus_WorkOrderReport
- {
- WorkOrderId = r["F_WorkOrderId"] == DBNull.Value ? "" : r["F_WorkOrderId"].ToString(),
- WorkOrderState = r["F_WorkState"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_WorkState"]),
- FieldId = r["F_MainDeptId"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_MainDeptId"]),
- FieldName = r["F_DeptName"] == DBNull.Value ? "" : r["F_DeptName"].ToString()
- });
- }
- }
- return list;
- }
- /// <summary>
- /// 工单类型
- /// </summary>
- /// <param name="dt"></param>
- /// <returns></returns>
- public List<Model.T_Bus_WorkOrderReport> DataTableToTypeList(DataTable dt)
- {
- List<Model.T_Bus_WorkOrderReport> list = new List<Model.T_Bus_WorkOrderReport>();
- if (dt.Rows.Count > 0)
- {
- foreach (DataRow r in dt.Rows)
- {
- list.Add(new Model.T_Bus_WorkOrderReport
- {
- WorkOrderId = r["F_WorkOrderId"] == DBNull.Value ? "" : r["F_WorkOrderId"].ToString(),
- WorkOrderState = r["F_WorkState"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_WorkState"]),
- FieldId = r["F_InfoType"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_InfoType"]),
- FieldName = r["F_Value"] == DBNull.Value ? "" : r["F_Value"].ToString()
- });
- }
- }
- return list;
- }
- /// <summary>
- /// 工单来源
- /// </summary>
- /// <param name="dt"></param>
- /// <returns></returns>
- public List<Model.T_Bus_WorkOrderReport> DataTableToSourceList(DataTable dt)
- {
- List<Model.T_Bus_WorkOrderReport> list = new List<Model.T_Bus_WorkOrderReport>();
- if (dt.Rows.Count > 0)
- {
- foreach (DataRow r in dt.Rows)
- {
- list.Add(new Model.T_Bus_WorkOrderReport
- {
- WorkOrderId = r["F_WorkOrderId"] == DBNull.Value ? "" : r["F_WorkOrderId"].ToString(),
- WorkOrderState = r["F_WorkState"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_WorkState"]),
- FieldId = r["F_InfoSource"] == DBNull.Value ? -1 : Convert.ToInt32(r["F_InfoSource"]),
- FieldName = r["F_Value"] == DBNull.Value ? "" : r["F_Value"].ToString()
- });
- }
- }
- return list;
- }
- }
- }
|