三元财务API

archivesNew.cs 10KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332
  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 archivesNew
  10. {
  11. private readonly DAL.archivesNew dal = new DAL.archivesNew();
  12. /// <summary>
  13. /// 获取档案物资表数据信息
  14. /// </summary>
  15. /// <returns></returns>
  16. public DataSet GetList()
  17. {
  18. return dal.GetList();
  19. }
  20. /// <summary>
  21. /// 是否存在该记录
  22. /// </summary>
  23. public bool IfHave(int id)
  24. {
  25. return dal.IfHave(id);
  26. }
  27. /// <summary>
  28. /// 增加一条档案物资数据
  29. /// </summary>
  30. /// <param name="model"></param>
  31. /// <returns></returns>
  32. public int Add(CallCenterApi.Model.archivesNew model)
  33. {
  34. return dal.Add(model);
  35. }
  36. /// <summary>
  37. /// 得到一个档案物资对象实体
  38. /// </summary>
  39. public CallCenterApi.Model.archivesNew GetModel(int id)
  40. {
  41. return dal.GetModel(id);
  42. }
  43. /// <summary>
  44. /// 更新一条档案物资数据
  45. /// </summary>
  46. public bool Update(CallCenterApi.Model.archivesNew model)
  47. {
  48. return dal.Update(model);
  49. }
  50. /// <summary>
  51. /// 删除一条档案物资数据
  52. /// </summary>
  53. public bool Delete(int id)
  54. {
  55. return dal.Delete(id);
  56. }
  57. /// <summary>
  58. /// 获取物资状态信息 用作可选的下拉框选项
  59. /// </summary>
  60. /// <returns></returns>
  61. public DataSet GetArchivestate()
  62. {
  63. return dal.GetArchivestate();
  64. }
  65. /// <summary>
  66. /// 增加物资状态数据
  67. /// </summary>
  68. /// <param name="model"></param>
  69. /// <returns></returns>
  70. public int Addarchivestate(CallCenterApi.Model.archivestate model)
  71. {
  72. return dal.Addarchivestate(model);
  73. }
  74. /// <summary>
  75. /// 删除一条物资状态信息
  76. /// </summary>
  77. /// <param name="id"></param>
  78. /// <returns></returns>
  79. public bool delarchivestate(int id)
  80. {
  81. return dal.delarchivestate(id);
  82. }
  83. /// <summary>
  84. /// 根据档案名称获取档案状态id
  85. /// </summary>
  86. /// <param name="statename"></param>
  87. /// <returns></returns>
  88. public int GetStateid(string statename)
  89. {
  90. return dal.GetStateid(statename);
  91. }
  92. /// <summary>
  93. /// 根据id 修改档案物资的状态
  94. /// </summary>
  95. /// <returns></returns>
  96. public bool updateState(int id, int stateid)
  97. {
  98. return dal.updateState(id,stateid);
  99. }
  100. /// <summary>
  101. /// 获取外部客户操作表信息
  102. /// </summary>
  103. /// <returns></returns>
  104. public DataSet GetCustomerBorrow()
  105. {
  106. return dal.GetCustomerBorrow();
  107. }
  108. /// <summary>
  109. /// 外部客户操作信息添加
  110. /// </summary>
  111. /// <returns></returns>
  112. public int AddCustomerBorrow(CallCenterApi.Model.customerBorrow model)
  113. {
  114. return dal.AddCustomerBorrow(model);
  115. }
  116. public int AddexternalOperator(CallCenterApi.Model.externalOperator model)
  117. {
  118. return dal.AddexternalOperator(model);
  119. }
  120. public int AddinternalOperator(CallCenterApi.Model.internalOperator model)
  121. {
  122. return dal.AddinternalOperator(model);
  123. }
  124. /// <summary>
  125. /// 获取客户操作表实体
  126. /// </summary>
  127. /// <param name="id"></param>
  128. /// <returns></returns>
  129. public CallCenterApi.Model.customerBorrow GetCustomerModel(int id)
  130. {
  131. return dal.GetCustomerModel(id);
  132. }
  133. /// <summary>
  134. /// 根据微信openid获取客户名称
  135. /// </summary>
  136. /// <param name="openid"></param>
  137. /// <returns></returns>
  138. public string GetCustomerName(string openid)
  139. {
  140. return dal.GetCustomerName(openid);
  141. }
  142. /// <summary>
  143. /// 修改客户操作信息
  144. /// </summary>
  145. /// <returns></returns>
  146. public bool UpCustomerBorrow(CallCenterApi.Model.customerBorrow model)
  147. {
  148. return dal.UpCustomerBorrow(model);
  149. }
  150. /// <summary>
  151. /// 删除一条客户操作信息
  152. /// </summary>
  153. /// <param name="id"></param>
  154. /// <returns></returns>
  155. public bool delCustomerBorrow(int id)
  156. {
  157. return dal.delCustomerBorrow(id);
  158. }
  159. /// <summary>
  160. /// 获取内部操作表信息
  161. /// </summary>
  162. /// <returns></returns>
  163. public DataSet GetinsideOperation()
  164. {
  165. return dal.GetinsideOperation();
  166. }
  167. /// <summary>
  168. /// 内部员工操作信息添加
  169. /// </summary>
  170. /// <returns></returns>
  171. public int AddinsideOperation(CallCenterApi.Model.insideOperation model)
  172. {
  173. return dal.AddinsideOperation(model);
  174. }
  175. /// <summary>
  176. /// 修改和互操作信息
  177. /// </summary>
  178. /// <returns></returns>
  179. public bool UpinsideOperation(CallCenterApi.Model.insideOperation model)
  180. {
  181. return dal.UpinsideOperation(model);
  182. }
  183. /// <summary>
  184. /// 获取内部员工操作表实体
  185. /// </summary>
  186. /// <param name="id"></param>
  187. /// <returns></returns>
  188. public CallCenterApi.Model.insideOperation GetinsideOperationModel(int id)
  189. {
  190. return dal.GetinsideOperationModel(id);
  191. }
  192. /// <summary>
  193. /// 删除一条内部员工操作信息
  194. /// </summary>
  195. /// <param name="id"></param>
  196. /// <returns></returns>
  197. public bool delinsideOperation(int id)
  198. {
  199. return dal.delinsideOperation(id);
  200. }
  201. /// <summary>
  202. /// 获取操作日志表信息
  203. /// </summary>
  204. /// <returns></returns>
  205. public DataSet GetOperationlog()
  206. {
  207. return dal.GetOperationlog();
  208. }
  209. /// <summary>
  210. /// 操作日志信息添加
  211. /// </summary>
  212. /// <returns></returns>
  213. public int AddOperationlog(CallCenterApi.Model.addupdatelog model)
  214. {
  215. return dal.AddOperationlog(model);
  216. }
  217. /// <summary>
  218. /// 获得档案物资数据列表 导入部分
  219. /// </summary>
  220. public List<Model.archivesNew> DataTableToList(DataTable dt)
  221. {
  222. List<Model.archivesNew> modelList = new List<Model.archivesNew>();
  223. int rowsCount = dt.Rows.Count;
  224. if (rowsCount > 0)
  225. {
  226. Model.archivesNew model;
  227. for (int n = 0; n < rowsCount; n++)
  228. {
  229. model = dal.DataRowToModelarchives(dt.Rows[n]);
  230. if (model != null)
  231. {
  232. modelList.Add(model);
  233. }
  234. }
  235. }
  236. return modelList;
  237. }
  238. /// <summary>
  239. /// 获得物资状态数据列表 导入部分
  240. /// </summary>
  241. public List<Model.archivestate> DataTableToList1(DataTable dt)
  242. {
  243. List<Model.archivestate> modelList = new List<Model.archivestate>();
  244. int rowsCount = dt.Rows.Count;
  245. if (rowsCount > 0)
  246. {
  247. Model.archivestate model;
  248. for (int n = 0; n < rowsCount; n++)
  249. {
  250. model = dal.DataRowToModelarchives1(dt.Rows[n]);
  251. if (model != null)
  252. {
  253. modelList.Add(model);
  254. }
  255. }
  256. }
  257. return modelList;
  258. }
  259. /// <summary>
  260. /// 获得客户操作借阅归还数据列表
  261. /// </summary>
  262. public List<Model.customerBorrow> DataTableToListcustomerBorrow(DataTable dt)
  263. {
  264. List<Model.customerBorrow> modelList = new List<Model.customerBorrow>();
  265. int rowsCount = dt.Rows.Count;
  266. if (rowsCount > 0)
  267. {
  268. Model.customerBorrow model;
  269. for (int n = 0; n < rowsCount; n++)
  270. {
  271. model = dal.DataRowToModelcustomerBorrow(dt.Rows[n]);
  272. if (model != null)
  273. {
  274. modelList.Add(model);
  275. }
  276. }
  277. }
  278. return modelList;
  279. }
  280. /// <summary>
  281. /// 获得内部员工操作出入库数据列表 导入部分 分页部分
  282. /// </summary>
  283. public List<Model.insideOperation> DataTableToListinsideOperation(DataTable dt)
  284. {
  285. List<Model.insideOperation> modelList = new List<Model.insideOperation>();
  286. int rowsCount = dt.Rows.Count;
  287. if (rowsCount > 0)
  288. {
  289. Model.insideOperation model;
  290. for (int n = 0; n < rowsCount; n++)
  291. {
  292. model = dal.DataRowToModelinsideOperation(dt.Rows[n]);
  293. if (model != null)
  294. {
  295. modelList.Add(model);
  296. }
  297. }
  298. }
  299. return modelList;
  300. }
  301. /// <summary>
  302. /// 获得操作记录信息数据列表 导入部分
  303. /// </summary>
  304. public List<Model.Operationlog> DataTableToListOperationlog(DataTable dt)
  305. {
  306. List<Model.Operationlog> modelList = new List<Model.Operationlog>();
  307. int rowsCount = dt.Rows.Count;
  308. if (rowsCount > 0)
  309. {
  310. Model.Operationlog model;
  311. for (int n = 0; n < rowsCount; n++)
  312. {
  313. model = dal.DataRowToModelOperationlog(dt.Rows[n]);
  314. if (model != null)
  315. {
  316. modelList.Add(model);
  317. }
  318. }
  319. }
  320. return modelList;
  321. }
  322. }
  323. }