地铁二期项目正式开始

T_Wo_WorkOrderBase.cs 30KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637
  1. using System;
  2. using System.Data;
  3. using System.Collections.Generic;
  4. using YTSoft.Common;
  5. using YTSoft.BaseCallCenter.Model;
  6. namespace YTSoft.BaseCallCenter.BLL
  7. {
  8. /// <summary>
  9. /// T_Wo_WorkOrderBase
  10. /// </summary>
  11. public partial class T_Wo_WorkOrderBase
  12. {
  13. private readonly YTSoft.BaseCallCenter.DAL.T_Wo_WorkOrderBase dal = new YTSoft.BaseCallCenter.DAL.T_Wo_WorkOrderBase();
  14. public T_Wo_WorkOrderBase()
  15. { }
  16. #region Method
  17. /// <summary>
  18. /// 增加一条数据
  19. /// </summary>
  20. public int Add(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  21. {
  22. return dal.Add(model);
  23. }
  24. /// <summary>
  25. /// 增加一条数据
  26. /// </summary>
  27. public int AddWbgd(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  28. {
  29. return dal.AddWbgd(model);
  30. }
  31. /// <summary>
  32. /// 更新一条数据
  33. /// </summary>
  34. public bool Update(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  35. {
  36. return dal.Update(model);
  37. }
  38. /// <summary>
  39. /// 更新来电内容
  40. /// </summary>
  41. public bool Update1(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  42. {
  43. return dal.Update1(model);
  44. }
  45. /// <summary>
  46. /// 更新定责人员
  47. /// </summary>
  48. public bool UpdateDZuser(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  49. {
  50. return dal.UpdateDZuser(model);
  51. }
  52. /// <summary>
  53. /// 更新定责事件分类
  54. /// </summary>
  55. public bool UpdateDZClass(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  56. {
  57. return dal.UpdateDZClass(model);
  58. }
  59. /// <summary>
  60. /// 删除一条数据
  61. /// </summary>
  62. public bool Delete(int F_WORKORDERID)
  63. {
  64. return dal.Delete(F_WORKORDERID);
  65. }
  66. /// <summary>
  67. /// 删除一条数据
  68. /// </summary>
  69. public bool DeleteList(string F_WORKORDERIDlist)
  70. {
  71. return dal.DeleteList(F_WORKORDERIDlist);
  72. }
  73. /// <summary>
  74. /// 得到一个对象实体
  75. /// </summary>
  76. public YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase GetModel(int F_WORKORDERID)
  77. {
  78. return dal.GetModel(F_WORKORDERID);
  79. }
  80. /// <summary>
  81. /// 得到一个对象实体,从缓存中
  82. /// </summary>
  83. //public YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase GetModelByCache(int F_WORKORDERID)
  84. //{
  85. // string CacheKey = "T_Wo_WorkOrderBaseModel-" + F_WORKORDERID;
  86. // object objModel = Maticsoft.Common.DataCache.GetCache(CacheKey);
  87. // if (objModel == null)
  88. // {
  89. // try
  90. // {
  91. // objModel = dal.GetModel(F_WORKORDERID);
  92. // if (objModel != null)
  93. // {
  94. // int ModelCache = Maticsoft.Common.ConfigHelper.GetConfigInt("ModelCache");
  95. // Maticsoft.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
  96. // }
  97. // }
  98. // catch{}
  99. // }
  100. // return (YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase)objModel;
  101. //}
  102. /// <summary>
  103. /// 获得数据列表
  104. /// </summary>
  105. public DataSet GetList(string strWhere)
  106. {
  107. return dal.GetList(strWhere);
  108. }
  109. /// <summary>
  110. /// 获得前几行数据
  111. /// </summary>
  112. public DataSet GetList(int Top, string strWhere, string filedOrder)
  113. {
  114. return dal.GetList(Top, strWhere, filedOrder);
  115. }
  116. /// <summary>
  117. /// 获得数据列表
  118. /// </summary>
  119. public List<YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase> GetModelList(string strWhere)
  120. {
  121. DataSet ds = dal.GetList(strWhere);
  122. return DataTableToList(ds.Tables[0]);
  123. }
  124. /// <summary>
  125. /// 获得数据列表
  126. /// </summary>
  127. public List<YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase> DataTableToList(DataTable dt)
  128. {
  129. List<YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase> modelList = new List<YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase>();
  130. int rowsCount = dt.Rows.Count;
  131. if (rowsCount > 0)
  132. {
  133. YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model;
  134. for (int n = 0; n < rowsCount; n++)
  135. {
  136. model = new YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase();
  137. if (dt.Rows[n]["F_WORKORDERID"] != null && dt.Rows[n]["F_WORKORDERID"].ToString() != "")
  138. {
  139. model.F_WORKORDERID = int.Parse(dt.Rows[n]["F_WORKORDERID"].ToString());
  140. }
  141. if (dt.Rows[n]["F_WORKORDERTYPEID"] != null && dt.Rows[n]["F_WORKORDERTYPEID"].ToString() != "")
  142. {
  143. model.F_WORKORDERTYPEID = int.Parse(dt.Rows[n]["F_WORKORDERTYPEID"].ToString());
  144. }
  145. if (dt.Rows[n]["F_WORKORDERSTATEID"] != null && dt.Rows[n]["F_WORKORDERSTATEID"].ToString() != "")
  146. {
  147. model.F_WORKORDERSTATEID = int.Parse(dt.Rows[n]["F_WORKORDERSTATEID"].ToString());
  148. }
  149. if (dt.Rows[n]["F_CODE"] != null && dt.Rows[n]["F_CODE"].ToString() != "")
  150. {
  151. model.F_CODE = dt.Rows[n]["F_CODE"].ToString();
  152. }
  153. if (dt.Rows[n]["F_WORKORDERNAME"] != null && dt.Rows[n]["F_WORKORDERNAME"].ToString() != "")
  154. {
  155. model.F_WORKORDERNAME = dt.Rows[n]["F_WORKORDERNAME"].ToString();
  156. }
  157. if (dt.Rows[n]["F_NUMBER"] != null && dt.Rows[n]["F_NUMBER"].ToString() != "")
  158. {
  159. model.F_NUMBER = dt.Rows[n]["F_NUMBER"].ToString();
  160. }
  161. if (dt.Rows[n]["F_CUSTOMERNAME"] != null && dt.Rows[n]["F_CUSTOMERNAME"].ToString() != "")
  162. {
  163. model.F_CUSTOMERNAME = dt.Rows[n]["F_CUSTOMERNAME"].ToString();
  164. }
  165. if (dt.Rows[n]["F_CUSTOMERTELEPHONE"] != null && dt.Rows[n]["F_CUSTOMERTELEPHONE"].ToString() != "")
  166. {
  167. model.F_CUSTOMERTELEPHONE = dt.Rows[n]["F_CUSTOMERTELEPHONE"].ToString();
  168. }
  169. if (dt.Rows[n]["F_LINKMAN"] != null && dt.Rows[n]["F_LINKMAN"].ToString() != "")
  170. {
  171. model.F_LINKMAN = dt.Rows[n]["F_LINKMAN"].ToString();
  172. }
  173. if (dt.Rows[n]["F_LINKMANTELEPHONE"] != null && dt.Rows[n]["F_LINKMANTELEPHONE"].ToString() != "")
  174. {
  175. model.F_LINKMANTELEPHONE = dt.Rows[n]["F_LINKMANTELEPHONE"].ToString();
  176. }
  177. if (dt.Rows[n]["F_ADSLACCOUNT"] != null && dt.Rows[n]["F_ADSLACCOUNT"].ToString() != "")
  178. {
  179. model.F_ADSLACCOUNT = dt.Rows[n]["F_ADSLACCOUNT"].ToString();
  180. }
  181. if (dt.Rows[n]["F_BANDWIDTH"] != null && dt.Rows[n]["F_BANDWIDTH"].ToString() != "")
  182. {
  183. model.F_BANDWIDTH = dt.Rows[n]["F_BANDWIDTH"].ToString();
  184. }
  185. if (dt.Rows[n]["F_STANDARDADDRESS"] != null && dt.Rows[n]["F_STANDARDADDRESS"].ToString() != "")
  186. {
  187. model.F_STANDARDADDRESS = dt.Rows[n]["F_STANDARDADDRESS"].ToString();
  188. }
  189. if (dt.Rows[n]["F_INSTALLADDRESS"] != null && dt.Rows[n]["F_INSTALLADDRESS"].ToString() != "")
  190. {
  191. model.F_INSTALLADDRESS = dt.Rows[n]["F_INSTALLADDRESS"].ToString();
  192. }
  193. if (dt.Rows[n]["F_KSHADDRESSCODE"] != null && dt.Rows[n]["F_KSHADDRESSCODE"].ToString() != "")
  194. {
  195. model.F_KSHADDRESSCODE = dt.Rows[n]["F_KSHADDRESSCODE"].ToString();
  196. }
  197. if (dt.Rows[n]["F_PROVINCE"] != null && dt.Rows[n]["F_PROVINCE"].ToString() != "")
  198. {
  199. model.F_PROVINCE = dt.Rows[n]["F_PROVINCE"].ToString();
  200. }
  201. if (dt.Rows[n]["F_CITY"] != null && dt.Rows[n]["F_CITY"].ToString() != "")
  202. {
  203. model.F_CITY = dt.Rows[n]["F_CITY"].ToString();
  204. }
  205. if (dt.Rows[n]["F_AREA"] != null && dt.Rows[n]["F_AREA"].ToString() != "")
  206. {
  207. model.F_AREA = dt.Rows[n]["F_AREA"].ToString();
  208. }
  209. if (dt.Rows[n]["F_ROAD"] != null && dt.Rows[n]["F_ROAD"].ToString() != "")
  210. {
  211. model.F_ROAD = dt.Rows[n]["F_ROAD"].ToString();
  212. }
  213. if (dt.Rows[n]["F_HOUSING"] != null && dt.Rows[n]["F_HOUSING"].ToString() != "")
  214. {
  215. model.F_HOUSING = dt.Rows[n]["F_HOUSING"].ToString();
  216. }
  217. if (dt.Rows[n]["F_WORKORDERFROM"] != null && dt.Rows[n]["F_WORKORDERFROM"].ToString() != "")
  218. {
  219. model.F_WORKORDERFROM = dt.Rows[n]["F_WORKORDERFROM"].ToString();
  220. }
  221. if (dt.Rows[n]["F_WORKORDERLEVELID"] != null && dt.Rows[n]["F_WORKORDERLEVELID"].ToString() != "")
  222. {
  223. model.F_WORKORDERLEVELID = int.Parse(dt.Rows[n]["F_WORKORDERLEVELID"].ToString());
  224. }
  225. if (dt.Rows[n]["F_FILEFLAG"] != null && dt.Rows[n]["F_FILEFLAG"].ToString() != "")
  226. {
  227. model.F_FILEFLAG = int.Parse(dt.Rows[n]["F_FILEFLAG"].ToString());
  228. }
  229. if (dt.Rows[n]["F_CONTENT"] != null && dt.Rows[n]["F_CONTENT"].ToString() != "")
  230. {
  231. model.F_CONTENT = dt.Rows[n]["F_CONTENT"].ToString();
  232. }
  233. if (dt.Rows[n]["F_CREATEBY"] != null && dt.Rows[n]["F_CREATEBY"].ToString() != "")
  234. {
  235. model.F_CREATEBY = int.Parse(dt.Rows[n]["F_CREATEBY"].ToString());
  236. }
  237. if (dt.Rows[n]["F_CREATEDATE"] != null && dt.Rows[n]["F_CREATEDATE"].ToString() != "")
  238. {
  239. model.F_CREATEDATE = DateTime.Parse(dt.Rows[n]["F_CREATEDATE"].ToString());
  240. }
  241. if (dt.Rows[n]["F_DEPTCODE"] != null && dt.Rows[n]["F_DEPTCODE"].ToString() != "")
  242. {
  243. model.F_DEPTCODE = dt.Rows[n]["F_DEPTCODE"].ToString();
  244. }
  245. if (dt.Rows[n]["F_EMPCODE"] != null && dt.Rows[n]["F_EMPCODE"].ToString() != "")
  246. {
  247. model.F_EMPCODE = dt.Rows[n]["F_EMPCODE"].ToString();
  248. }
  249. if (dt.Rows[n]["F_DEPTID"] != null && dt.Rows[n]["F_DEPTID"].ToString() != "")
  250. {
  251. model.F_DEPTID = int.Parse(dt.Rows[n]["F_DEPTID"].ToString());
  252. }
  253. if (dt.Rows[n]["F_USERID"] != null && dt.Rows[n]["F_USERID"].ToString() != "")
  254. {
  255. model.F_USERID = int.Parse(dt.Rows[n]["F_USERID"].ToString());
  256. }
  257. if (dt.Rows[n]["F_USERNAME"] != null && dt.Rows[n]["F_USERNAME"].ToString() != "")
  258. {
  259. model.F_USERNAME = dt.Rows[n]["F_USERNAME"].ToString();
  260. }
  261. if (dt.Rows[n]["F_RETURNVISITFLAG"] != null && dt.Rows[n]["F_RETURNVISITFLAG"].ToString() != "")
  262. {
  263. model.F_RETURNVISITFLAG = int.Parse(dt.Rows[n]["F_RETURNVISITFLAG"].ToString());
  264. }
  265. if (dt.Rows[n]["F_RETURNVISITSTATE"] != null && dt.Rows[n]["F_RETURNVISITSTATE"].ToString() != "")
  266. {
  267. model.F_RETURNVISITSTATE = int.Parse(dt.Rows[n]["F_RETURNVISITSTATE"].ToString());
  268. }
  269. if (dt.Rows[n]["F_RETURNVISITRESULT"] != null && dt.Rows[n]["F_RETURNVISITRESULT"].ToString() != "")
  270. {
  271. model.F_RETURNVISITRESULT = int.Parse(dt.Rows[n]["F_RETURNVISITRESULT"].ToString());
  272. }
  273. if (dt.Rows[n]["F_RETURNVISITCONTENT"] != null && dt.Rows[n]["F_RETURNVISITCONTENT"].ToString() != "")
  274. {
  275. model.F_RETURNVISITCONTENT = dt.Rows[n]["F_RETURNVISITCONTENT"].ToString();
  276. }
  277. if (dt.Rows[n]["F_DELETEFLAG"] != null && dt.Rows[n]["F_DELETEFLAG"].ToString() != "")
  278. {
  279. model.F_DELETEFLAG = int.Parse(dt.Rows[n]["F_DELETEFLAG"].ToString());
  280. }
  281. if (dt.Rows[n]["F_ALLUSETIMES"] != null && dt.Rows[n]["F_ALLUSETIMES"].ToString() != "")
  282. {
  283. model.F_ALLUSETIMES = int.Parse(dt.Rows[n]["F_ALLUSETIMES"].ToString());
  284. }
  285. if (dt.Rows[n]["F_STARTTIME"] != null && dt.Rows[n]["F_STARTTIME"].ToString() != "")
  286. {
  287. model.F_STARTTIME = DateTime.Parse(dt.Rows[n]["F_STARTTIME"].ToString());
  288. }
  289. if (dt.Rows[n]["F_ENDTIME"] != null && dt.Rows[n]["F_ENDTIME"].ToString() != "")
  290. {
  291. model.F_ENDTIME = DateTime.Parse(dt.Rows[n]["F_ENDTIME"].ToString());
  292. }
  293. if (dt.Rows[n]["F_REMAINDERTIME"] != null && dt.Rows[n]["F_REMAINDERTIME"].ToString() != "")
  294. {
  295. model.F_REMAINDERTIME = DateTime.Parse(dt.Rows[n]["F_REMAINDERTIME"].ToString());
  296. }
  297. if (dt.Rows[n]["F_REMAINDERENDTIME"] != null && dt.Rows[n]["F_REMAINDERENDTIME"].ToString() != "")
  298. {
  299. model.F_REMAINDERENDTIME = DateTime.Parse(dt.Rows[n]["F_REMAINDERENDTIME"].ToString());
  300. }
  301. if (dt.Rows[n]["F_SUBSCRIBETIME1"] != null && dt.Rows[n]["F_SUBSCRIBETIME1"].ToString() != "")
  302. {
  303. model.F_SUBSCRIBETIME1 = DateTime.Parse(dt.Rows[n]["F_SUBSCRIBETIME1"].ToString());
  304. }
  305. if (dt.Rows[n]["F_SUBSCRIBETIME2"] != null && dt.Rows[n]["F_SUBSCRIBETIME2"].ToString() != "")
  306. {
  307. model.F_SUBSCRIBETIME2 = DateTime.Parse(dt.Rows[n]["F_SUBSCRIBETIME2"].ToString());
  308. }
  309. if (dt.Rows[n]["F_ACCEPTTIMELIMIT"] != null && dt.Rows[n]["F_ACCEPTTIMELIMIT"].ToString() != "")
  310. {
  311. model.F_ACCEPTTIMELIMIT = DateTime.Parse(dt.Rows[n]["F_ACCEPTTIMELIMIT"].ToString());
  312. }
  313. if (dt.Rows[n]["F_ASKFINISHTIME"] != null && dt.Rows[n]["F_ASKFINISHTIME"].ToString() != "")
  314. {
  315. model.F_ASKFINISHTIME = DateTime.Parse(dt.Rows[n]["F_ASKFINISHTIME"].ToString());
  316. }
  317. if (dt.Rows[n]["F_OVERTIMES"] != null && dt.Rows[n]["F_OVERTIMES"].ToString() != "")
  318. {
  319. model.F_OVERTIMES = int.Parse(dt.Rows[n]["F_OVERTIMES"].ToString());
  320. }
  321. if (dt.Rows[n]["F_FORMID"] != null && dt.Rows[n]["F_FORMID"].ToString() != "")
  322. {
  323. model.F_FORMID = int.Parse(dt.Rows[n]["F_FORMID"].ToString());
  324. }
  325. if (dt.Rows[n]["F_HASTENCOUNTS"] != null && dt.Rows[n]["F_HASTENCOUNTS"].ToString() != "")
  326. {
  327. model.F_HASTENCOUNTS = int.Parse(dt.Rows[n]["F_HASTENCOUNTS"].ToString());
  328. }
  329. if (dt.Rows[n]["F_RANGEID"] != null && dt.Rows[n]["F_RANGEID"].ToString() != "")
  330. {
  331. model.F_RANGEID = decimal.Parse(dt.Rows[n]["F_RANGEID"].ToString());
  332. }
  333. if (dt.Rows[n]["F_RANGEX"] != null && dt.Rows[n]["F_RANGEX"].ToString() != "")
  334. {
  335. model.F_RANGEX = decimal.Parse(dt.Rows[n]["F_RANGEX"].ToString());
  336. }
  337. if (dt.Rows[n]["F_RANGEY"] != null && dt.Rows[n]["F_RANGEY"].ToString() != "")
  338. {
  339. model.F_RANGEY = decimal.Parse(dt.Rows[n]["F_RANGEY"].ToString());
  340. }
  341. if (dt.Rows[n]["F_INSTANCEID"] != null && dt.Rows[n]["F_INSTANCEID"].ToString() != "")
  342. {
  343. model.F_INSTANCEID = int.Parse(dt.Rows[n]["F_INSTANCEID"].ToString());
  344. }
  345. if (dt.Rows[n]["F_CUSTOMERID"] != null && dt.Rows[n]["F_CUSTOMERID"].ToString() != "")
  346. {
  347. model.F_CUSTOMERID = int.Parse(dt.Rows[n]["F_CUSTOMERID"].ToString());
  348. }
  349. if (dt.Rows[n]["F_REPAIRMANID"] != null && dt.Rows[n]["F_REPAIRMANID"].ToString() != "")
  350. {
  351. model.F_REPAIRMANID = int.Parse(dt.Rows[n]["F_REPAIRMANID"].ToString());
  352. }
  353. if (dt.Rows[n]["F_REPAIRMANNAME"] != null && dt.Rows[n]["F_REPAIRMANNAME"].ToString() != "")
  354. {
  355. model.F_REPAIRMANNAME = dt.Rows[n]["F_REPAIRMANNAME"].ToString();
  356. }
  357. if (dt.Rows[n]["F_REPAIRMANPHONE"] != null && dt.Rows[n]["F_REPAIRMANPHONE"].ToString() != "")
  358. {
  359. model.F_REPAIRMANPHONE = dt.Rows[n]["F_REPAIRMANPHONE"].ToString();
  360. }
  361. if (dt.Rows[n]["F_REPAIRREQUEST"] != null && dt.Rows[n]["F_REPAIRREQUEST"].ToString() != "")
  362. {
  363. model.F_REPAIRREQUEST = dt.Rows[n]["F_REPAIRREQUEST"].ToString();
  364. }
  365. if (dt.Rows[n]["F_REPAIRCLOSEMANID"] != null && dt.Rows[n]["F_REPAIRCLOSEMANID"].ToString() != "")
  366. {
  367. model.F_REPAIRCLOSEMANID = int.Parse(dt.Rows[n]["F_REPAIRCLOSEMANID"].ToString());
  368. }
  369. if (dt.Rows[n]["F_REPAIRCLOSEMANNAME"] != null && dt.Rows[n]["F_REPAIRCLOSEMANNAME"].ToString() != "")
  370. {
  371. model.F_REPAIRCLOSEMANNAME = dt.Rows[n]["F_REPAIRCLOSEMANNAME"].ToString();
  372. }
  373. if (dt.Rows[n]["F_REPAIRCLOSEREASONS"] != null && dt.Rows[n]["F_REPAIRCLOSEREASONS"].ToString() != "")
  374. {
  375. model.F_REPAIRCLOSEREASONS = dt.Rows[n]["F_REPAIRCLOSEREASONS"].ToString();
  376. }
  377. if (dt.Rows[n]["F_REPAIRCLOSEREPTID"] != null && dt.Rows[n]["F_REPAIRCLOSEREPTID"].ToString() != "")
  378. {
  379. model.F_REPAIRCLOSEREPTID = int.Parse(dt.Rows[n]["F_REPAIRCLOSEREPTID"].ToString());
  380. }
  381. if (dt.Rows[n]["F_REPAIRCLOSEREPT"] != null && dt.Rows[n]["F_REPAIRCLOSEREPT"].ToString() != "")
  382. {
  383. model.F_REPAIRCLOSEREPT = dt.Rows[n]["F_REPAIRCLOSEREPT"].ToString();
  384. }
  385. if (dt.Rows[n]["F_REPAIRLEVEL"] != null && dt.Rows[n]["F_REPAIRLEVEL"].ToString() != "")
  386. {
  387. model.F_REPAIRLEVEL = int.Parse(dt.Rows[n]["F_REPAIRLEVEL"].ToString());
  388. }
  389. if (dt.Rows[n]["F_REPAIRLEVELNAME"] != null && dt.Rows[n]["F_REPAIRLEVELNAME"].ToString() != "")
  390. {
  391. model.F_REPAIRLEVELNAME = dt.Rows[n]["F_REPAIRLEVELNAME"].ToString();
  392. }
  393. if (dt.Rows[n]["F_SENTORDERTIME"] != null && dt.Rows[n]["F_SENTORDERTIME"].ToString() != "")
  394. {
  395. model.F_SENTORDERTIME = DateTime.Parse(dt.Rows[n]["F_SENTORDERTIME"].ToString());
  396. }
  397. if (dt.Rows[n]["F_USERPHONE"] != null && dt.Rows[n]["F_USERPHONE"].ToString() != "")
  398. {
  399. model.F_USERPHONE = dt.Rows[n]["F_USERPHONE"].ToString();
  400. }
  401. if (dt.Rows[n]["F_RETURNVISITTIME"] != null && dt.Rows[n]["F_RETURNVISITTIME"].ToString() != "")
  402. {
  403. model.F_RETURNVISITTIME = DateTime.Parse(dt.Rows[n]["F_RETURNVISITTIME"].ToString());
  404. }
  405. if (dt.Rows[n]["F_REQUESTSERVICETIME"] != null && dt.Rows[n]["F_REQUESTSERVICETIME"].ToString() != "")
  406. {
  407. model.F_REQUESTSERVICETIME = DateTime.Parse(dt.Rows[n]["F_REQUESTSERVICETIME"].ToString());
  408. }
  409. if (dt.Rows[n]["F_SERVICETYPE"] != null && dt.Rows[n]["F_SERVICETYPE"].ToString() != "")
  410. {
  411. model.F_SERVICETYPE = dt.Rows[n]["F_SERVICETYPE"].ToString();
  412. }
  413. if (dt.Rows[n]["F_DECLARATIONTIME"] != null && dt.Rows[n]["F_DECLARATIONTIME"].ToString() != "")
  414. {
  415. model.F_DECLARATIONTIME = decimal.Parse(dt.Rows[n]["F_DECLARATIONTIME"].ToString());
  416. }
  417. if (dt.Rows[n]["F_SERVICENATURE"] != null && dt.Rows[n]["F_SERVICENATURE"].ToString() != "")
  418. {
  419. model.F_SERVICENATURE = dt.Rows[n]["F_SERVICENATURE"].ToString();
  420. }
  421. if (dt.Rows[n]["F_SERVICEWAY"] != null && dt.Rows[n]["F_SERVICEWAY"].ToString() != "")
  422. {
  423. model.F_SERVICEWAY = dt.Rows[n]["F_SERVICEWAY"].ToString();
  424. }
  425. if (dt.Rows[n]["F_RETURNVISITMAN"] != null && dt.Rows[n]["F_RETURNVISITMAN"].ToString() != "")
  426. {
  427. model.F_RETURNVISITMAN = dt.Rows[n]["F_RETURNVISITMAN"].ToString();
  428. }
  429. if (dt.Rows[n]["F_RETURNVISITID"] != null && dt.Rows[n]["F_RETURNVISITID"].ToString() != "")
  430. {
  431. model.F_RETURNVISITID = int.Parse(dt.Rows[n]["F_RETURNVISITID"].ToString());
  432. }
  433. if (dt.Rows[n]["F_RETURNVISITOPINION"] != null && dt.Rows[n]["F_RETURNVISITOPINION"].ToString() != "")
  434. {
  435. model.F_RETURNVISITOPINION = dt.Rows[n]["F_RETURNVISITOPINION"].ToString();
  436. }
  437. if (dt.Rows[n]["F_RETURNVISITPROBLEM"] != null && dt.Rows[n]["F_RETURNVISITPROBLEM"].ToString() != "")
  438. {
  439. model.F_RETURNVISITPROBLEM = dt.Rows[n]["F_RETURNVISITPROBLEM"].ToString();
  440. }
  441. if (dt.Rows[n]["F_CustomerNatureID"] != null && dt.Rows[n]["F_CustomerNatureID"].ToString() != "")
  442. {
  443. model.F_CustomerNatureID = int.Parse(dt.Rows[n]["F_CustomerNatureID"].ToString());
  444. }
  445. if (dt.Rows[n]["F_CustomerNature"] != null && dt.Rows[n]["F_CustomerNature"].ToString() != "")
  446. {
  447. model.F_CustomerNature = dt.Rows[n]["F_CustomerNature"].ToString();
  448. }
  449. if (dt.Rows[n]["F_SystemType"] != null && dt.Rows[n]["F_SystemType"].ToString() != "")
  450. {
  451. model.F_SystemType = dt.Rows[n]["F_SystemType"].ToString();
  452. }
  453. if (dt.Rows[n]["F_ChargeDept"] != null && dt.Rows[n]["F_ChargeDept"].ToString() != "")
  454. {
  455. model.F_ChargeDept = dt.Rows[n]["F_ChargeDept"].ToString();
  456. }
  457. if (dt.Rows[n]["F_QualityGuaranteeEndTime"] != null && dt.Rows[n]["F_QualityGuaranteeEndTime"].ToString() != "")
  458. {
  459. model.F_QualityGuaranteeEndTime = DateTime.Parse(dt.Rows[n]["F_QualityGuaranteeEndTime"].ToString());
  460. }
  461. if (dt.Rows[n]["F_SystemStartTime"] != null && dt.Rows[n]["F_SystemStartTime"].ToString() != "")
  462. {
  463. model.F_SystemStartTime = DateTime.Parse(dt.Rows[n]["F_SystemStartTime"].ToString());
  464. }
  465. if (dt.Rows[n]["F_CustomerClass"] != null && dt.Rows[n]["F_CustomerClass"].ToString() != "")
  466. {
  467. model.F_CustomerClass = dt.Rows[n]["F_CustomerClass"].ToString();
  468. }
  469. if (dt.Rows[n]["F_AfterSaleName"] != null && dt.Rows[n]["F_AfterSaleName"].ToString() != "")
  470. {
  471. model.F_AfterSaleName = dt.Rows[n]["F_AfterSaleName"].ToString();
  472. }
  473. if (dt.Rows[n]["F_ServiceDept"] != null && dt.Rows[n]["F_ServiceDept"].ToString() != "")
  474. {
  475. model.F_ServiceDept = dt.Rows[n]["F_ServiceDept"].ToString();
  476. }
  477. if (dt.Rows[n]["F_Name"] != null && dt.Rows[n]["F_Name"].ToString() != "")
  478. {
  479. model.F_Name = dt.Rows[n]["F_Name"].ToString();
  480. }
  481. if (dt.Rows[n]["F_TypeName"] != null && dt.Rows[n]["F_TypeName"].ToString() != "")
  482. {
  483. model.F_TypeName = dt.Rows[n]["F_TypeName"].ToString();
  484. }
  485. if (dt.Rows[n]["F_UserAccountName"] != null && dt.Rows[n]["F_UserAccountName"].ToString() != "")
  486. {
  487. model.F_UserAccountName = dt.Rows[n]["F_UserAccountName"].ToString();
  488. }
  489. modelList.Add(model);
  490. }
  491. }
  492. return modelList;
  493. }
  494. /// <summary>
  495. /// 获得数据列表
  496. /// </summary>
  497. public DataSet GetAllList()
  498. {
  499. return GetList("");
  500. }
  501. /// <summary>
  502. /// 分页获取数据列表
  503. /// </summary>
  504. public int GetRecordCount(string strWhere)
  505. {
  506. return dal.GetRecordCount(strWhere);
  507. }
  508. /// <summary>
  509. /// 分页获取数据列表
  510. /// </summary>
  511. public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
  512. {
  513. return dal.GetListByPage(strWhere, orderby, startIndex, endIndex);
  514. }
  515. /// <summary>
  516. /// 分页获取数据列表
  517. /// </summary>
  518. //public DataSet GetList(int PageSize,int PageIndex,string strWhere)
  519. //{
  520. //return dal.GetList(PageSize,PageIndex,strWhere);
  521. //}
  522. #endregion Method
  523. #region 编辑工单信息
  524. /// <summary>
  525. /// 编辑工单信息
  526. /// </summary>
  527. /// <param name="model">工单实体</param>
  528. /// <returns></returns>
  529. public bool UpdateWorkOrderInfoModel(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  530. {
  531. return dal.UpdateWorkOrderInfoModel(model);
  532. }
  533. public string GetOrderNumber(int ordertype)
  534. {
  535. return dal.GetOrderNumber(ordertype);
  536. }
  537. /// <summary>
  538. /// 修改转办信息
  539. /// </summary>
  540. /// <param name="model"></param>
  541. /// <returns></returns>
  542. public bool EditMyOrderInfo(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  543. {
  544. return dal.EditMyOrderInfo(model);
  545. }
  546. /// <summary>
  547. /// 处理信息
  548. /// </summary>
  549. /// <param name="model"></param>
  550. /// <returns></returns>
  551. public bool SubmitOrder(Model.T_Wo_WorkOrderHistory model)
  552. {
  553. return dal.SubmitOrder(model);
  554. }
  555. /// <summary>
  556. /// 全媒体客服处理回访
  557. /// </summary>
  558. /// <param name="model"></param>
  559. /// <returns></returns>
  560. public bool SubmitOrderHF(Model.T_Wo_WorkOrderBase model)
  561. {
  562. return dal.SubmitOrderHF(model);
  563. }
  564. /// <summary>
  565. /// 关闭转办信息
  566. /// </summary>
  567. /// <param name="model"></param>
  568. /// <returns></returns>
  569. public bool CloseMyOrderInfo(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  570. {
  571. return dal.CloseMyOrderInfo(model);
  572. }
  573. /// <summary>
  574. /// 编辑历史工单信息
  575. /// </summary>
  576. /// <param name="model"></param>
  577. /// <returns></returns>
  578. public bool UpdateHistoryWorkOrderInfoModel(YTSoft.BaseCallCenter.Model.T_Wo_WorkOrderBase model)
  579. {
  580. return dal.UpdateHistoryWorkOrderInfoModel(model);
  581. }
  582. #endregion ExtensionMethod
  583. #region 工单撤回
  584. public bool ResetWorkOrder(int workOrderId,int byid,string byname,int bmid, string bmmc)
  585. {
  586. return dal.ResetWorkOrder(workOrderId, byid, byname, bmid, bmmc);
  587. }
  588. #endregion
  589. //待处理驳回
  590. public bool OverruleWorkOrder(int workOrderId, int byid, string byname, int bmid, string bmmc)
  591. {
  592. return dal.OverruleWorkOrder(workOrderId, byid, byname, bmid, bmmc);
  593. }
  594. //待回访驳回
  595. public bool OverruleDHFWorkOrder(int workOrderId, int byid, string byname, int bmid, string bmmc)
  596. {
  597. return dal.OverruleDHFWorkOrder(workOrderId, byid, byname, bmid, bmmc);
  598. }
  599. //待定责驳回
  600. public bool OverruleDDZWorkOrder(int workOrderId, int byid, string byname, int bmid, string bmmc)
  601. {
  602. return dal.OverruleDDZWorkOrder(workOrderId, byid, byname, bmid, bmmc);
  603. }
  604. }
  605. }