SysAdminOperateController.cs 31 KB

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