BaseController.cs 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Configuration;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Text.RegularExpressions;
  7. using System.Web;
  8. using Microsoft.AspNetCore.Mvc;
  9. using Microsoft.AspNetCore.Http;
  10. using Microsoft.Extensions.Logging;
  11. using Microsoft.Extensions.Options;
  12. using MySystem.BsModels;
  13. using Library;
  14. namespace MySystem.Areas.Admin.Controllers
  15. {
  16. public class BaseController : Controller
  17. {
  18. public IHttpContextAccessor _accessor;
  19. public readonly ILogger<BaseController> _logger;
  20. public readonly IOptions<Setting> _setting;
  21. public Setting AppSetting;
  22. public string ApiKey = "G6H7@J8%";
  23. public Models.WebCMSEntities db = new Models.WebCMSEntities();
  24. public BsModels.WebCMSEntities bsdb = new BsModels.WebCMSEntities();
  25. public SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  26. public CashModels.WebCMSEntities cashdb = new CashModels.WebCMSEntities();
  27. public string Host = Library.ConfigurationManager.AppSettings["Host"].ToString();
  28. public string ShareHost = "";
  29. public string SourceHost = OssHelper.Instance.SourceHost;
  30. public string Database = Library.ConfigurationManager.AppSettings["Database"].ToString();
  31. public string defaultImage = Library.ConfigurationManager.AppSettings["Host"].ToString() + "/skin/app/default/static/images/default.jpg";
  32. //jwt参数
  33. public string JwtSecret = Library.ConfigurationManager.AppSettings["JwtSecret"].ToString();
  34. public string JwtIss = Library.ConfigurationManager.AppSettings["JwtIss"].ToString();
  35. public string JwtAud = Library.ConfigurationManager.AppSettings["JwtAud"].ToString();
  36. public int SysId;
  37. public int SysRealRole;
  38. public string SysUserName = "";
  39. public string SysRealName = "";
  40. public string RightInfo = "";
  41. public BaseController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting)
  42. {
  43. _accessor = accessor;
  44. _logger = logger;
  45. _setting = setting;
  46. AppSetting = setting.Value;
  47. Host = AppSetting.Host;
  48. Database = AppSetting.Database;
  49. if (function.GetSession(_accessor.HttpContext, "IsLogin") != "1")
  50. {
  51. function.WriteCookie(_accessor.HttpContext, "SysUserName", "");
  52. function.WriteCookie(_accessor.HttpContext, "SysRealName", "");
  53. function.WriteCookie(_accessor.HttpContext, "SysId", "0");
  54. function.WriteCookie(_accessor.HttpContext, "SysRealRole", "0");
  55. function.WriteSession(_accessor.HttpContext, "RightInfo", "");
  56. if (_accessor.HttpContext.Request.Path.Value.ToLower().Contains("admin"))
  57. {
  58. _accessor.HttpContext.Response.WriteAsync("<script>window.top.location.href='/Admin/Home/Login';</script>");
  59. }
  60. }
  61. else
  62. {
  63. SysId = int.Parse(function.CheckInt(function.GetCookie(_accessor.HttpContext, "SysId")));
  64. SysRealRole = int.Parse(function.CheckInt(function.GetCookie(_accessor.HttpContext, "SysRealRole")));
  65. SysUserName = function.GetCookie(_accessor.HttpContext, "SysUserName");
  66. SysRealName = function.GetCookie(_accessor.HttpContext, "SysRealName");
  67. SysAdminRole role = bsdb.SysAdminRole.FirstOrDefault(m => m.Id == SysRealRole);
  68. if (role != null)
  69. {
  70. RightInfo = role.RightInfo;
  71. function.WriteSession(_accessor.HttpContext, "RightInfo", role.RightInfo);
  72. }
  73. if (_accessor.HttpContext.Request.Path.Value.ToLower().Contains("admin"))
  74. {
  75. if (!CheckAdminRight())
  76. {
  77. _accessor.HttpContext.Response.WriteAsync("<script>window.top.location.href='/Admin/Home/Login';</script>");
  78. }
  79. }
  80. }
  81. //bsdb.Configuration.ProxyCreationEnabled = false;
  82. }
  83. #region 判断权限
  84. public bool CheckAdminRight()
  85. {
  86. string url = _accessor.HttpContext.Request.Path.Value;
  87. if(url.Contains("/RightDic/")) return true;
  88. if(url.Contains("/OperateRightList/")) return true;
  89. if(url.Contains("/PageUpdateInfo/")) return true;
  90. if(url.Contains("/FileUpdateInfo/")) return true;
  91. if(url.Contains("/AppBottomNavs/")) return true;
  92. if(url.Contains("/UploadParams/")) return true;
  93. if(url.Contains("/SystemSet/")) return true;
  94. if(url.Contains("Task")) return true;
  95. if(url.Contains("ProfitObject")) return true;
  96. if(url.Contains("ExportTable")) return true;
  97. if (url.Contains("/KqProductBrand/"))
  98. {
  99. url = url.Replace("/KqProductBrand/", "/KqProducts/");
  100. }
  101. if (url.Contains("/KqProductOrgs/"))
  102. {
  103. url = url.Replace("/KqProductOrgs/", "/KqProducts/");
  104. }
  105. if (url.Contains("/KqProductRuleSet/"))
  106. {
  107. url = url.Replace("/KqProductRuleSet/", "/KqProducts/");
  108. }
  109. if (url.Contains("/UserProfit/"))
  110. {
  111. url = url.Replace("/UserProfit/", "/Users/");
  112. }
  113. if (url.Contains("/Product"))
  114. {
  115. url = "/Admin/Products/Index";
  116. }
  117. if (url.Contains("/MerchantAddInfo/"))
  118. {
  119. url = url.Replace("/MerchantAddInfo/", "/MerchantInfo/");
  120. }
  121. if (url.Contains("/MerchantParamSet/"))
  122. {
  123. url = url.Replace("/MerchantParamSet/", "/MerchantInfo/");
  124. }
  125. if (url.Contains("/PosCouponRecord/"))
  126. {
  127. url = url.Replace("/PosCouponRecord/", "/PosCouponOrders/");
  128. }
  129. if (!string.IsNullOrEmpty(url))
  130. {
  131. url = url.Substring(0, url.LastIndexOf("/"));
  132. }
  133. string[] RightInfo = function.GetSession(_accessor.HttpContext, "RightInfo").Split(',');
  134. bool check = bsdb.RightDic.Any(m => m.Url.Contains(url) && RightInfo.Contains(m.Id));
  135. return check;
  136. }
  137. #endregion
  138. #region 根据数字获取订单状态名称
  139. public string getOrderStatus(int status)
  140. {
  141. string result = "";
  142. switch (status)
  143. {
  144. case -1:
  145. result = "已取消";
  146. break;
  147. case 0:
  148. result = "未付款";
  149. break;
  150. case 1:
  151. result = "待发货";
  152. break;
  153. case 2:
  154. result = "待确认";
  155. break;
  156. case 3:
  157. result = "已完成";
  158. break;
  159. case 4:
  160. result = "已评价";
  161. break;
  162. case 5:
  163. result = "退款中";
  164. break;
  165. case 6:
  166. result = "已退款";
  167. break;
  168. default: break;
  169. }
  170. return result;
  171. }
  172. #endregion
  173. #region 根据数字获取报名状态名称
  174. public string getSignUpStatus(int status)
  175. {
  176. string result = "";
  177. switch (status)
  178. {
  179. case -1:
  180. result = "已取消";
  181. break;
  182. case 0:
  183. result = "未付款";
  184. break;
  185. case 1:
  186. result = "已付款";
  187. break;
  188. default: break;
  189. }
  190. return result;
  191. }
  192. #endregion
  193. #region 根据数字获取创客等级名称
  194. public string getUserLevel(int level)
  195. {
  196. string result = "";
  197. // UserLevelSet set = bsdb.UserLevelSet.FirstOrDefault(m => m.Id == level);
  198. // if (set != null)
  199. // {
  200. // result = set.Name;
  201. // }
  202. return result;
  203. }
  204. #endregion
  205. #region 根据数字获取配送方式
  206. public string getMeterMode(int num)
  207. {
  208. string result = "";
  209. switch (num)
  210. {
  211. case 1:
  212. result = "快递";
  213. break;
  214. case 2:
  215. result = "EMS";
  216. break;
  217. case 3:
  218. result = "平邮";
  219. break;
  220. default:
  221. break;
  222. }
  223. return result;
  224. }
  225. #endregion
  226. #region 根据数字获取文章显示类型
  227. public string getShowTypeName(int ShowType)
  228. {
  229. string result = "";
  230. switch (ShowType)
  231. {
  232. case 2:
  233. result = "专题";
  234. break;
  235. case 3:
  236. result = "图文(大)";
  237. break;
  238. case 4:
  239. result = "文本";
  240. break;
  241. case 5:
  242. result = "图集";
  243. break;
  244. case 6:
  245. result = "直播";
  246. break;
  247. case 7:
  248. result = "视频";
  249. break;
  250. case 8:
  251. result = "音频";
  252. break;
  253. case 9:
  254. result = "图文(小)";
  255. break;
  256. default: break;
  257. }
  258. return result;
  259. }
  260. #endregion
  261. #region 获取文章内链
  262. public string getLocalUrl(int ShowType, int Id)
  263. {
  264. string result = "";
  265. switch (ShowType)
  266. {
  267. case 2:
  268. result = "subject?ArticleId=" + Id;
  269. break;
  270. case 5:
  271. result = "atlas-detail?ArticleId=" + Id;
  272. break;
  273. case 6:
  274. result = "live-detail?ArticleId=" + Id;
  275. break;
  276. case 7:
  277. result = "video-detail?ArticleId=" + Id;
  278. break;
  279. default:
  280. result = "article-detail?ArticleId=" + Id;
  281. break;
  282. }
  283. return result;
  284. }
  285. #endregion
  286. #region 获取文章内链
  287. public string getSchemeUrl(int ShowType, int Id)
  288. {
  289. string result = "";
  290. switch (ShowType)
  291. {
  292. case 2:
  293. result = "安卓:ggsj://com.ggsj.ggsj?id=subject?ArticleId=" + Id;
  294. result += "<br>IOS:ggsj://?id=subject?ArticleId=" + Id;
  295. break;
  296. case 5:
  297. result = "安卓:ggsj://com.ggsj.ggsj?id=atlas-detail?ArticleId=" + Id;
  298. result += "<br>IOS:ggsj://?id=atlas-detail?ArticleId=" + Id;
  299. break;
  300. case 6:
  301. result = "安卓:ggsj://com.ggsj.ggsj?id=live-detail?ArticleId=" + Id;
  302. result += "<br>IOS:ggsj://?id=live-detail?ArticleId=" + Id;
  303. break;
  304. case 7:
  305. result = "安卓:ggsj://com.ggsj.ggsj?id=video-detail?ArticleId=" + Id;
  306. result += "<br>IOS:ggsj://?id=video-detail?ArticleId=" + Id;
  307. break;
  308. default:
  309. result = "安卓:ggsj://com.ggsj.ggsj?id=article-detail?ArticleId=" + Id;
  310. result += "<br>IOS:ggsj://?id=article-detail?ArticleId=" + Id;
  311. break;
  312. }
  313. return result;
  314. }
  315. #endregion
  316. #region 两点距离
  317. public double GetDistanceNumber(string start, string end)
  318. {
  319. if (!string.IsNullOrEmpty(start) && !string.IsNullOrEmpty(end))
  320. {
  321. string[] startpos = start.Split(',');
  322. string[] endpos = end.Split(',');
  323. double lng1 = double.Parse(startpos[0]);
  324. double lat1 = double.Parse(startpos[1]);
  325. double lng2 = double.Parse(endpos[0]);
  326. double lat2 = double.Parse(endpos[1]);
  327. double radLat1 = rad(lat1);
  328. double radLat2 = rad(lat2);
  329. double a = radLat1 - radLat2;
  330. double b = rad(lng1) - rad(lng2);
  331. double s = 2 * Math.Asin(Math.Sqrt(Math.Pow(Math.Sin(a / 2), 2) + Math.Cos(radLat1) * Math.Cos(radLat2) * Math.Pow(Math.Sin(b / 2), 2)));
  332. s = s * EARTH_RADIUS;
  333. s = Math.Round(s * 10000) / 10000;
  334. return s;
  335. }
  336. return 10000000;
  337. }
  338. private double rad(double d)
  339. {
  340. return d * Math.PI / 180.0;
  341. }
  342. private double EARTH_RADIUS = 6378.137;
  343. #endregion
  344. #region 记录后台操作日志
  345. public void AddSysLog(string Id, string Table, string Operation)
  346. {
  347. if (!string.IsNullOrEmpty(Id))
  348. {
  349. string[] idlist = Id.Split(new char[] { ',' });
  350. foreach (string subid in idlist)
  351. {
  352. bsdb.SysLog.Add(new BsModels.SysLog()
  353. {
  354. CreateDate = DateTime.Now,
  355. CreateMan = SysUserName,
  356. Contents = SysUserName + "," + Operation + "," + "了" + Table + ",Id:" + subid,
  357. });
  358. }
  359. bsdb.SaveChanges();
  360. }
  361. }
  362. public void AddSysLog(int Id, string Table, string Operation)
  363. {
  364. bsdb.SysLog.Add(new BsModels.SysLog()
  365. {
  366. CreateDate = DateTime.Now,
  367. CreateMan = SysUserName,
  368. Contents = SysUserName + "," + Operation + "," + "了" + Table + ",Id:" + Id,
  369. });
  370. bsdb.SaveChanges();
  371. }
  372. #endregion
  373. #region 接口通用DES解密
  374. public string DesDecrypt(string content)
  375. {
  376. content = HttpUtility.UrlDecode(content);
  377. return dbconn.DesDecrypt(content, "*ga34|^7");
  378. }
  379. #endregion
  380. }
  381. }