BaseController.cs 15 KB

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