ToChargeBackRecordController.cs 27 KB

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