UserCashRecordOperatesController.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658
  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.Data;
  10. using System.Threading.Tasks;
  11. using Microsoft.AspNetCore.Mvc;
  12. using Microsoft.AspNetCore.Http;
  13. using Microsoft.Extensions.Logging;
  14. using Microsoft.Extensions.Options;
  15. using MySystem.OpModels;
  16. using Library;
  17. using LitJson;
  18. using MySystemLib;
  19. namespace MySystem.Areas.Admin.Controllers
  20. {
  21. [Area("Admin")]
  22. [Route("Admin/[controller]/[action]")]
  23. public class UserCashRecordOperatesController : BaseController
  24. {
  25. public UserCashRecordOperatesController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
  26. {
  27. OtherMySqlConn.connstr = ConfigurationManager.AppSettings["OpSqlConnStr"].ToString();
  28. }
  29. #region 提现记录列表
  30. /// <summary>
  31. /// 根据条件查询提现记录列表
  32. /// </summary>
  33. /// <returns></returns>
  34. public IActionResult Index(UserCashRecord data, string right)
  35. {
  36. ViewBag.RightInfo = RightInfo;
  37. ViewBag.right = right;
  38. string Condition = "";
  39. Condition += "CashOrderNo:\"" + data.CashOrderNo + "\",";
  40. Condition += "TradeType:\"" + data.TradeType + "\",";
  41. if (!string.IsNullOrEmpty(Condition))
  42. {
  43. Condition = Condition.TrimEnd(',');
  44. Condition = ", where: {" + Condition + "}";
  45. }
  46. ViewBag.Condition = Condition;
  47. return View();
  48. }
  49. #endregion
  50. #region 根据条件查询提现记录列表
  51. /// <summary>
  52. /// 提现记录列表
  53. /// </summary>
  54. /// <returns></returns>
  55. public JsonResult IndexData(UserCashRecord data, string OpCode, string StatusSelect, string CreateDateData, int page = 1, int limit = 30)
  56. {
  57. Dictionary<string, string> Fields = new Dictionary<string, string>();
  58. Fields.Add("CashOrderNo", "1"); //提现单号
  59. Fields.Add("TradeType", "0"); //交易类型
  60. string condition = " and Status>-1 and TradeType=3";
  61. //运营中心编号
  62. if (!string.IsNullOrEmpty(OpCode))
  63. {
  64. condition += " and UserId in (select UserId from SysAdmin where OpCode='" + OpCode + "')";
  65. }
  66. //提现状态
  67. if (!string.IsNullOrEmpty(StatusSelect))
  68. {
  69. condition += " and Status=" + StatusSelect;
  70. }
  71. if (!string.IsNullOrEmpty(data.CashOrderNo))
  72. {
  73. condition += " and CashOrderNo='" + data.CashOrderNo + "'";
  74. }
  75. if (data.TradeType > 0)
  76. {
  77. condition += " and TradeType=" + data.TradeType;
  78. }
  79. if (!string.IsNullOrEmpty(CreateDateData))
  80. {
  81. string[] datelist = CreateDateData.Split(new string[] { " - " }, StringSplitOptions.None);
  82. // string start = datelist[0];
  83. // string end = datelist[1];
  84. // condition += " and CreateDate>='" + start + " 00:00:00' and CreateDate<='" + end + " 23:59:59'";
  85. var start = Convert.ToDateTime(Convert.ToDateTime(datelist[0]).ToString("yyyy-MM-dd"));
  86. var end = Convert.ToDateTime(Convert.ToDateTime(datelist[1]).ToString("yyyy-MM-dd") + " 23:59:59");
  87. var check = opdb.UserCashRecord.Any(m => m.CreateDate >= start && m.TradeType < 3);
  88. var checks = opdb.UserCashRecord.Any(m => m.CreateDate <= end && m.TradeType < 3);
  89. if (check)
  90. {
  91. var sId = opdb.UserCashRecord.Where(m => m.CreateDate >= start && m.TradeType < 3).Min(m => m.Id);
  92. condition += " and Id >=" + sId;
  93. }
  94. if (checks)
  95. {
  96. var eId = opdb.UserCashRecord.Where(m => m.CreateDate <= end && m.TradeType < 3).Max(m => m.Id);
  97. condition += " and Id <=" + eId;
  98. }
  99. }
  100. else
  101. {
  102. var start = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToString("yyyy-MM") + "-01");
  103. var check = opdb.UserCashRecord.Any(m => m.CreateDate >= start && m.TradeType < 3);
  104. if (check)
  105. {
  106. var minId = opdb.UserCashRecord.Where(m => m.CreateDate >= start && m.TradeType < 3).Min(m => m.Id);
  107. var Info = function.ReadInstance("/WritePage/OpUserCashRecord/OpUserCashRecord.txt");
  108. if (string.IsNullOrEmpty(Info.ToString()))
  109. {
  110. function.WritePage("/WritePage/OpUserCashRecord/", "OpUserCashRecord.txt", minId.ToString());
  111. condition += " and Id >=" + minId;
  112. }
  113. else
  114. {
  115. condition += " and Id >=" + Convert.ToInt32(Info);
  116. }
  117. }
  118. else
  119. {
  120. condition += " and Id =0";
  121. }
  122. }
  123. Dictionary<string, object> obj = new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).IndexData("UserCashRecord", Fields, "Id desc", "0", page, limit, condition);
  124. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  125. foreach (Dictionary<string, object> dic in diclist)
  126. {
  127. int UserId = int.Parse(dic["UserId"].ToString());
  128. SysAdmin sysAdmin = opdb.SysAdmin.FirstOrDefault(m => m.UserId == UserId) ?? new SysAdmin();
  129. dic["OpCode"] = sysAdmin.OpCode;
  130. dic["MakerCode"] = sysAdmin.MakerCode;
  131. dic["RealName"] = sysAdmin.MakerName;
  132. dic["TradeType"] = RelationClassForConst.GetTradeTypeInfo(int.Parse(dic["TradeType"].ToString()));
  133. int Status = int.Parse(dic["Status"].ToString());
  134. if (Status == 0) dic["StatusName"] = "处理中";
  135. if (Status == 1) dic["StatusName"] = "成功";
  136. if (Status == 2) dic["StatusName"] = "失败";
  137. int QueryCount = int.Parse(dic["QueryCount"].ToString());
  138. if (QueryCount == 0) dic["LockName"] = "待提交";
  139. if (QueryCount == 1) dic["LockName"] = "已提交";
  140. }
  141. Dictionary<string, object> other = new Dictionary<string, object>();
  142. string WaitAmount = "0.00";//待处理总金额
  143. string SuccessAmount = "0.00";//提现成功总金额
  144. string FailAmount = "0.00";//提现失败总金额
  145. DataTable dt = OtherMySqlConn.dtable("SELECT SUM(if(Status=0,TradeAmount,0)),SUM(if(Status=1,TradeAmount,0)),SUM(if(Status=2,TradeAmount,0)) FROM UserCashRecord where 1=1 " + condition);
  146. if (dt.Rows.Count > 0)
  147. {
  148. WaitAmount = decimal.Parse(function.CheckNum(dt.Rows[0][0].ToString())).ToString("f2");
  149. SuccessAmount = decimal.Parse(function.CheckNum(dt.Rows[0][1].ToString())).ToString("f2");
  150. FailAmount = decimal.Parse(function.CheckNum(dt.Rows[0][2].ToString())).ToString("f2");
  151. }
  152. other.Add("WaitAmount", WaitAmount);
  153. other.Add("SuccessAmount", SuccessAmount);
  154. other.Add("FailAmount", FailAmount);
  155. obj.Add("other", other);
  156. return Json(obj);
  157. }
  158. #endregion
  159. #region 增加提现记录
  160. /// <summary>
  161. /// 增加或修改提现记录信息
  162. /// </summary>
  163. /// <returns></returns>
  164. public IActionResult Add(string right)
  165. {
  166. ViewBag.RightInfo = RightInfo;
  167. ViewBag.right = right;
  168. return View();
  169. }
  170. #endregion
  171. #region 增加提现记录
  172. /// <summary>
  173. /// 增加或修改提现记录信息
  174. /// </summary>
  175. /// <returns></returns>
  176. [HttpPost]
  177. public string Add(UserCashRecord data)
  178. {
  179. Dictionary<string, object> Fields = new Dictionary<string, object>();
  180. Fields.Add("Remark", data.Remark); //备注
  181. Fields.Add("SeoTitle", data.SeoTitle);
  182. Fields.Add("SeoKeyword", data.SeoKeyword);
  183. Fields.Add("SeoDescription", data.SeoDescription);
  184. int Id = new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Add("UserCashRecord", Fields, 0);
  185. AddSysLog(data.Id.ToString(), "UserCashRecord", "add");
  186. db.SaveChanges();
  187. return "success";
  188. }
  189. #endregion
  190. #region 修改提现记录
  191. /// <summary>
  192. /// 增加或修改提现记录信息
  193. /// </summary>
  194. /// <returns></returns>
  195. public IActionResult Edit(string right, int Id = 0)
  196. {
  197. ViewBag.RightInfo = RightInfo;
  198. ViewBag.right = right;
  199. UserCashRecord editData = opdb.UserCashRecord.FirstOrDefault(m => m.Id == Id) ?? new UserCashRecord();
  200. ViewBag.data = editData;
  201. return View();
  202. }
  203. #endregion
  204. #region 修改提现记录
  205. /// <summary>
  206. /// 增加或修改提现记录信息
  207. /// </summary>
  208. /// <returns></returns>
  209. [HttpPost]
  210. public string Edit(UserCashRecord data)
  211. {
  212. Dictionary<string, object> Fields = new Dictionary<string, object>();
  213. Fields.Add("Remark", data.Remark); //备注
  214. Fields.Add("SeoTitle", data.SeoTitle);
  215. Fields.Add("SeoKeyword", data.SeoKeyword);
  216. Fields.Add("SeoDescription", data.SeoDescription);
  217. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("UserCashRecord", Fields, data.Id);
  218. AddSysLog(data.Id.ToString(), "UserCashRecord", "update");
  219. opdb.SaveChanges();
  220. return "success";
  221. }
  222. #endregion
  223. #region 删除提现记录信息
  224. /// <summary>
  225. /// 删除提现记录信息
  226. /// </summary>
  227. /// <returns></returns>
  228. public string Delete(string Id)
  229. {
  230. string[] idlist = Id.Split(new char[] { ',' });
  231. AddSysLog(Id, "UserCashRecord", "del");
  232. foreach (string subid in idlist)
  233. {
  234. int id = int.Parse(subid);
  235. Dictionary<string, object> Fields = new Dictionary<string, object>();
  236. Fields.Add("Status", -1);
  237. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("UserCashRecord", Fields, id);
  238. }
  239. opdb.SaveChanges();
  240. return "success";
  241. }
  242. #endregion
  243. #region 开启
  244. /// <summary>
  245. /// 开启
  246. /// </summary>
  247. /// <returns></returns>
  248. public string Open(string Id)
  249. {
  250. string[] idlist = Id.Split(new char[] { ',' });
  251. AddSysLog(Id, "UserCashRecord", "open");
  252. foreach (string subid in idlist)
  253. {
  254. int id = int.Parse(subid);
  255. Dictionary<string, object> Fields = new Dictionary<string, object>();
  256. Fields.Add("Status", 1);
  257. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("UserCashRecord", Fields, id);
  258. }
  259. opdb.SaveChanges();
  260. return "success";
  261. }
  262. #endregion
  263. #region 关闭
  264. /// <summary>
  265. /// 关闭
  266. /// </summary>
  267. /// <returns></returns>
  268. public string Close(string Id)
  269. {
  270. string[] idlist = Id.Split(new char[] { ',' });
  271. AddSysLog(Id, "UserCashRecord", "close");
  272. foreach (string subid in idlist)
  273. {
  274. int id = int.Parse(subid);
  275. Dictionary<string, object> Fields = new Dictionary<string, object>();
  276. Fields.Add("Status", 0);
  277. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("UserCashRecord", Fields, id);
  278. }
  279. opdb.SaveChanges();
  280. return "success";
  281. }
  282. #endregion
  283. #region 批量设置成功
  284. /// <summary>
  285. /// 批量设置成功
  286. /// </summary>
  287. /// <returns></returns>
  288. public string BatchSetting(string Id)
  289. {
  290. string[] idlist = Id.Split(new char[] { ',' });
  291. AddSysLog(Id, "OpUserCashRecord", "BatchSetting");
  292. foreach (string subid in idlist)
  293. {
  294. int id = int.Parse(subid);
  295. Dictionary<string, object> Fields = new Dictionary<string, object>();
  296. Fields.Add("Status", 1);//设置提现记录为成功
  297. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("UserCashRecord", Fields, id);
  298. var userCashRecord = opdb.UserCashRecord.FirstOrDefault(m => m.Id == id) ?? new UserCashRecord();
  299. if (userCashRecord.Id > 0)
  300. {
  301. UserAccount account = opdb.UserAccount.FirstOrDefault(m => m.UserId == Convert.ToInt32(userCashRecord.UserId));
  302. if (account != null)
  303. {
  304. account.QueryCount = 1;
  305. decimal TradeAmount = userCashRecord.TradeAmount;
  306. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  307. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  308. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  309. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  310. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  311. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  312. opdb.UserAccountRecord.Add(new UserAccountRecord()
  313. {
  314. CreateDate = DateTime.Now,
  315. UserId = userCashRecord.UserId, //运营中心
  316. ChangeType = 3, //变动类型
  317. ProductType = 99, //产品类型
  318. ChangeAmount = userCashRecord.ActualTradeAmount, //变更金额
  319. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  320. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  321. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  322. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  323. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  324. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  325. });
  326. opdb.UserAccountRecord.Add(new UserAccountRecord()
  327. {
  328. CreateDate = DateTime.Now,
  329. UserId = userCashRecord.UserId, //运营中心
  330. ChangeType = 4, //变动类型
  331. ProductType = 99, //产品类型
  332. ChangeAmount = userCashRecord.TradeFee, //变更金额
  333. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  334. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  335. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  336. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  337. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  338. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  339. });
  340. opdb.UserAccountRecord.Add(new UserAccountRecord()
  341. {
  342. CreateDate = DateTime.Now,
  343. UserId = userCashRecord.UserId, //运营中心
  344. ChangeType = 5, //变动类型
  345. ProductType = 99, //产品类型
  346. ChangeAmount = userCashRecord.ManageFee, //变更金额
  347. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  348. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  349. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  350. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  351. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  352. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  353. });
  354. opdb.SaveChanges();
  355. RedisDbconn.Instance.Set("OpUserAccount:" + userCashRecord.UserId, account);
  356. }
  357. }
  358. }
  359. opdb.SaveChanges();
  360. return "success";
  361. }
  362. #endregion
  363. #region 排序
  364. /// <summary>
  365. /// 排序
  366. /// </summary>
  367. /// <param name="Id"></param>
  368. public string Sort(int Id, int Sort)
  369. {
  370. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Sort("UserCashRecord", Sort, Id);
  371. AddSysLog(Id.ToString(), "UserCashRecord", "sort");
  372. return "success";
  373. }
  374. #endregion
  375. #region 导入数据
  376. public IActionResult Import(string right)
  377. {
  378. ViewBag.RightInfo = RightInfo;
  379. ViewBag.right = right;
  380. return View();
  381. }
  382. /// <summary>
  383. /// 导入数据
  384. /// </summary>
  385. /// <param name="ExcelData"></param>
  386. [HttpPost]
  387. public string ImportPost(string ExcelPath)
  388. {
  389. string key = function.MD5_16(Guid.NewGuid().ToString());
  390. RedisDbconn.Instance.AddList("ExcelImportV3", ExcelPath + "#cut#OpUserCashRecord#cut#" + key + "#cut#" + SysUserName);
  391. return "success|" + key;
  392. }
  393. public string CheckImport(string key)
  394. {
  395. string result = RedisDbconn.Instance.Get<string>("OpCheckImport:" + key);
  396. if (!string.IsNullOrEmpty(result))
  397. {
  398. string[] datalist = result.Split('|');
  399. if (datalist[0] == "success")
  400. {
  401. return result;
  402. }
  403. return datalist[0];
  404. }
  405. return "0";
  406. }
  407. #endregion
  408. #region 导出Excel
  409. /// <summary>
  410. /// 导出Excel
  411. /// </summary>
  412. /// <returns></returns>
  413. public JsonResult ExportExcel(UserCashRecord data, string OpCode, string StatusSelect, string PayStatus)
  414. {
  415. Dictionary<string, string> Fields = new Dictionary<string, string>();
  416. Fields.Add("CashOrderNo", "1"); //提现单号
  417. Fields.Add("CreateDate", "3"); //创建时间
  418. Fields.Add("TradeType", "0"); //交易类型
  419. string condition = " and Status>-1 and TradeType=3";
  420. //运营中心编号
  421. if (!string.IsNullOrEmpty(OpCode))
  422. {
  423. var sysUser = opdb.SysAdmin.FirstOrDefault(m => m.OpCode == OpCode) ?? new OpModels.SysAdmin();
  424. if (sysUser.Id > 0)
  425. {
  426. condition += " and OpId=" + sysUser.UserId;
  427. }
  428. }
  429. //提现状态
  430. if (!string.IsNullOrEmpty(StatusSelect))
  431. {
  432. condition += " and Status=" + StatusSelect;
  433. }
  434. //提交到代付状态
  435. if (!string.IsNullOrEmpty(PayStatus))
  436. {
  437. int QueryCount = int.Parse(function.CheckInt(PayStatus));
  438. if (QueryCount == 2)
  439. {
  440. QueryCount = 0;
  441. }
  442. condition += " and QueryCount=" + QueryCount;
  443. }
  444. Dictionary<string, object> obj = new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).IndexData("UserCashRecord", Fields, "Id desc", "0", 1, 20000, condition, "CashOrderNo,UserId,IdCardNo,ActualTradeAmount,Remark,Status,QueryCount,CreateDate", false);
  445. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  446. foreach (Dictionary<string, object> dic in diclist)
  447. {
  448. int UserId = int.Parse(dic["UserId"].ToString());
  449. SysAdmin sysAdmin = opdb.SysAdmin.FirstOrDefault(m => m.UserId == UserId) ?? new SysAdmin();
  450. var user = db.Users.FirstOrDefault(m => m.Id == sysAdmin.UserId) ?? new Models.Users();
  451. dic["OpCode"] = sysAdmin.OpCode;
  452. dic["MakerCode"] = sysAdmin.MakerCode;
  453. dic["MakerName"] = sysAdmin.MakerName;
  454. dic["RealName"] = sysAdmin.RealName;
  455. dic["Mobile"] = sysAdmin.MakerMobile;
  456. dic["SettleBankName"] = user.SettleBankName;
  457. dic["SettleBankCardNo"] = user.SettleBankCardNo;
  458. dic.Remove("UserId");
  459. // dic["TradeType"] = RelationClassForConst.GetTradeTypeInfo(int.Parse(dic["TradeType"].ToString()));
  460. int Status = int.Parse(dic["Status"].ToString());
  461. if (Status == 0) dic["StatusName"] = "处理中";
  462. if (Status == 1) dic["StatusName"] = "成功";
  463. if (Status == 2) dic["StatusName"] = "失败";
  464. dic.Remove("Status");
  465. int QueryCount = int.Parse(dic["QueryCount"].ToString());
  466. if (QueryCount == 0) dic["LockName"] = "待提交";
  467. if (QueryCount == 1) dic["LockName"] = "已提交";
  468. dic.Remove("QueryCount");
  469. }
  470. Dictionary<string, object> result = new Dictionary<string, object>();
  471. result.Add("Status", "1");
  472. result.Add("Info", "Excel报表-" + DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss") + ".xlsx");
  473. result.Add("Obj", diclist);
  474. Dictionary<string, object> ReturnFields = new Dictionary<string, object>();
  475. ReturnFields.Add("CashOrderNo", "提现单号");
  476. ReturnFields.Add("OpCode", "运营中心编号");
  477. ReturnFields.Add("MakerCode", "创客编号");
  478. ReturnFields.Add("MakerName", "创客姓名");
  479. ReturnFields.Add("Mobile", "手机号");
  480. ReturnFields.Add("IdCardNo", "身份证号");
  481. ReturnFields.Add("SettleBankName", "开户行名称");
  482. ReturnFields.Add("SettleBankCardNo", "开户行卡号");
  483. ReturnFields.Add("ActualTradeAmount", "发佣金额(单位:元)");
  484. ReturnFields.Add("LockName", "代付标记");
  485. ReturnFields.Add("StatusName", "状态");
  486. ReturnFields.Add("Remark", "备注");
  487. ReturnFields.Add("CreateDate", "创建时间");
  488. // ReturnFields.Add("CashOrderNo", "提现单号");
  489. // ReturnFields.Add("MakerCode", "创客编码");
  490. // ReturnFields.Add("RealName", "创客名称");
  491. // ReturnFields.Add("IdCardNo", "身份证号");
  492. // ReturnFields.Add("SettleBankCardNo", "提现卡号");
  493. // ReturnFields.Add("SettleBankName", "银行名称");
  494. // ReturnFields.Add("TradeType", "交易类型");
  495. // ReturnFields.Add("TradeAmount", "交易金额(元)");
  496. // ReturnFields.Add("Status", "订单状态");
  497. // ReturnFields.Add("ReturnCode", "提现服务返回编码");
  498. // ReturnFields.Add("ReturnMsg", "提现服务返回信息");
  499. result.Add("Fields", ReturnFields);
  500. AddSysLog("0", "OpUserCashRecord", "ExportExcel");
  501. return Json(result);
  502. }
  503. #endregion
  504. #region 拒绝
  505. /// <summary>
  506. /// 拒绝
  507. /// </summary>
  508. /// <returns></returns>
  509. public IActionResult Reduce(string right, int Id = 0)
  510. {
  511. ViewBag.RightInfo = RightInfo;
  512. ViewBag.right = right;
  513. UserCashRecord editData = opdb.UserCashRecord.FirstOrDefault(m => m.Id == Id) ?? new UserCashRecord();
  514. ViewBag.data = editData;
  515. return View();
  516. }
  517. #endregion
  518. #region 拒绝
  519. /// <summary>
  520. /// 拒绝
  521. /// </summary>
  522. /// <returns></returns>
  523. public string ReduceDo(int Id, string Remark)
  524. {
  525. AddSysLog(Id, "UserCashRecord", "Reduce");
  526. UserCashRecord edit = opdb.UserCashRecord.FirstOrDefault(m => m.Id == Id);
  527. if (edit != null)
  528. {
  529. edit.Status = 2;
  530. edit.Remark = Remark;
  531. edit.UpdateMan = SysUserName;
  532. UserAccount account = opdb.UserAccount.FirstOrDefault(m => m.Id == edit.UserId);
  533. if (account != null)
  534. {
  535. decimal TradeAmount = edit.TradeAmount;
  536. decimal BeforeTotalAmount = account.ValidForGetAmount; //变更前总金额
  537. account.ValidForGetAmount += TradeAmount;//返回可提现余额
  538. decimal AfterTotalAmount = account.ValidForGetAmount; //变更后总金额
  539. opdb.AmountRecord.Add(new AmountRecord()
  540. {
  541. CreateDate = DateTime.Now,
  542. SeoDescription = "提现驳回",
  543. UserId = edit.UserId, //创客
  544. UseAmount = TradeAmount, //变更金额
  545. BeforeAmount = BeforeTotalAmount, //变更前总金额
  546. AfterAmount = AfterTotalAmount, //变更后总金额
  547. });
  548. opdb.SaveChanges();
  549. }
  550. opdb.SaveChanges();
  551. }
  552. return "success";
  553. }
  554. #endregion
  555. #region 解除
  556. /// <summary>
  557. /// 解除
  558. /// </summary>
  559. /// <returns></returns>
  560. public string Cancel(string Id)
  561. {
  562. string[] idlist = Id.Split(new char[] { ',' });
  563. AddSysLog(Id, "WithdrawRecord", "Cancel");
  564. foreach (string subid in idlist)
  565. {
  566. int id = int.Parse(subid);
  567. UserCashRecord edit = opdb.UserCashRecord.FirstOrDefault(m => m.Id == id);
  568. if (edit != null)
  569. {
  570. edit.QueryCount = 0;
  571. opdb.SaveChanges();
  572. }
  573. }
  574. return "success";
  575. }
  576. #endregion
  577. }
  578. }