SysAdminOperateController.cs 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688
  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.OpModels;
  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 SysAdminOperateController : BaseController
  23. {
  24. public SysAdminOperateController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
  25. {
  26. OtherMySqlConn.connstr = ConfigurationManager.AppSettings["OpSqlConnStr"].ToString();
  27. }
  28. #region 运营中心列表
  29. /// <summary>
  30. /// 根据条件查询运营中心列表
  31. /// </summary>
  32. /// <returns></returns>
  33. public IActionResult Index(SysAdmin data, string right)
  34. {
  35. ViewBag.RightInfo = RightInfo;
  36. ViewBag.right = right;
  37. string Condition = "";
  38. Condition += "AdminName:\"" + data.AdminName + "\",";
  39. Condition += "RealName:\"" + data.RealName + "\",";
  40. Condition += "Role:\"" + data.Role + "\",";
  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(SysAdmin data, string OpCode, string RealName, string CreateDateData, int page = 1, int limit = 30)
  56. {
  57. Dictionary<string, string> Fields = new Dictionary<string, string>();
  58. Fields.Add("RealName", "2"); //名称
  59. string condition = " and Status>-1 and Sort>0 and QueryCount>0 and AdminName!='admin'";
  60. //运营中心编号
  61. if (!string.IsNullOrEmpty(OpCode))
  62. {
  63. condition += " and Id in (select OpId from OperateForCode where OpCode='" + OpCode + "')";
  64. }
  65. // //运营中心名称
  66. // if (!string.IsNullOrEmpty(RealName))
  67. // {
  68. // condition += " and UserId in (select UserId from UserForRealName where RealName='" + RealName + "')";
  69. // }
  70. //创建时间
  71. if (!string.IsNullOrEmpty(CreateDateData))
  72. {
  73. string[] datelist = CreateDateData.Split(new string[] { " - " }, StringSplitOptions.None);
  74. string start = datelist[0];
  75. string end = datelist[1];
  76. condition += " and CreateDate>='" + start + " 00:00:00' and CreateDate<='" + end + " 23:59:59'";
  77. }
  78. Dictionary<string, object> obj = new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).IndexData("SysAdmin", Fields, "Id desc", "0", page, limit, condition);
  79. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  80. foreach (Dictionary<string, object> dic in diclist)
  81. {
  82. //所属人信息
  83. int Id = int.Parse(dic["Id"].ToString());
  84. SysAdmin sysAdmin = opdb.SysAdmin.FirstOrDefault(m => m.Id == Id) ?? new SysAdmin();
  85. dic["MakerCode"] = sysAdmin.MakerCode;
  86. dic["MakerName"] = sysAdmin.MakerName;
  87. //登陆地址
  88. dic["LoginUrl"] = OpHost + "/Admin/" + dbconn.Encrypt3DES(sysAdmin.Sort.ToString(), "kxs12345") + "/Login";
  89. //未使用用额度
  90. UserAccount userAccount = opdb.UserAccount.FirstOrDefault(m => m.Sort == Id) ?? new UserAccount();
  91. dic["TotalAmt"] = userAccount.TotalAmt;
  92. //可提现额度
  93. dic["ValidForGetAmount"] = userAccount.ValidForGetAmount;
  94. //关联分仓额度
  95. dic["ValidAmount"] = userAccount.ValidAmount;
  96. //已提现金额
  97. dic["WithdrawAmount"] = userAccount.WithdrawAmount;
  98. //提现中金额
  99. dic["WithdrawingAmount"] = userAccount.WithdrawingAmount;
  100. //分仓数量 StoreForOperate
  101. // dic["StoreCount"] = opdb.StoreForOperate.Where(m => m.OpId == Id).Count();
  102. }
  103. return Json(obj);
  104. }
  105. #endregion
  106. #region 增加运营中心
  107. /// <summary>
  108. /// 增加或修改运营中心信息
  109. /// </summary>
  110. /// <returns></returns>
  111. public IActionResult Add(string right)
  112. {
  113. ViewBag.RightInfo = RightInfo;
  114. ViewBag.right = right;
  115. return View();
  116. }
  117. #endregion
  118. #region 增加运营中心
  119. /// <summary>
  120. /// 增加或修改运营中心信息
  121. /// </summary>
  122. /// <returns></returns>
  123. [HttpPost]
  124. public string Add(SysAdmin data, UserAccount userAccount, string Areas, string Address)
  125. {
  126. Dictionary<string, object> Fields = new Dictionary<string, object>();
  127. Dictionary<string, object> Field = new Dictionary<string, object>();
  128. // Models.WebCMSEntities db = new Models.WebCMSEntities();
  129. var userForMakerCode = db.UserForMakerCode.FirstOrDefault(m => m.MakerCode == data.MakerCode) ?? new Models.UserForMakerCode();
  130. if (userForMakerCode.UserId > 0)
  131. {
  132. var userInfo = db.Users.FirstOrDefault(m => m.Id == userForMakerCode.UserId && m.Mobile == data.MakerMobile) ?? new Models.Users();
  133. if (userInfo.Id > 0)
  134. {
  135. var check = opdb.SysAdmin.Any(m => m.AdminName == data.AdminName);
  136. var checks = opdb.SysAdmin.Any(m => m.UserId == userInfo.Id);
  137. if (check)
  138. {
  139. return "该用户名已存在,请重新输入";
  140. }
  141. if (checks)
  142. {
  143. return "该用户已存在运营中心,请重新输入";
  144. }
  145. Fields.Add("CreateMan", SysUserName + "_" + SysRealName); //创建人
  146. Fields.Add("RealName", data.RealName); //运营中心名称
  147. Fields.Add("MakerCode", data.MakerCode); //创客编号
  148. Fields.Add("MakerMobile", data.MakerMobile); //手机号
  149. Fields.Add("UserId", userInfo.Id); //创客Id
  150. Fields.Add("MakerName", userInfo.RealName); //创客真实姓名
  151. Fields.Add("AdminName", data.AdminName); //用户名
  152. Fields.Add("Password", function.MD5_32(data.Password)); //密码
  153. Fields.Add("FilePath", data.FilePath); //附件
  154. Fields.Add("QueryCount", 1); //是否为主账号(1是,0否)
  155. int Id = new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Add("SysAdmin", Fields, 0);
  156. SysAdmin edit = opdb.SysAdmin.FirstOrDefault(m => m.Id == Id);
  157. if (edit != null)
  158. {
  159. string No = Id.ToString();
  160. for (int i = 0; i < 7 - Id.ToString().Length; i++)
  161. {
  162. No = "0" + No;
  163. }
  164. No = "YZ" + No;
  165. edit.OpCode = No;
  166. edit.Sort = Id;
  167. AddSysLog(data.Id.ToString(), "SysAdmin", "add");
  168. var query = opdb.OperateForCode.Add(new OperateForCode()
  169. {
  170. OpCode = No,
  171. OpId = Id,
  172. }).Entity;
  173. opdb.SaveChanges();
  174. }
  175. var info = opdb.SysAdmin.FirstOrDefault(m => m.Id == Id);
  176. if (info != null)
  177. {
  178. Field.Add("TotalAmt", userAccount.TotalAmt); //初始额度
  179. // Field.Add("ValidAmount", userAccount.TotalAmt); //可用额度
  180. Field.Add("Sort", Id); //运营中心Id
  181. Field.Add("Id", edit.UserId); //创客Id
  182. Field.Add("UserId", edit.UserId); //创客Id
  183. int Ids = new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Add("UserAccount", Field, 0);
  184. AddSysLog(userAccount.Id.ToString(), "UserAccount", "add");
  185. var query = opdb.SysAdminRole.Add(new SysAdminRole()
  186. {
  187. CreateDate = DateTime.Now, //创建时间
  188. Sort = edit.Id,//所属运营中心
  189. CreateMan = SysUserName + "_" + SysRealName,
  190. Details = "运营中心管理员,可以操作运营中心所有权限",
  191. RightInfo = ",1_1,1_1_1,1_1_1_edit,1_2,1_2_1,1_2_1_export,1_2_2,1_3,1_3_1,1_3_1_import,1_4,1_4_1,1_4_1_add,1_4_2,1_4_2_add,1_4_3,1_4_3_edit,1_4_3_base,1_4_3_audit,1_6,1_6_1,1_6_1_add,1_6_1_delete,1_6_1_edit,1_6_2,1_6_2_add,1_6_2_delete,1_6_2_edit,",
  192. Name = "运营中心管理员",
  193. }).Entity;
  194. opdb.SaveChanges();
  195. var role = opdb.SysAdminRole.FirstOrDefault(m => m.Sort == edit.Id);
  196. if (role != null)
  197. {
  198. edit.Role = role.Id.ToString();
  199. opdb.SaveChanges();
  200. }
  201. }
  202. userInfo.UserType = 1;//设置创客为运营中心
  203. db.SaveChanges();
  204. var kqProduct = db.KqProducts.ToList();
  205. foreach (var item in kqProduct)
  206. {
  207. string Nos = "YC000" + item.Id + info.Id;
  208. var query = db.StoreHouse.Add(new Models.StoreHouse()
  209. {
  210. CreateDate = DateTime.Now, //创建时间
  211. CreateMan = SysUserName + "_" + SysRealName,
  212. ManageMobile = data.MakerMobile, //手机号
  213. UserId = info.UserId, //运营中心创客Id
  214. OpId = info.UserId, //运营中心创客Id
  215. Address = Address,//仓库地址
  216. Areas = Areas,//所属地区
  217. ManageUserId = info.UserId,//仓库管理员
  218. StoreName = item.Name + "运营分仓", //仓库名称
  219. StoreNo = Nos, //仓库编号
  220. Sort = info.Id,//运营中心Id
  221. Status = 1,
  222. BrandId = item.Id.ToString(),
  223. StoreKind = 2,//运营仓
  224. }).Entity;
  225. db.SaveChanges();
  226. var querys = opdb.StoreForOperate.Add(new OpModels.StoreForOperate()
  227. {
  228. CreateDate = DateTime.Now, //创建时间
  229. CreateMan = SysUserName + "_" + SysRealName,
  230. Sort = info.UserId,
  231. OpId = info.UserId,
  232. StoreId = query.Id,
  233. SeoKeyword = query.StoreNo,
  234. SeoDescription = query.StoreName,
  235. }).Entity;
  236. opdb.SaveChanges();
  237. }
  238. }
  239. else
  240. {
  241. return "创客编号和手机号不匹配";
  242. }
  243. }
  244. return "success";
  245. }
  246. #endregion
  247. #region 修改运营中心
  248. /// <summary>
  249. /// 增加或修改运营中心信息
  250. /// </summary>
  251. /// <returns></returns>
  252. public IActionResult Edit(string right, int Id = 0)
  253. {
  254. ViewBag.RightInfo = RightInfo;
  255. ViewBag.right = right;
  256. SysAdmin editData = opdb.SysAdmin.FirstOrDefault(m => m.Id == Id) ?? new SysAdmin();
  257. UserAccount editDatas = opdb.UserAccount.FirstOrDefault(m => m.Sort == Id) ?? new UserAccount();
  258. ViewBag.data = editData;
  259. ViewBag.datas = editDatas;
  260. return View();
  261. }
  262. #endregion
  263. #region 修改运营中心
  264. /// <summary>
  265. /// 增加或修改运营中心信息
  266. /// </summary>
  267. /// <returns></returns>
  268. [HttpPost]
  269. public string Edit(SysAdmin data, UserAccount userAccount, string Areas, string Address)
  270. {
  271. Dictionary<string, object> Fields = new Dictionary<string, object>();
  272. Fields.Add("UpdateMan", SysUserName + "_" + SysRealName); //修改人
  273. Fields.Add("RealName", data.RealName); //运营中心名称
  274. Fields.Add("FilePath", data.FilePath); //附件
  275. Fields.Add("AdminName", data.AdminName); //用户名
  276. if (!string.IsNullOrEmpty(data.Password)) //密码不为空就修改密码,否则不操作
  277. {
  278. var sys = opdb.SysAdmin.FirstOrDefault(m => m.Id == data.Id);
  279. if (data.Password != sys.Password)
  280. {
  281. Fields.Add("Password", function.MD5_32(data.Password)); //密码
  282. }
  283. }
  284. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("SysAdmin", Fields, data.Id);
  285. SysAdmin edit = opdb.SysAdmin.FirstOrDefault(m => m.Id == data.Id);
  286. edit.CreateDate = edit.CreateDate;
  287. AddSysLog(data.Id.ToString(), "SysAdmin", "update");
  288. db.SaveChanges();
  289. return "success";
  290. }
  291. #endregion
  292. #region 删除运营中心信息
  293. /// <summary>
  294. /// 删除运营中心信息
  295. /// </summary>
  296. /// <returns></returns>
  297. public string Delete(string Id)
  298. {
  299. string[] idlist = Id.Split(new char[] { ',' });
  300. AddSysLog(Id, "SysAdmin", "del");
  301. foreach (string subid in idlist)
  302. {
  303. int id = int.Parse(subid);
  304. var sysAdmin = opdb.SysAdmin.FirstOrDefault(m => m.Id == id) ?? new OpModels.SysAdmin();
  305. if (sysAdmin.Id > 0)
  306. {
  307. var userAccount = opdb.UserAccount.FirstOrDefault(m => m.Status > -1 && m.Sort == id && m.UserId == sysAdmin.UserId) ?? new OpModels.UserAccount();
  308. if (userAccount.Id > 0)
  309. {
  310. userAccount.Status = -1;
  311. }
  312. var operateForCode = opdb.OperateForCode.FirstOrDefault(m => m.OpId == id) ?? new OpModels.OperateForCode();
  313. if (operateForCode.OpId > 0)
  314. {
  315. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Delete("UserAccount", operateForCode.OpId);
  316. }
  317. //修改运营中心仓
  318. var storeHouse = db.StoreHouse.Where(m => m.Sort == id && m.Status == 1 && m.UserId == sysAdmin.UserId && m.OpId == sysAdmin.UserId).ToList();
  319. foreach (var item in storeHouse)
  320. {
  321. var list = storeHouse.FirstOrDefault(m => m.Id == item.Id) ?? new Models.StoreHouse();
  322. if (list.Id > 0)
  323. {
  324. list.Status = -1;
  325. list.UpdateDate = DateTime.Now;
  326. list.UpdateMan = SysUserName + "-" + SysRealName;
  327. db.SaveChanges();
  328. }
  329. }
  330. //修改运营中心关联分仓
  331. var storeHouses = db.StoreHouse.Where(m => m.Sort == id && m.Status == 1).ToList();
  332. foreach (var item in storeHouses)
  333. {
  334. var list = storeHouses.FirstOrDefault(m => m.Id == item.Id) ?? new Models.StoreHouse();
  335. if (list.Id > 0)
  336. {
  337. list.Sort = 0;
  338. list.OpId = 0;
  339. list.UpdateDate = DateTime.Now;
  340. list.UpdateMan = SysUserName + "-" + SysRealName;
  341. db.SaveChanges();
  342. }
  343. }
  344. //修改关联运营中心仓
  345. var storeForOperate = opdb.StoreForOperate.Where(m => m.Status == 0 && m.OpId == sysAdmin.UserId && m.Sort == sysAdmin.UserId && m.QueryCount == 0).ToList();
  346. foreach (var items in storeForOperate)
  347. {
  348. var lists = storeForOperate.FirstOrDefault(m => m.Id == items.Id) ?? new OpModels.StoreForOperate();
  349. if (lists.Id > 0)
  350. {
  351. lists.Status = -1;
  352. lists.UpdateDate = DateTime.Now;
  353. lists.UpdateMan = SysUserName + "-" + SysRealName;
  354. opdb.SaveChanges();
  355. }
  356. }
  357. //修改运营中心关联分仓
  358. var storeForOperates = opdb.StoreForOperate.Where(m => m.Status == 0 && m.OpId == sysAdmin.UserId && m.Sort == 0 && m.QueryCount == sysAdmin.UserId).ToList();
  359. foreach (var items in storeForOperates)
  360. {
  361. var lists = storeForOperates.FirstOrDefault(m => m.Id == items.Id) ?? new OpModels.StoreForOperate();
  362. if (lists.Id > 0)
  363. {
  364. lists.Status = -1;
  365. lists.UpdateDate = DateTime.Now;
  366. lists.UpdateMan = SysUserName + "-" + SysRealName;
  367. opdb.SaveChanges();
  368. }
  369. }
  370. opdb.SaveChanges();
  371. }
  372. Dictionary<string, object> Fields = new Dictionary<string, object>();
  373. Fields.Add("Status", -1);
  374. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("SysAdmin", Fields, id);
  375. }
  376. opdb.SaveChanges();
  377. return "success";
  378. }
  379. #endregion
  380. #region 开启
  381. /// <summary>
  382. /// 开启
  383. /// </summary>
  384. /// <returns></returns>
  385. public string Open(string Id)
  386. {
  387. string[] idlist = Id.Split(new char[] { ',' });
  388. AddSysLog(Id, "SysAdmin", "open");
  389. foreach (string subid in idlist)
  390. {
  391. int id = int.Parse(subid);
  392. Dictionary<string, object> Fields = new Dictionary<string, object>();
  393. Fields.Add("Status", 1);
  394. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("SysAdmin", Fields, id);
  395. }
  396. opdb.SaveChanges();
  397. return "success";
  398. }
  399. #endregion
  400. #region 关闭
  401. /// <summary>
  402. /// 关闭
  403. /// </summary>
  404. /// <returns></returns>
  405. public string Close(string Id)
  406. {
  407. string[] idlist = Id.Split(new char[] { ',' });
  408. AddSysLog(Id, "SysAdmin", "close");
  409. foreach (string subid in idlist)
  410. {
  411. int id = int.Parse(subid);
  412. Dictionary<string, object> Fields = new Dictionary<string, object>();
  413. Fields.Add("Status", 0);
  414. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Edit("SysAdmin", Fields, id);
  415. }
  416. opdb.SaveChanges();
  417. return "success";
  418. }
  419. #endregion
  420. #region 排序
  421. /// <summary>
  422. /// 排序
  423. /// </summary>
  424. /// <param name="Id"></param>
  425. public string Sort(int Id, int Sort)
  426. {
  427. new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).Sort("SysAdmin", Sort, Id);
  428. AddSysLog(Id.ToString(), "SysAdmin", "sort");
  429. return "success";
  430. }
  431. #endregion
  432. #region 导入数据
  433. /// <summary>
  434. /// 导入数据
  435. /// </summary>
  436. /// <param name="ExcelData"></param>
  437. public string Import(string ExcelData)
  438. {
  439. ExcelData = HttpUtility.UrlDecode(ExcelData);
  440. JsonData list = JsonMapper.ToObject(ExcelData);
  441. for (int i = 1; i < list.Count; i++)
  442. {
  443. JsonData dr = list[i];
  444. opdb.SysAdmin.Add(new SysAdmin()
  445. {
  446. CreateDate = DateTime.Now,
  447. UpdateDate = DateTime.Now,
  448. });
  449. opdb.SaveChanges();
  450. }
  451. AddSysLog("0", "SysAdmin", "Import");
  452. return "success";
  453. }
  454. #endregion
  455. #region 导出Excel
  456. /// <summary>
  457. /// 导出Excel
  458. /// </summary>
  459. /// <returns></returns>
  460. public JsonResult ExportExcel(SysAdmin data)
  461. {
  462. Dictionary<string, string> Fields = new Dictionary<string, string>();
  463. Fields.Add("AdminName", "2"); //用户名
  464. Fields.Add("RealName", "2"); //名称
  465. Fields.Add("Role", "1"); //角色
  466. Fields.Add("LastLoginDate", "3"); //最后登录时间
  467. Dictionary<string, object> obj = new AdminContentOther(_accessor.HttpContext, PublicFunction.OpTables).IndexData("SysAdmin", Fields, "Id desc", "0", 1, 20000, "", "", false);
  468. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  469. foreach (Dictionary<string, object> dic in diclist)
  470. {
  471. }
  472. Dictionary<string, object> result = new Dictionary<string, object>();
  473. result.Add("Status", "1");
  474. result.Add("Info", "Excel报表-" + DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss") + ".xlsx");
  475. result.Add("Obj", diclist);
  476. Dictionary<string, object> ReturnFields = new Dictionary<string, object>();
  477. result.Add("Fields", ReturnFields);
  478. AddSysLog("0", "SysAdmin", "ExportExcel");
  479. return Json(result);
  480. }
  481. #endregion
  482. #region 修改运营中心未使用额度
  483. public IActionResult EditAmt(string right, int Id = 0)
  484. {
  485. ViewBag.RightInfo = RightInfo;
  486. ViewBag.right = right;
  487. SysAdmin editData = opdb.SysAdmin.FirstOrDefault(m => m.Id == Id) ?? new SysAdmin();
  488. ViewBag.data = editData;
  489. return View();
  490. }
  491. #endregion
  492. #region 修改运营中心未使用额度
  493. [HttpPost]
  494. public string EditAmt(SysAdmin data, string OperationAmount, string Note, int Kind)
  495. {
  496. var sysAdmin = opdb.SysAdmin.FirstOrDefault(m => m.Id == data.Id);
  497. var account = opdb.UserAccount.FirstOrDefault(m => m.UserId == sysAdmin.UserId);
  498. decimal BeforeAmount = account.TotalAmt + account.ValidAmount + account.ValidForGetAmount; //变更前总金额
  499. //扣减
  500. if (Kind == 1 && decimal.Parse(OperationAmount) > account.TotalAmt)
  501. {
  502. return "未使用额度不足";
  503. }
  504. int OperateType = 0;
  505. var description = "";
  506. if (Kind == 1 && decimal.Parse(OperationAmount) <= account.TotalAmt)
  507. {
  508. account.TotalAmt -= decimal.Parse(OperationAmount);
  509. OperateType = 2;//系统扣减
  510. description ="系统扣减";
  511. }
  512. else if (Kind == 1 && decimal.Parse(OperationAmount) > account.TotalAmt)
  513. {
  514. return "扣减金额大于未使用额度";
  515. }
  516. //增加
  517. else if (Kind == 2)
  518. {
  519. account.TotalAmt += decimal.Parse(OperationAmount);
  520. OperateType = 1;//系统增加
  521. description ="系统增加";
  522. }
  523. decimal AfterAmount = account.TotalAmt + account.ValidAmount + account.ValidForGetAmount; //变更后总金额
  524. AmountRecord amountRecord = opdb.AmountRecord.Add(new AmountRecord()
  525. {
  526. CreateDate = DateTime.Now,
  527. SeoDescription = description,
  528. UserId = sysAdmin.UserId, //运营中心Id
  529. CreateMan = SysUserName + "-" + SysRealName,
  530. UseAmount = decimal.Parse(OperationAmount),//操作金额
  531. BeforeAmount = BeforeAmount,//使用前剩余额度
  532. AfterAmount = AfterAmount,//使用后剩余额度
  533. OperateType = OperateType,//操作类别
  534. }).Entity;
  535. opdb.SaveChanges();
  536. AddSysLog(data.Id.ToString(), "SysAdmin", "EditAmt");
  537. opdb.SaveChanges();
  538. return "success";
  539. }
  540. #endregion
  541. #region 修改运营中心可提现额度
  542. public IActionResult EditBalance(string right, int Id = 0)
  543. {
  544. ViewBag.RightInfo = RightInfo;
  545. ViewBag.right = right;
  546. SysAdmin editData = opdb.SysAdmin.FirstOrDefault(m => m.Id == Id) ?? new SysAdmin();
  547. ViewBag.data = editData;
  548. return View();
  549. }
  550. #endregion
  551. #region 修改运营中心可提现额度
  552. [HttpPost]
  553. public string EditBalance(SysAdmin data, string OperationAmount, string Note, int Kind)
  554. {
  555. var sysAdmin = opdb.SysAdmin.FirstOrDefault(m => m.Id == data.Id);
  556. var account = opdb.UserAccount.FirstOrDefault(m => m.UserId == sysAdmin.UserId);
  557. if ((Kind == 1) && decimal.Parse(OperationAmount) > account.ValidForGetAmount)
  558. {
  559. return "账号余额不足";
  560. }
  561. decimal BeforeAmount = account.TotalAmt + account.ValidAmount + account.ValidForGetAmount; //变更前总金额
  562. int OperateType = 0;
  563. var description = "";
  564. if (Kind == 1 && decimal.Parse(OperationAmount) <= account.ValidForGetAmount)
  565. {
  566. account.ValidForGetAmount -= decimal.Parse(OperationAmount);
  567. OperateType = 2;
  568. description ="系统扣减";
  569. }
  570. else if (Kind == 1 && decimal.Parse(OperationAmount) > account.ValidForGetAmount)
  571. {
  572. return "扣减金额大于可提现额度";
  573. }
  574. else if (Kind == 2)
  575. {
  576. account.ValidForGetAmount += decimal.Parse(OperationAmount);
  577. OperateType = 1;
  578. description ="系统增加";
  579. }
  580. decimal AfterAmount = account.TotalAmt + account.ValidAmount + account.ValidForGetAmount; //变更后总金额
  581. AmountRecord amountRecord = opdb.AmountRecord.Add(new AmountRecord()
  582. {
  583. CreateDate = DateTime.Now,
  584. SeoDescription = description,
  585. UserId = sysAdmin.UserId, //运营中心Id
  586. CreateMan = SysUserName + "-" + SysRealName,
  587. UseAmount = decimal.Parse(OperationAmount),//操作金额
  588. BeforeAmount = BeforeAmount,//使用前剩余额度
  589. AfterAmount = AfterAmount,//使用后剩余额度
  590. OperateType = OperateType,//操作类别
  591. }).Entity;
  592. opdb.SaveChanges();
  593. AddSysLog(data.Id.ToString(), "SysAdmin", "EditBalance");
  594. opdb.SaveChanges();
  595. return "success";
  596. }
  597. #endregion
  598. }
  599. }