ToChargeBackRecordController.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674
  1. /*
  2. * 待扣款明细
  3. */
  4. using System;
  5. using System.Web;
  6. using System.Collections.Generic;
  7. using System.Diagnostics;
  8. using System.Linq;
  9. using System.Threading.Tasks;
  10. using Microsoft.AspNetCore.Mvc;
  11. using Microsoft.AspNetCore.Http;
  12. using Microsoft.Extensions.Logging;
  13. using Microsoft.Extensions.Options;
  14. using MySystem.Models;
  15. using Library;
  16. using LitJson;
  17. using MySystemLib;
  18. namespace MySystem.Areas.Admin.Controllers
  19. {
  20. [Area("Admin")]
  21. [Route("Admin/[controller]/[action]")]
  22. public class ToChargeBackRecordController : BaseController
  23. {
  24. public ToChargeBackRecordController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
  25. {
  26. OtherMySqlConn.connstr = ConfigurationManager.AppSettings["SqlConnStr"].ToString();
  27. }
  28. #region 待扣款明细列表
  29. /// <summary>
  30. /// 根据条件查询待扣款明细列表
  31. /// </summary>
  32. /// <returns></returns>
  33. public IActionResult Index(ToChargeBackRecord data, string right)
  34. {
  35. ViewBag.RightInfo = RightInfo;
  36. ViewBag.right = right;
  37. return View();
  38. }
  39. #endregion
  40. #region 根据条件查询待扣款明细列表
  41. /// <summary>
  42. /// 待扣款明细列表
  43. /// </summary>
  44. /// <returns></returns>
  45. public JsonResult IndexData(ToChargeBackRecord data, string UserIdMakerCode, string PosSn, string CreateDateData, string ChargeTypeSelect, string StatusSelect, int page = 1, int limit = 30)
  46. {
  47. Dictionary<string, string> Fields = new Dictionary<string, string>();
  48. string condition = " and Status>-1";
  49. if (!string.IsNullOrEmpty(CreateDateData))
  50. {
  51. string[] datelist = CreateDateData.Split(new string[] { " - " }, StringSplitOptions.None);
  52. string start = datelist[0];
  53. string end = datelist[1];
  54. condition += " and CreateDate>='" + start + " 00:00:00' and CreateDate<='" + end + " 23:59:59'";
  55. }
  56. //创客编号
  57. if (!string.IsNullOrEmpty(UserIdMakerCode))
  58. {
  59. condition += " and UserId in (select UserId from UserForMakerCode where MakerCode='" + UserIdMakerCode + "')";
  60. }
  61. if (!string.IsNullOrEmpty(PosSn))
  62. {
  63. condition += " and Remark=" + PosSn;
  64. }
  65. //待扣类型
  66. if (!string.IsNullOrEmpty(ChargeTypeSelect))
  67. {
  68. condition += " and ChargeType=" + ChargeTypeSelect;
  69. }
  70. //扣款状态
  71. if (!string.IsNullOrEmpty(StatusSelect))
  72. {
  73. condition += " and Status=" + StatusSelect;
  74. }
  75. Dictionary<string, object> obj = new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).IndexData("ToChargeBackRecord", Fields, "Id desc", "0", page, limit, condition);
  76. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  77. foreach (Dictionary<string, object> dic in diclist)
  78. {
  79. //创客
  80. int UserId = int.Parse(function.CheckInt(dic["UserId"].ToString()));
  81. Users userid_Users = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  82. dic["UserIdMakerCode"] = userid_Users.MakerCode;
  83. dic["UserIdRealName"] = userid_Users.RealName;
  84. dic["UserIdMobile"] = userid_Users.Mobile;
  85. dic.Remove("UserId");
  86. //待扣类型
  87. int ChargeType = int.Parse(dic["ChargeType"].ToString());
  88. if (ChargeType == 124) dic["ChargeTypeName"] = "过期机具扣款";
  89. if (ChargeType == 1) dic["ChargeTypeName"] = "创客预扣款";
  90. if (ChargeType == 2) dic["ChargeTypeName"] = "分期预扣款";
  91. if (ChargeType == 0) dic["ChargeTypeName"] = "";
  92. //扣款状态
  93. int Status = int.Parse(dic["Status"].ToString());
  94. if (Status == 0) dic["StatusName"] = "待扣款";
  95. if (Status == 1) dic["StatusName"] = "已扣款";
  96. if (Status == 2) dic["StatusName"] = "已退还";
  97. if (Status == 3) dic["StatusName"] = "暂停扣款";
  98. }
  99. return Json(obj);
  100. }
  101. #endregion
  102. #region 增加待扣款明细
  103. /// <summary>
  104. /// 增加或修改待扣款明细信息
  105. /// </summary>
  106. /// <returns></returns>
  107. public IActionResult Add(string right)
  108. {
  109. ViewBag.RightInfo = RightInfo;
  110. ViewBag.right = right;
  111. return View();
  112. }
  113. #endregion
  114. #region 增加待扣款明细
  115. /// <summary>
  116. /// 增加或修改待扣款明细信息
  117. /// </summary>
  118. /// <returns></returns>
  119. [HttpPost]
  120. public string Add(ToChargeBackRecord data, string MakerCode)
  121. {
  122. Dictionary<string, object> Fields = new Dictionary<string, object>();
  123. var user = db.Users.FirstOrDefault(m => m.MakerCode == MakerCode) ?? new Users();
  124. if (user.Id == 0)
  125. {
  126. return "创客" + MakerCode + "不存在或编号错误";
  127. }
  128. Fields.Add("UserId", user.Id); //创客Id
  129. Fields.Add("ChargeAmount", data.ChargeAmount); //待扣金额
  130. Fields.Add("ChargeType", 1); //待扣类型
  131. Fields.Add("Remark", data.Remark); //备注
  132. Fields.Add("Field1", data.Field1); //备用字段
  133. Fields.Add("SeoTitle", data.SeoTitle);
  134. Fields.Add("SeoKeyword", data.SeoKeyword);
  135. Fields.Add("SeoDescription", data.Remark);
  136. int Id = new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Add("ToChargeBackRecord", Fields, 0);
  137. var toChargeBackRecord = db.ToChargeBackRecord.FirstOrDefault(m => m.Id == Id) ?? new ToChargeBackRecord();
  138. if (toChargeBackRecord.Id > 0)
  139. {
  140. toChargeBackRecord.UpdateDate = null;
  141. }
  142. AddSysLog(data.Id.ToString(), "ToChargeBackRecord", "add");
  143. db.SaveChanges();
  144. return "success";
  145. }
  146. #endregion
  147. #region 修改待扣款明细
  148. /// <summary>
  149. /// 增加或修改待扣款明细信息
  150. /// </summary>
  151. /// <returns></returns>
  152. public IActionResult Edit(string right, int Id = 0)
  153. {
  154. ViewBag.RightInfo = RightInfo;
  155. ViewBag.right = right;
  156. ToChargeBackRecord editData = db.ToChargeBackRecord.FirstOrDefault(m => m.Id == Id) ?? new ToChargeBackRecord();
  157. var user = db.Users.FirstOrDefault(m => m.Id == editData.UserId) ?? new Users();
  158. ViewBag.data = editData;
  159. ViewBag.MakerCode = user.MakerCode;
  160. return View();
  161. }
  162. #endregion
  163. #region 修改待扣款明细
  164. /// <summary>
  165. /// 增加或修改待扣款明细信息
  166. /// </summary>
  167. /// <returns></returns>
  168. [HttpPost]
  169. public string Edit(ToChargeBackRecord data)
  170. {
  171. Dictionary<string, object> Fields = new Dictionary<string, object>();
  172. var info = db.ToChargeBackRecord.FirstOrDefault(m => m.Id == data.Id) ?? new ToChargeBackRecord();
  173. if (info.ChargeAmount != data.ChargeAmount)
  174. {
  175. var userAccount = db.UserAccount.FirstOrDefault(m => m.Id == info.UserId) ?? new UserAccount();
  176. if (info.ChargeAmount > data.ChargeAmount)
  177. {
  178. userAccount.ToChargeAmount -= info.ChargeAmount - data.ChargeAmount;
  179. }
  180. if (info.ChargeAmount < data.ChargeAmount)
  181. {
  182. userAccount.ToChargeAmount += data.ChargeAmount - info.ChargeAmount;
  183. }
  184. }
  185. Fields.Add("ChargeAmount", data.ChargeAmount); //待扣金额
  186. Fields.Add("SeoDescription", data.SeoDescription);
  187. if (info.ChargeType != 124)
  188. {
  189. Fields.Add("Remark", data.SeoDescription);
  190. }
  191. new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("ToChargeBackRecord", Fields, data.Id);
  192. AddSysLog(data.Id.ToString(), "ToChargeBackRecord", "update");
  193. db.SaveChanges();
  194. return "success";
  195. }
  196. #endregion
  197. #region 删除待扣款明细信息
  198. /// <summary>
  199. /// 删除待扣款明细信息
  200. /// </summary>
  201. /// <returns></returns>
  202. public string Delete(string Id)
  203. {
  204. string[] idlist = Id.Split(new char[] { ',' });
  205. AddSysLog(Id, "ToChargeBackRecord", "del");
  206. foreach (string subid in idlist)
  207. {
  208. int id = int.Parse(subid);
  209. var toChargeBackRecord = db.ToChargeBackRecord.FirstOrDefault(m => m.Id == id) ?? new ToChargeBackRecord();
  210. var userAccount = db.UserAccount.FirstOrDefault(m => m.Id == toChargeBackRecord.UserId) ?? new UserAccount();
  211. userAccount.ToChargeAmount -= toChargeBackRecord.ChargeAmount;//删除预扣款记录时扣减相应预扣额度
  212. Dictionary<string, object> Fields = new Dictionary<string, object>();
  213. Fields.Add("Status", -1);
  214. new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("ToChargeBackRecord", Fields, id);
  215. }
  216. db.SaveChanges();
  217. return "success";
  218. }
  219. #endregion
  220. #region 开启
  221. /// <summary>
  222. /// 开启
  223. /// </summary>
  224. /// <returns></returns>
  225. public string Open(string Id)
  226. {
  227. string[] idlist = Id.Split(new char[] { ',' });
  228. AddSysLog(Id, "ToChargeBackRecord", "open");
  229. foreach (string subid in idlist)
  230. {
  231. int id = int.Parse(subid);
  232. Dictionary<string, object> Fields = new Dictionary<string, object>();
  233. Fields.Add("Status", 1);
  234. new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("ToChargeBackRecord", Fields, id);
  235. }
  236. db.SaveChanges();
  237. return "success";
  238. }
  239. #endregion
  240. #region 关闭
  241. /// <summary>
  242. /// 关闭
  243. /// </summary>
  244. /// <returns></returns>
  245. public string Close(string Id)
  246. {
  247. string[] idlist = Id.Split(new char[] { ',' });
  248. AddSysLog(Id, "ToChargeBackRecord", "close");
  249. foreach (string subid in idlist)
  250. {
  251. int id = int.Parse(subid);
  252. Dictionary<string, object> Fields = new Dictionary<string, object>();
  253. Fields.Add("Status", 0);
  254. new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("ToChargeBackRecord", Fields, id);
  255. }
  256. db.SaveChanges();
  257. return "success";
  258. }
  259. #endregion
  260. #region 暂停扣款
  261. /// <summary>
  262. /// 暂停扣款
  263. /// </summary>
  264. /// <returns></returns>
  265. public string Break(string Id)
  266. {
  267. string[] idlist = Id.Split(new char[] { ',' });
  268. AddSysLog(Id, "ToChargeBackRecord", "Break");
  269. foreach (string subid in idlist)
  270. {
  271. int id = int.Parse(subid);
  272. Dictionary<string, object> Fields = new Dictionary<string, object>();
  273. Fields.Add("Status", 3);
  274. new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("ToChargeBackRecord", Fields, id);
  275. }
  276. db.SaveChanges();
  277. return "success";
  278. }
  279. #endregion
  280. #region 开启扣款
  281. /// <summary>
  282. /// 开启扣款
  283. /// </summary>
  284. /// <returns></returns>
  285. public string Start(string Id)
  286. {
  287. string[] idlist = Id.Split(new char[] { ',' });
  288. AddSysLog(Id, "ToChargeBackRecord", "Start");
  289. foreach (string subid in idlist)
  290. {
  291. int id = int.Parse(subid);
  292. Dictionary<string, object> Fields = new Dictionary<string, object>();
  293. Fields.Add("Status", 0);
  294. new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("ToChargeBackRecord", Fields, id);
  295. }
  296. db.SaveChanges();
  297. return "success";
  298. }
  299. #endregion
  300. #region 排序
  301. /// <summary>
  302. /// 排序
  303. /// </summary>
  304. /// <param name="Id"></param>
  305. public string Sort(int Id, int Sort)
  306. {
  307. new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Sort("ToChargeBackRecord", Sort, Id);
  308. AddSysLog(Id.ToString(), "ToChargeBackRecord", "sort");
  309. return "success";
  310. }
  311. #endregion
  312. #region 导入预扣信息
  313. /// <summary>
  314. /// 导入预扣信息
  315. /// </summary>
  316. /// <param name="ExcelData"></param>
  317. public string ChargeImport(string ExcelData)
  318. {
  319. ExcelData = HttpUtility.UrlDecode(ExcelData);
  320. JsonData list = JsonMapper.ToObject(ExcelData);
  321. var info = "";
  322. var error = "";
  323. for (int i = 1; i < list.Count; i++)
  324. {
  325. JsonData dr = list[i];
  326. string itemJson = dr.ToJson();
  327. string MakerCode = itemJson.Contains("\"A\"") ? dr["A"].ToString() : "";
  328. string Name = itemJson.Contains("\"B\"") ? dr["B"].ToString() : "";
  329. string Amount = itemJson.Contains("\"C\"") ? dr["C"].ToString() : "";
  330. string Remark = itemJson.Contains("\"D\"") ? dr["D"].ToString() : "";
  331. var userForMakerCode = db.UserForMakerCode.FirstOrDefault(m => m.MakerCode == MakerCode) ?? new UserForMakerCode();
  332. var users = db.Users.FirstOrDefault(m => m.Id == userForMakerCode.UserId && m.RealName == Name) ?? new Users();
  333. var userAccount = db.UserAccount.FirstOrDefault(m => m.Id == users.Id);
  334. if (users.Id == 0)
  335. {
  336. error += "失败:" + MakerCode + "_" + Name + "创客不存在或创客编号和姓名不匹配" + '\n';
  337. }
  338. else
  339. {
  340. if (userAccount == null)
  341. {
  342. userAccount = db.UserAccount.Add(new UserAccount()
  343. {
  344. Id = users.Id,
  345. UserId = users.Id,
  346. }).Entity;
  347. db.SaveChanges();
  348. }
  349. userAccount.ToChargeAmount += decimal.Parse(Amount);
  350. var ToChargeBackRecord = db.ToChargeBackRecord.Add(new ToChargeBackRecord
  351. {
  352. CreateDate = DateTime.Now,
  353. SeoTitle = SysUserName + "_" + SysRealName,
  354. SeoDescription = Remark,
  355. Remark = Remark,
  356. ChargeType = 1,
  357. ChargeAmount = decimal.Parse(Amount),
  358. UserId = users.Id,
  359. }).Entity;
  360. info += "创客编号:" + MakerCode + ";创客姓名:" + Name + ";金额:" + Amount + ";备注:" + Remark + "<br/>";
  361. }
  362. }
  363. if (!string.IsNullOrEmpty(error))
  364. {
  365. return "Warning|" + error;
  366. }
  367. string text = string.Format("预扣信息: '" + info + "',Time'" + DateTime.Now + "'");
  368. function.WriteLog(text, "导入预扣信息");//机具扣款退还
  369. db.SaveChanges();
  370. AddSysLog("0", "ToChargeBackRecord", "ChargeImport");
  371. return "success";
  372. }
  373. #endregion
  374. #region 机具扣款退还
  375. /// <summary>
  376. /// 导入数据
  377. /// </summary>
  378. /// <param name="ExcelData"></param>
  379. public string Import(string ExcelData)
  380. {
  381. ExcelData = HttpUtility.UrlDecode(ExcelData);
  382. JsonData list = JsonMapper.ToObject(ExcelData);
  383. var info = "";
  384. var error = "";
  385. for (int i = 1; i < list.Count; i++)
  386. {
  387. JsonData dr = list[i];
  388. string PosSn = dr[0].ToString(); // 机具Sn
  389. var toChargeBackRecord = db.ToChargeBackRecord.FirstOrDefault(m => m.Status < 2 && m.Remark == PosSn) ?? new ToChargeBackRecord();
  390. var userAccount = db.UserAccount.FirstOrDefault(m => m.Id == toChargeBackRecord.UserId) ?? new UserAccount();
  391. if (toChargeBackRecord.Id == 0)
  392. {
  393. error += "失败" + PosSn + ',' + "不符合退还条件" + '\n';
  394. }
  395. if (toChargeBackRecord.Id > 0 && toChargeBackRecord.Status == 0)//待扣款
  396. {
  397. userAccount.ToChargeAmount -= toChargeBackRecord.ChargeAmount;
  398. toChargeBackRecord.Status = 2;
  399. }
  400. if (toChargeBackRecord.Id > 0 && toChargeBackRecord.Status == 1)//已扣款
  401. {
  402. var userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord
  403. {
  404. CreateDate = DateTime.Now,
  405. UserId = toChargeBackRecord.UserId,
  406. BeforeBalanceAmount = userAccount.BalanceAmount,
  407. AfterBalanceAmount = userAccount.BalanceAmount + toChargeBackRecord.ChargeAmount,
  408. ChangeAmount = toChargeBackRecord.ChargeAmount,
  409. ChangeType = 126,
  410. Remark = "机具货款退还",
  411. }).Entity;
  412. userAccount.BalanceAmount += toChargeBackRecord.ChargeAmount;
  413. toChargeBackRecord.Status = 2;
  414. info += toChargeBackRecord.Remark + "," + toChargeBackRecord.ChargeAmount + "<br/>";
  415. }
  416. }
  417. if (!string.IsNullOrEmpty(error))
  418. {
  419. return "Warning|" + error;
  420. }
  421. string text = string.Format("退款信息: '" + info + "',Time'" + DateTime.Now + "'");
  422. function.WriteLog(text, "机具扣款退还");//机具扣款退还
  423. db.SaveChanges();
  424. AddSysLog("0", "ToChargeBackRecord", "Import");
  425. return "success";
  426. }
  427. #endregion
  428. #region 机具回收确认退还
  429. /// <summary>
  430. /// 导入数据
  431. /// </summary>
  432. /// <param name="ExcelData"></param>
  433. public string Imports(string ExcelData)
  434. {
  435. ExcelData = HttpUtility.UrlDecode(ExcelData);
  436. JsonData list = JsonMapper.ToObject(ExcelData);
  437. var info = "";
  438. var error = "";
  439. for (int i = 1; i < list.Count; i++)
  440. {
  441. JsonData dr = list[i];
  442. string PosSn = dr[0].ToString(); // 机具Sn
  443. var toChargeBackRecord = db.ToChargeBackRecord.FirstOrDefault(m => m.Remark == PosSn) ?? new ToChargeBackRecord();
  444. var recycMachineOrderPos = db.RecycMachineOrderPos.FirstOrDefault(m => m.Status == 1 && m.SnNo == PosSn) ?? new RecycMachineOrderPos();
  445. if (recycMachineOrderPos.Id == 0)
  446. {
  447. error += "以下操作失败" + PosSn + ',' + "不符合退还条件" + '\n';
  448. }
  449. else
  450. {
  451. var userAccount = db.UserAccount.FirstOrDefault(m => m.Id == toChargeBackRecord.UserId) ?? new UserAccount();
  452. //已扣款
  453. if (toChargeBackRecord.Status == 1)
  454. {
  455. var userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord
  456. {
  457. CreateDate = DateTime.Now,
  458. UserId = toChargeBackRecord.UserId,
  459. BeforeBalanceAmount = userAccount.BalanceAmount,
  460. AfterBalanceAmount = userAccount.BalanceAmount + toChargeBackRecord.ChargeAmount,
  461. ChangeAmount = toChargeBackRecord.ChargeAmount,
  462. ChangeType = 126,
  463. Remark = "机具货款退还",
  464. }).Entity;
  465. userAccount.BalanceAmount += toChargeBackRecord.ChargeAmount;
  466. toChargeBackRecord.Status = 2;
  467. info += toChargeBackRecord.Remark + "," + toChargeBackRecord.ChargeAmount + "<br/>";
  468. }
  469. //未扣款
  470. if (toChargeBackRecord.Status == 0)
  471. {
  472. toChargeBackRecord.Status = 2;
  473. }
  474. }
  475. }
  476. if (!string.IsNullOrEmpty(error))
  477. {
  478. return "Warning|" + error;
  479. }
  480. if (!string.IsNullOrEmpty(info))
  481. {
  482. string text = string.Format("退款信息: '" + info + "',Time'" + DateTime.Now + "'");
  483. function.WriteLog(text, "机具回收确认退还");//机具回收确认退还
  484. }
  485. db.SaveChanges();
  486. AddSysLog("0", "ToChargeBackRecord", "Import");
  487. return "success";
  488. }
  489. #endregion
  490. #region 导出Excel
  491. /// <summary>
  492. /// 导出Excel
  493. /// </summary>
  494. /// <returns></returns>
  495. public JsonResult ExportExcel(ToChargeBackRecord data, string CreateDateData, string UserIdMakerCode, string ChargeTypeSelect, string StatusSelect)
  496. {
  497. Dictionary<string, string> Fields = new Dictionary<string, string>();
  498. // Fields.Add("CreateDate", "3"); //时间
  499. string condition = " and Status>-1";
  500. if (!string.IsNullOrEmpty(CreateDateData))
  501. {
  502. string[] datelist = CreateDateData.Split(new string[] { " - " }, StringSplitOptions.None);
  503. string start = datelist[0];
  504. string end = datelist[1];
  505. condition += " and CreateDate>='" + start + " 00:00:00' and CreateDate<='" + end + " 23:59:59'";
  506. }
  507. //创客编号
  508. if (!string.IsNullOrEmpty(UserIdMakerCode))
  509. {
  510. condition += " and UserId in (select UserId from UserForMakerCode where MakerCode='" + UserIdMakerCode + "')";
  511. }
  512. //待扣类型
  513. if (!string.IsNullOrEmpty(ChargeTypeSelect))
  514. {
  515. condition += " and ChargeType=" + ChargeTypeSelect;
  516. }
  517. //扣款状态
  518. if (!string.IsNullOrEmpty(StatusSelect))
  519. {
  520. condition += " and Status=" + StatusSelect;
  521. }
  522. Dictionary<string, object> obj = new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).IndexData("ToChargeBackRecord", Fields, "Id desc", "0", 1, 20000, condition, "Id,UserId,ChargeAmount,ChargeType,Remark", false);
  523. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  524. foreach (Dictionary<string, object> dic in diclist)
  525. {
  526. //创客
  527. int UserId = int.Parse(function.CheckInt(dic["UserId"].ToString()));
  528. Users userid_Users = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  529. dic["UserIdMakerCode"] = userid_Users.MakerCode;
  530. dic["UserIdRealName"] = userid_Users.RealName;
  531. dic["UserIdMobile"] = userid_Users.Mobile;
  532. dic.Remove("UserId");
  533. //待扣类型
  534. int ChargeType = int.Parse(dic["ChargeType"].ToString());
  535. if (ChargeType == 124) dic["ChargeType"] = "过期机具扣款";
  536. int Id = int.Parse(function.CheckInt(dic["Id"].ToString()));
  537. var toChargeBackRecord = db.ToChargeBackRecord.FirstOrDefault(m => m.Id == Id) ?? new ToChargeBackRecord();
  538. //扣款状态
  539. if (toChargeBackRecord.Status == 0) dic["Status"] = "待扣款未返还";
  540. if (toChargeBackRecord.Status == 1) dic["Status"] = "已扣款未返还";
  541. if (toChargeBackRecord.Status == 2) dic["Status"] = "已返还";
  542. decimal ChargeAmount = decimal.Parse(dic["ChargeAmount"].ToString());//应扣金额
  543. decimal ChargeAmountf = 0;//实扣金额
  544. dic["ChargeAmountf"] = "";
  545. if (toChargeBackRecord.Status == 1)//已扣款
  546. {
  547. ChargeAmountf = ChargeAmount;
  548. dic["ChargeAmountf"] = ChargeAmountf;
  549. }
  550. var pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == toChargeBackRecord.Remark) ?? new PosMachinesTwo();
  551. dic["BrandId"] = RelationClass.GetKqProductBrandInfo(pos.BrandId);
  552. if (pos.PosSnType == 0) dic["PosSnType"] = "兑换机";
  553. if (pos.PosSnType == 1) dic["PosSnType"] = "循环机";
  554. dic["RecycEndDate"] = pos.RecycEndDate;
  555. }
  556. Dictionary<string, object> result = new Dictionary<string, object>();
  557. result.Add("Info", "Excel报表-" + DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss") + ".xlsx");
  558. result.Add("Obj", diclist);
  559. Dictionary<string, object> ReturnFields = new Dictionary<string, object>();
  560. ReturnFields.Add("Id", "Id");
  561. ReturnFields.Add("ChargeType", "类型");
  562. ReturnFields.Add("Remark", "机具sn");
  563. ReturnFields.Add("BrandId", "品牌");
  564. ReturnFields.Add("PosSnType", "机具类型");
  565. ReturnFields.Add("RecycEndDate", "循环过期时间");
  566. ReturnFields.Add("UserIdMakerCode", "创客编号");
  567. ReturnFields.Add("UserIdRealName", "创客姓名");
  568. ReturnFields.Add("UserIdMobile", "创客手机号");
  569. ReturnFields.Add("ChargeAmount", "应扣金额");
  570. ReturnFields.Add("ChargeAmountf", "实扣金额");
  571. ReturnFields.Add("Status", "扣款状态");
  572. result.Add("Fields", ReturnFields);
  573. AddSysLog("0", "ToChargeBackRecord", "ExportExcel");
  574. return Json(result);
  575. }
  576. #endregion
  577. #region 分期扣款
  578. public IActionResult ChangeInfoDo(string right)
  579. {
  580. ViewBag.RightInfo = RightInfo;
  581. ViewBag.right = right;
  582. return View();
  583. }
  584. public string ChangeInfoDo(string PosCouponCodes, string FromMakerCode)
  585. {
  586. var result = "";
  587. return result;
  588. }
  589. #endregion
  590. }
  591. }