SysAdminOperateController.cs 30 KB

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