MerchantInfoController.cs 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Data;
  5. using Microsoft.AspNetCore.Mvc;
  6. using Microsoft.AspNetCore.Http;
  7. using Microsoft.Extensions.Logging;
  8. using Microsoft.Extensions.Options;
  9. using Microsoft.AspNetCore.Authorization;
  10. using LitJson;
  11. using Library;
  12. using MySystem.Service.Main;
  13. using MySystem.Models.Main;
  14. using System.Text;
  15. namespace MySystem.Areas.Api.Controllers.v1
  16. {
  17. [Area("Api")]
  18. [Route("Api/v1/[controller]/[action]")]
  19. public class MerchantInfoController : BaseController
  20. {
  21. public MerchantInfoController(IHttpContextAccessor accessor) : base(accessor)
  22. {
  23. }
  24. #region 创客-首页-进件查询
  25. // [Authorize]
  26. public JsonResult MerchantByStatus(string value)
  27. {
  28. value = DesDecrypt(value);
  29. JsonData data = JsonMapper.ToObject(value);
  30. List<Dictionary<string, object>> dataList = MerchantByStatusDo(value);
  31. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
  32. }
  33. public List<Dictionary<string, object>> MerchantByStatusDo(string value)
  34. {
  35. JsonData data = JsonMapper.ToObject(value);
  36. string SearchKey = data["SearchKey"].ToString();
  37. int Status = int.Parse(function.CheckInt(data["Status"].ToString()));
  38. int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //所属创客
  39. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  40. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  41. StringBuilder condition = new StringBuilder();
  42. condition.Condition("UserId", UserId);
  43. condition.Condition("Sort", 1);
  44. if (Status > 0)
  45. {
  46. if (Status == 1) Status = 0;
  47. if (Status == 2) Status = -1;
  48. if (Status == 3) Status = 1;
  49. if (Status == 4) Status = 2;
  50. condition.Condition("Status", Status);
  51. }
  52. if (!string.IsNullOrEmpty(SearchKey))
  53. {
  54. condition.ConditionLike("Name", SearchKey);
  55. }
  56. List<Dictionary<string, object>> list = MerchantInfoService.List(new List<RelationData>(), condition.ToString(), PageNum, PageSize);
  57. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  58. foreach (Dictionary<string, object> subdata in list)
  59. {
  60. MerchantAddInfo AddInfo = MerchantAddInfoService.Query(int.Parse(subdata["Id"].ToString()));
  61. Dictionary<string, object> curData = new Dictionary<string, object>();
  62. curData.Add("Name", subdata["Name"]); //名称
  63. curData.Add("Id", subdata["Id"]); //Id
  64. curData.Add("CreateDate", subdata["CreateDate"]); //CreateDate
  65. curData.Add("Status", subdata["Status"]); //Status
  66. curData.Add("SubjectType", AddInfo.SubjectType); //主体类型
  67. dataList.Add(curData);
  68. }
  69. return dataList;
  70. }
  71. #endregion
  72. #region 创客-首页-进件查询-详情
  73. // [Authorize]
  74. public JsonResult MerchantDetailByStatus(string value)
  75. {
  76. value = DesDecrypt(value);
  77. JsonData data = JsonMapper.ToObject(value);
  78. Dictionary<string, object> Obj = MerchantDetailByStatusDo(value);
  79. return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
  80. }
  81. public Dictionary<string, object> MerchantDetailByStatusDo(string value)
  82. {
  83. JsonData data = JsonMapper.ToObject(value);
  84. Dictionary<string, object> Obj = new Dictionary<string, object>();
  85. int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
  86. MerchantInfo query = MerchantInfoService.Query(Id);
  87. MerchantAddInfo addInfo = MerchantAddInfoService.Query(Id);
  88. // Obj.Add("Name", query.Name); //名称
  89. // Obj.Add("CreateDate", query.CreateDate == null ? "" : query.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //提交时间
  90. // Obj.Add("Status", addInfo.Status);
  91. // Obj.Add("DoTime", addInfo.UpdateDate == null ? "" : addInfo.UpdateDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
  92. // Obj.Add("Season", addInfo.WeChatRemark);
  93. // Obj.Add("SignUrl", addInfo.WeChatSignUrl);
  94. // Obj.Add("SubjectType", addInfo.SubjectType);
  95. Obj.Add("Name", query.Name); //名称
  96. Obj.Add("CreateDate", query.CreateDate == null ? "" : query.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //提交时间
  97. List<Dictionary<string, object>> AuditResult = new List<Dictionary<string, object>>();
  98. Dictionary<string, object> WeChat = new Dictionary<string, object>();
  99. WeChat.Add("Name", "微信");
  100. WeChat.Add("Status", addInfo.Status);
  101. WeChat.Add("DoTime", addInfo.UpdateDate == null ? "" : addInfo.UpdateDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
  102. WeChat.Add("Season", addInfo.WeChatRemark);
  103. WeChat.Add("SignUrl", addInfo.WeChatSignUrl);
  104. AuditResult.Add(WeChat);
  105. if (addInfo.QueryCount == -1 || addInfo.QueryCount >= 1)
  106. {
  107. Dictionary<string, object> Alipay = new Dictionary<string, object>();
  108. Alipay.Add("Name", "支付宝");
  109. Alipay.Add("Status", addInfo.QueryCount);
  110. Alipay.Add("DoTime", addInfo.UpdateDate == null ? "" : addInfo.UpdateDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
  111. Alipay.Add("Season", addInfo.AlipayRemark);
  112. Alipay.Add("SignUrl", function.CheckNull(addInfo.AlipaySignUrl).Replace("\\", ""));
  113. AuditResult.Add(Alipay);
  114. }
  115. Obj.Add("Status", addInfo.Status);
  116. Obj.Add("AuditResult", AuditResult); //审核结果
  117. Obj.Add("SubjectType", addInfo.SubjectType);
  118. return Obj;
  119. }
  120. #endregion
  121. //new
  122. #region 首页-快联盟产品-我的业绩-团队业绩-商户列表
  123. // [Authorize]
  124. public JsonResult TeamPerformanceMerchants(string value)
  125. {
  126. value = DesDecrypt(value);
  127. JsonData data = JsonMapper.ToObject(value);
  128. List<Dictionary<string, object>> dataList = TeamPerformanceMerchantsDo(value);
  129. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
  130. }
  131. public List<Dictionary<string, object>> TeamPerformanceMerchantsDo(string value)
  132. {
  133. JsonData data = JsonMapper.ToObject(value);
  134. int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
  135. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  136. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  137. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  138. List<int> query = MerchantInfoDbconn.Instance.GetList(UserId, PageNum, PageSize);
  139. foreach (int id in query)
  140. {
  141. MerchantInfo subdata = MerchantInfoDbconn.Instance.Get(id) ?? new MerchantInfo();
  142. Dictionary<string, object> curData = new Dictionary<string, object>();
  143. curData.Add("MerchantName", subdata.Name); //商户姓名
  144. curData.Add("Id", subdata.Id); //Id
  145. dataList.Add(curData);
  146. }
  147. return dataList;
  148. }
  149. #endregion
  150. #region 创客-首页-商户签约
  151. // [Authorize]
  152. public JsonResult ContractList(string value)
  153. {
  154. value = DesDecrypt(value);
  155. JsonData data = JsonMapper.ToObject(value);
  156. List<Dictionary<string, object>> dataList = ContractListDo(value);
  157. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
  158. }
  159. public List<Dictionary<string, object>> ContractListDo(string value)
  160. {
  161. JsonData data = JsonMapper.ToObject(value);
  162. int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //所属创客
  163. string Status = data["Status"].ToString(); //签约状态
  164. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  165. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  166. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  167. List<int> query = MerchantInfoDbconn.Instance.GetList(UserId, PageNum, PageSize);
  168. foreach (var id in query)
  169. {
  170. MerchantInfo subdata = MerchantInfoDbconn.Instance.Get(id) ?? new MerchantInfo();
  171. Dictionary<string, object> curData = new Dictionary<string, object>();
  172. curData.Add("Name", subdata.Name); //名称
  173. curData.Add("Id", subdata.Id); //Id
  174. curData.Add("CreateDate", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //CreateDate
  175. curData.Add("Status", ""); //签约状态
  176. curData.Add("MainType", ""); //主体类型
  177. dataList.Add(curData);
  178. }
  179. return dataList;
  180. }
  181. #endregion
  182. #region 创客-首页-商户签约-详情
  183. // [Authorize]
  184. public JsonResult ContractDetail(string value)
  185. {
  186. value = DesDecrypt(value);
  187. JsonData data = JsonMapper.ToObject(value);
  188. Dictionary<string, object> Obj = ContractDetailDo(value);
  189. return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
  190. }
  191. public Dictionary<string, object> ContractDetailDo(string value)
  192. {
  193. JsonData data = JsonMapper.ToObject(value);
  194. Dictionary<string, object> Obj = new Dictionary<string, object>();
  195. MerchantInfo query = new MerchantInfo();
  196. int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
  197. query = MerchantInfoDbconn.Instance.Get(Id) ?? new MerchantInfo();
  198. Obj.Add("Name", query.Name); //名称
  199. Obj.Add("Status", ""); //签约状态
  200. Obj.Add("Platforms", ""); //品台列表
  201. Obj.Add("CreateDate", query.CreateDate); //创建时间
  202. return Obj;
  203. }
  204. #endregion
  205. #region 创客-首页-我的商户-商户列表
  206. // [Authorize]
  207. public JsonResult MyMerchant(string value)
  208. {
  209. value = DesDecrypt(value);
  210. JsonData data = JsonMapper.ToObject(value);
  211. Dictionary<string, object> Other = new Dictionary<string, object>();
  212. List<Dictionary<string, object>> dataList = MyMerchantDo(value, out Other);
  213. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other });
  214. }
  215. public List<Dictionary<string, object>> MyMerchantDo(string value, out Dictionary<string, object> Other)
  216. {
  217. JsonData data = JsonMapper.ToObject(value);
  218. string SearchKey = data["SearchKey"].ToString(); //搜索关键词
  219. int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
  220. int ActiveStatus = int.Parse(function.CheckInt(data["ActiveStatus"].ToString())); //商户激活状态
  221. int Kind = int.Parse(function.CheckInt(data["Kind"].ToString()));
  222. string TradeSort = data["TradeSort"].ToString(); //排序
  223. string DateSort = data["DateSort"].ToString(); //排序
  224. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  225. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  226. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  227. IQueryable<MerchantInfo> query = maindb.MerchantInfo.Where(m => m.UserId == UserId && (m.Status == 2 || m.QueryCount == 2));
  228. DateTime today = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00");
  229. if (!string.IsNullOrEmpty(SearchKey))
  230. {
  231. query = query.Where(m => m.Name.Contains(SearchKey));
  232. }
  233. if (Kind > 0)
  234. {
  235. query = query.Where(m => m.BindStatus == Kind);
  236. }
  237. if (ActiveStatus > 0)
  238. {
  239. if (ActiveStatus == 2) ActiveStatus = 0;
  240. query = query.Where(m => m.ActivationStatus == ActiveStatus);
  241. }
  242. int TotalCount = query.Count();
  243. int ActCount = query.Count(m => m.ActivationDate == today);
  244. int ProductCount = query.Count();
  245. int ProductActCount = query.Count(m => m.ActivationStatus == 1);
  246. int ProductUnActCount = ProductCount - ProductActCount;
  247. if (TradeSort == "1")
  248. {
  249. if (DateSort == "1")
  250. {
  251. query = query.OrderBy(m => m.TotalAmount).ThenBy(m => m.CreateDate);
  252. }
  253. else
  254. {
  255. query = query.OrderBy(m => m.TotalAmount).ThenByDescending(m => m.CreateDate);
  256. }
  257. }
  258. else
  259. {
  260. if (DateSort == "1")
  261. {
  262. query = query.OrderByDescending(m => m.TotalAmount).ThenBy(m => m.CreateDate);
  263. }
  264. else
  265. {
  266. query = query.OrderByDescending(m => m.TotalAmount).ThenByDescending(m => m.CreateDate);
  267. }
  268. }
  269. if (PageNum == 1)
  270. {
  271. query = query.Take(PageSize);
  272. }
  273. else
  274. {
  275. int skipNum = PageSize * (PageNum - 1);
  276. query = query.Skip(skipNum).Take(PageSize);
  277. }
  278. foreach (var item in query.ToList())
  279. {
  280. Dictionary<string, object> curData = new Dictionary<string, object>();
  281. curData.Add("MerchantName", item.Name); //商户姓名
  282. curData.Add("KqRegTime", item.CreateDate == null ? "" : item.CreateDate.Value.ToString("yyyy-MM-dd")); //渠道注册时间
  283. curData.Add("Id", item.Id); //Id
  284. curData.Add("TotalAmount", item.TotalAmount.ToString("f2")); //交易额
  285. curData.Add("TodayTrade", MerchantTradeStat.Instance.Amount(item.Id, DateTime.Now.ToString("yyyyMMdd")).ToString("f2")); //今日交易额
  286. curData.Add("TradeCount", item.TotalConsumeCount); //交易笔数
  287. curData.Add("TodayTradeCount", MerchantTradeStat.Instance.Count(item.Id, DateTime.Now.ToString("yyyyMMdd"))); //今日交易笔数
  288. dataList.Add(curData);
  289. }
  290. Other = new Dictionary<string, object>();
  291. Other.Add("TotalCount", TotalCount); //商户数
  292. Other.Add("ActCount", ActCount); //商户达标数
  293. Other.Add("UnActCount", ProductUnActCount); //未达标数
  294. return dataList;
  295. }
  296. #endregion
  297. #region 创客-首页-我的商户-商户详情
  298. // [Authorize]
  299. public JsonResult MyMerchantDetail(string value)
  300. {
  301. value = DesDecrypt(value);
  302. JsonData data = JsonMapper.ToObject(value);
  303. Dictionary<string, object> Obj = MyMerchantDetailDo(value);
  304. return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
  305. }
  306. public Dictionary<string, object> MyMerchantDetailDo(string value)
  307. {
  308. JsonData data = JsonMapper.ToObject(value);
  309. Dictionary<string, object> Obj = new Dictionary<string, object>();
  310. int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
  311. MerchantInfo merchant = MerchantInfoService.Query(Id);
  312. MerchantAddInfo addinfo = MerchantAddInfoService.Query(Id);
  313. Obj.Add("MerchantName", merchant.Name); //商户名称
  314. Obj.Add("LegalName", addinfo.CertLegalPerson); //企业法人
  315. Obj.Add("MerchantMobile", addinfo.MobilePhone); //商户手机号
  316. Obj.Add("SubjectType", addinfo.SubjectType); //主体类型
  317. Obj.Add("CreateDate", merchant.CreateDate == null ? "" : merchant.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //注册时间
  318. Obj.Add("ActivationDate", merchant.ActivationDate == null ? "" : merchant.ActivationDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //达标时间
  319. Obj.Add("TotalAmount", merchant.TotalAmount.ToString("f2")); //总交易额
  320. Obj.Add("ActivationStatus", merchant.ActivationStatus); //达标状态
  321. return Obj;
  322. }
  323. #endregion
  324. #region 创客-首页-我的商户-商户详情-交易统计
  325. // [Authorize]
  326. public JsonResult MerchantTradeList(string value)
  327. {
  328. value = DesDecrypt(value);
  329. JsonData data = JsonMapper.ToObject(value);
  330. Dictionary<string, object> other = new Dictionary<string, object>();
  331. List<Dictionary<string, object>> dataList = MerchantTradeListDo(value, out other);
  332. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = other });
  333. }
  334. public List<Dictionary<string, object>> MerchantTradeListDo(string value, out Dictionary<string, object> other)
  335. {
  336. JsonData data = JsonMapper.ToObject(value);
  337. string TradeMonth = data["TradeMonth"].ToString(); //交易月
  338. int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户Id
  339. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  340. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  341. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  342. string limit = " limit " + PageSize;
  343. if (PageNum == 1)
  344. {
  345. int skipNum = PageSize * (PageNum - 1);
  346. limit = " limit " + skipNum + "," + PageSize;
  347. }
  348. DataTable dt = CustomerSqlConn.dtable("select TradeDate,sum(TradeAmount),sum(TradeCount),sum(if(IsAct=1, TradeAmount, 0)),sum(if(IsAct=0, TradeAmount, 0)) from MerchantAmountSummay where MerchantId=" + MerchantId + " and TradeMonth='" + TradeMonth + "' group by TradeDate order by TradeDate desc" + limit, AppConfig.Base.SqlConnStr);
  349. foreach (DataRow dr in dt.Rows)
  350. {
  351. string TradeDate = dr["TradeDate"].ToString();
  352. Dictionary<string, object> curData = new Dictionary<string, object>();
  353. curData.Add("TradeDate", TradeDate.Substring(0, 4) + "-" + TradeDate.Substring(4, 2) + "-" + TradeDate.Substring(6, 2)); //交易日
  354. curData.Add("TradeAmt", dr[1].ToString()); //交易金额
  355. curData.Add("ActTradeAmt", dr[3].ToString()); //活动交易金额
  356. curData.Add("UnActTradeAmt", dr[4].ToString()); //非活动交易金额
  357. curData.Add("TradeCount", dr[2].ToString()); //交易笔数
  358. dataList.Add(curData);
  359. }
  360. other = new Dictionary<string, object>();
  361. if (PageNum == 1)
  362. {
  363. DataTable total = CustomerSqlConn.dtable("select sum(TradeAmount),sum(TradeCount),sum(if(IsAct=1, TradeAmount, 0)),sum(if(IsAct=0, TradeAmount, 0)) from MerchantAmountSummay where MerchantId=" + MerchantId + " and TradeMonth='" + TradeMonth + "'", AppConfig.Base.SqlConnStr);
  364. decimal TradeAmt = 0;
  365. decimal ActTradeAmt = 0;
  366. decimal UnActTradeAmt = 0;
  367. int TradeCount = 0;
  368. if (total.Rows.Count > 0)
  369. {
  370. TradeAmt = decimal.Parse(function.CheckNum(total.Rows[0][0].ToString())); //交易金额
  371. ActTradeAmt = decimal.Parse(function.CheckNum(total.Rows[0][2].ToString())); //活动交易金额
  372. UnActTradeAmt = decimal.Parse(function.CheckNum(total.Rows[0][3].ToString())); //非活动交易金额
  373. TradeCount = int.Parse(function.CheckNum(total.Rows[0][1].ToString())); //交易笔数
  374. }
  375. other.Add("TradeAmt", TradeAmt.ToString("f2")); //交易金额
  376. other.Add("ActTradeAmt", ActTradeAmt.ToString("f2")); //活动交易金额
  377. other.Add("UnActTradeAmt", UnActTradeAmt.ToString("f2")); //非活动交易金额
  378. other.Add("TradeCount", TradeCount); //交易笔数
  379. }
  380. return dataList;
  381. }
  382. #endregion
  383. #region 创客-首页-我的商户-商户详情-码牌
  384. // [Authorize]
  385. public JsonResult QrCodeList(string value)
  386. {
  387. value = DesDecrypt(value);
  388. JsonData data = JsonMapper.ToObject(value);
  389. int TotalCount = 0;
  390. List<Dictionary<string, object>> dataList = QrCodeListDo(value, out TotalCount);
  391. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = TotalCount });
  392. }
  393. public List<Dictionary<string, object>> QrCodeListDo(string value, out int TotalCount)
  394. {
  395. JsonData data = JsonMapper.ToObject(value);
  396. int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户Id
  397. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  398. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  399. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  400. IQueryable<Models.Main1.MerchantQrCode> query = main1db.MerchantQrCode.Where(m => m.MerchantId == MerchantId && m.QueryCount == 2).OrderByDescending(m => m.Id);
  401. TotalCount = query.Count();
  402. if (PageNum == 1)
  403. {
  404. query = query.Take(PageSize);
  405. }
  406. else
  407. {
  408. int skipNum = PageSize * (PageNum - 1);
  409. query = query.Skip(skipNum).Take(PageSize);
  410. }
  411. foreach (Models.Main1.MerchantQrCode item in query.ToList())
  412. {
  413. Dictionary<string, object> curData = new Dictionary<string, object>();
  414. curData.Add("SnNo", item.SnNo); //sn
  415. curData.Add("TradeAmount", QrCodeTradeStat.Instance.Amount(item.SnNo).ToString("f2"));
  416. curData.Add("BindTime", item.CreateDate == null ? "" : item.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
  417. dataList.Add(curData);
  418. }
  419. return dataList;
  420. }
  421. #endregion
  422. #region 创客-首页-我的商户-商户详情-音响
  423. // [Authorize]
  424. public JsonResult QrCodeList2(string value)
  425. {
  426. value = DesDecrypt(value);
  427. JsonData data = JsonMapper.ToObject(value);
  428. int TotalCount = 0;
  429. List<Dictionary<string, object>> dataList = QrCodeList2Do(value, out TotalCount);
  430. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = TotalCount });
  431. }
  432. public List<Dictionary<string, object>> QrCodeList2Do(string value, out int TotalCount)
  433. {
  434. JsonData data = JsonMapper.ToObject(value);
  435. int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户Id
  436. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  437. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  438. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  439. IQueryable<Models.Main1.MachineForQrCode> query = main1db.MachineForQrCode.Where(m => m.MerchantId == MerchantId && m.MachineSnNo != m.SnNo).OrderByDescending(m => m.MerchantId);
  440. TotalCount = query.Count();
  441. if (PageNum == 1)
  442. {
  443. query = query.Take(PageSize);
  444. }
  445. else
  446. {
  447. int skipNum = PageSize * (PageNum - 1);
  448. query = query.Skip(skipNum).Take(PageSize);
  449. }
  450. foreach (Models.Main1.MachineForQrCode item in query.ToList())
  451. {
  452. Dictionary<string, object> curData = new Dictionary<string, object>();
  453. curData.Add("SnNo", item.SnNo); //sn
  454. curData.Add("TradeAmount", QrCodeTradeStat.Instance.Amount(item.SnNo).ToString("f2"));
  455. curData.Add("BindTime", item.BindDate == null ? "" : item.BindDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
  456. dataList.Add(curData);
  457. }
  458. return dataList;
  459. }
  460. #endregion
  461. #region 首页-我的商户-商户搜索
  462. // [Authorize]
  463. public JsonResult MerchantSearch(string value)
  464. {
  465. value = DesDecrypt(value);
  466. JsonData data = JsonMapper.ToObject(value);
  467. List<Dictionary<string, object>> dataList = MerchantSearchDo(value);
  468. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
  469. }
  470. public List<Dictionary<string, object>> MerchantSearchDo(string value)
  471. {
  472. JsonData data = JsonMapper.ToObject(value);
  473. string SearchKey = data["SearchKey"].ToString(); //搜索关键词
  474. int UserId = int.Parse(function.CheckInt(data["UserId"].ToString()));
  475. // int ProductType = 1; //int.Parse(function.CheckInt(data["ProductType"].ToString()));
  476. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  477. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  478. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  479. IQueryable<MerchantInfo> query = maindb.MerchantInfo.Where(m => m.UserId == UserId);
  480. if (!string.IsNullOrEmpty(SearchKey))
  481. {
  482. query = query.Where(m => m.Name.Contains(SearchKey));
  483. }
  484. if (PageNum == 1)
  485. {
  486. query = query.Take(PageSize);
  487. }
  488. else
  489. {
  490. int skipNum = PageSize * (PageNum - 1);
  491. query = query.Skip(skipNum).Take(PageSize);
  492. }
  493. foreach (var item in query.ToList())
  494. {
  495. MerchantInfo subdata = MerchantInfoDbconn.Instance.Get(item.Id) ?? new MerchantInfo();
  496. Dictionary<string, object> curData = new Dictionary<string, object>();
  497. curData.Add("MerchantName", subdata.Name); //商户姓名
  498. curData.Add("KqRegTime", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //渠道注册时间
  499. curData.Add("Id", item.Id); //Id
  500. curData.Add("ThisMonthTrade", item.TotalAmount); //当月交易额
  501. dataList.Add(curData);
  502. }
  503. return dataList;
  504. }
  505. #endregion
  506. #region 创客-首页-进件记录-删除
  507. // [Authorize]
  508. public JsonResult Delete(string value)
  509. {
  510. value = DesDecrypt(value);
  511. JsonData data = JsonMapper.ToObject(value);
  512. AppResultJson result = DeleteDo(value);
  513. return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
  514. }
  515. public AppResultJson DeleteDo(string value)
  516. {
  517. JsonData data = JsonMapper.ToObject(value);
  518. int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
  519. int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //所属创客
  520. Dictionary<string, object> Obj = new Dictionary<string, object>();
  521. MerchantInfo edit = maindb.MerchantInfo.FirstOrDefault(m => m.Id == Id && m.UserId == UserId);
  522. if (edit != null)
  523. {
  524. maindb.MerchantInfo.Remove(edit);
  525. MerchantAddInfo editadd = maindb.MerchantAddInfo.FirstOrDefault(m => m.Id == Id);
  526. if (editadd != null)
  527. {
  528. maindb.MerchantAddInfo.Remove(editadd);
  529. }
  530. maindb.SaveChanges();
  531. }
  532. return new AppResultJson() { Status = "1", Info = "", Data = Obj };
  533. }
  534. #endregion
  535. #region 创客-首页-暂存商户
  536. // [Authorize]
  537. public JsonResult TmpMerchantList(string value)
  538. {
  539. value = DesDecrypt(value);
  540. JsonData data = JsonMapper.ToObject(value);
  541. List<Dictionary<string, object>> dataList = TmpMerchantListDo(value);
  542. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
  543. }
  544. public List<Dictionary<string, object>> TmpMerchantListDo(string value)
  545. {
  546. JsonData data = JsonMapper.ToObject(value);
  547. int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //所属创客
  548. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  549. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  550. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  551. List<MerchantInfo> query = maindb.MerchantInfo.Where(m => m.UserId == UserId && m.Sort == 0).ToList();
  552. foreach (var subdata in query)
  553. {
  554. Dictionary<string, object> curData = new Dictionary<string, object>();
  555. curData.Add("Name", subdata.Name); //名称
  556. curData.Add("Id", subdata.Id); //Id
  557. curData.Add("CreateDate", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //CreateDate
  558. curData.Add("SubjectType", 1); //主体类型
  559. dataList.Add(curData);
  560. }
  561. return dataList;
  562. }
  563. #endregion
  564. #region 商户-修改登录密码
  565. // [Authorize]
  566. public JsonResult ModifyLoginPwd(string value)
  567. {
  568. value = DesDecrypt(value);
  569. JsonData data = JsonMapper.ToObject(value);
  570. AppResultJson result = ModifyLoginPwdDo(value);
  571. return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
  572. }
  573. public AppResultJson ModifyLoginPwdDo(string value)
  574. {
  575. JsonData data = JsonMapper.ToObject(value);
  576. string LoginPwd = data["LoginPwd"].ToString(); //登录密码
  577. string NewLoginPwd = data["NewLoginPwd"].ToString(); //新登录密码
  578. Dictionary<string, object> Obj = new Dictionary<string, object>();
  579. MerchantInfo query = new MerchantInfo();
  580. int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
  581. query = MerchantInfoDbconn.Instance.Get(Id);
  582. if (query != null)
  583. {
  584. query.UpdateDate = DateTime.Now; //修改时间
  585. query.LoginPwd = LoginPwd; //登录密码
  586. }
  587. return new AppResultJson() { Status = "1", Info = "", Data = Obj };
  588. }
  589. #endregion
  590. #region 商户-商户详情
  591. // [Authorize]
  592. public JsonResult Detail(string value)
  593. {
  594. value = DesDecrypt(value);
  595. JsonData data = JsonMapper.ToObject(value);
  596. Dictionary<string, object> Obj = DetailDo(value);
  597. return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
  598. }
  599. public Dictionary<string, object> DetailDo(string value)
  600. {
  601. JsonData data = JsonMapper.ToObject(value);
  602. Dictionary<string, object> Obj = new Dictionary<string, object>();
  603. int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
  604. MerchantInfo query = MerchantInfoDbconn.Instance.Get(Id) ?? new MerchantInfo();
  605. MerchantAddInfo merchantAddInfo = maindb.MerchantAddInfo.FirstOrDefault(m => m.Id == Id) ?? new MerchantAddInfo();
  606. Obj.Add("Name", query.Name); //名称
  607. Obj.Add("Mobile", query.Mobile); //手机号
  608. Obj.Add("IsAuth", query.IsAuth); //是否认证
  609. Obj.Add("MchtNo", merchantAddInfo.MchtNo); //商户号
  610. Obj.Add("Logo", DefaultPic(query.Logo)); //Logo图片
  611. Obj.Add("Status", GetMainStatusName(merchantAddInfo.QueryCount, merchantAddInfo.Status));
  612. Obj.Add("AlipayStatus", merchantAddInfo.QueryCount);
  613. Obj.Add("WeChatStatus", merchantAddInfo.Status);
  614. Obj.Add("CreateDate", query.CreateDate == null ? "" : query.CreateDate.Value.ToString("yyyy-MM-dd"));
  615. return Obj;
  616. }
  617. private string GetMainStatusName(int AlipayStatus, int WeChatStatus)
  618. {
  619. if (AlipayStatus == 0 && WeChatStatus == 0) return "待审核";
  620. if (AlipayStatus == 0 && WeChatStatus == -1) return "部分未通过";
  621. if (AlipayStatus == -1 && WeChatStatus == 0) return "部分未通过";
  622. if (AlipayStatus == 0 && WeChatStatus == 1) return "部分待签约";
  623. if (AlipayStatus == 1 && WeChatStatus == 0) return "部分待签约";
  624. if (AlipayStatus == 0 && WeChatStatus == 2) return "部分已通过";
  625. if (AlipayStatus == 2 && WeChatStatus == 0) return "部分已通过";
  626. if (AlipayStatus == -1 && WeChatStatus == -1) return "审核未通过";
  627. if (AlipayStatus == -1 && WeChatStatus == 1) return "部分未通过";
  628. if (AlipayStatus == 1 && WeChatStatus == -1) return "部分未通过";
  629. if (AlipayStatus == -1 && WeChatStatus == 2) return "部分未通过";
  630. if (AlipayStatus == 2 && WeChatStatus == -1) return "部分未通过";
  631. if (AlipayStatus == 1 && WeChatStatus == 1) return "待签约";
  632. if (AlipayStatus == 1 && WeChatStatus == 2) return "部分待签约";
  633. if (AlipayStatus == 2 && WeChatStatus == 1) return "部分待签约";
  634. if (AlipayStatus == 2 && WeChatStatus == 2) return "已通过";
  635. return "";
  636. }
  637. private string GetStatusName(int WeChatStatus)
  638. {
  639. if (WeChatStatus == -1) return "审核未通过";
  640. if (WeChatStatus == 0) return "待审核";
  641. if (WeChatStatus == 1) return "待签约";
  642. if (WeChatStatus == 2) return "已通过";
  643. return "";
  644. }
  645. #endregion
  646. #region 商户-通过sn获取商户详情
  647. // [Authorize]
  648. public JsonResult DetailBySn(string value)
  649. {
  650. if (string.IsNullOrEmpty(value))
  651. {
  652. System.IO.StreamReader sr = new System.IO.StreamReader(Request.Body);
  653. value = sr.ReadToEnd();
  654. value = value.Split('=')[1];
  655. }
  656. value = DesDecrypt(value);
  657. JsonData data = JsonMapper.ToObject(value);
  658. Dictionary<string, object> Obj = DetailBySnDo(value);
  659. return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
  660. }
  661. public Dictionary<string, object> DetailBySnDo(string value)
  662. {
  663. function.WriteLog(value, "商户-通过sn获取商户详情");
  664. JsonData data = JsonMapper.ToObject(value);
  665. Dictionary<string, object> Obj = new Dictionary<string, object>();
  666. string Sn = data["Sn"].ToString();
  667. Models.Main1.MerchantQrCode code = MerchantQrCodeService.Query(Sn);
  668. MerchantInfo query = MerchantInfoService.Query(code.MerchantId);
  669. MerchantParamSet set = MerchantParamSetService.Query(code.MerchantId);
  670. Obj.Add("Name", query.Name); //名称
  671. Obj.Add("Mobile", query.Mobile); //手机号
  672. Obj.Add("IsAuth", query.IsAuth); //是否认证
  673. Obj.Add("Logo", DefaultPic(query.Logo)); //Logo图片
  674. Obj.Add("DiviPercent", set.IsAll == 1 ? 0M : set.DiviPercent);
  675. Obj.Add("MinPayMoney", set.MinPayMoney);
  676. return Obj;
  677. }
  678. #endregion
  679. #region 商户-忘记密码
  680. // [Authorize]
  681. public JsonResult ForgetPwd(string value)
  682. {
  683. value = DesDecrypt(value);
  684. JsonData data = JsonMapper.ToObject(value);
  685. AppResultJson result = ForgetPwdDo(value);
  686. return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
  687. }
  688. public AppResultJson ForgetPwdDo(string value)
  689. {
  690. JsonData data = JsonMapper.ToObject(value);
  691. string Mobile = data["Mobile"].ToString(); //手机号
  692. string LoginPwd = data["LoginPwd"].ToString(); //登录密码
  693. string MobileCode = data["MobileCode"].ToString(); //短信验证码
  694. if (string.IsNullOrEmpty(data["Mobile"].ToString()))
  695. {
  696. return new AppResultJson() { Status = "-1", Info = "请填写手机号" };
  697. }
  698. if (data["Mobile"].ToString().Length > 11)
  699. {
  700. return new AppResultJson() { Status = "-1", Info = "手机号最多11个字符" };
  701. }
  702. MobileCodeCheck mobilecheck = RedisDbconn.Instance.Get<MobileCodeCheck>("MobileCodeCheck:" + Mobile);
  703. if (mobilecheck == null)
  704. {
  705. return new AppResultJson() { Status = "-1", Info = "短信验证码不正确" };
  706. }
  707. if (mobilecheck.CheckCode != MobileCode)
  708. {
  709. return new AppResultJson() { Status = "-1", Info = "短信验证码不正确" };
  710. }
  711. RedisDbconn.Instance.Clear("MobileCodeCheck:" + Mobile);
  712. Dictionary<string, object> Obj = new Dictionary<string, object>();
  713. MerchantForMobile find = MerchantForMobileService.Query(Mobile);
  714. if (find == null)
  715. {
  716. return new AppResultJson() { Status = "-1", Info = "手机号不正确" };
  717. }
  718. MerchantInfo query = maindb.MerchantInfo.FirstOrDefault(m => m.Id == find.MerchantId);
  719. if (query != null)
  720. {
  721. query.LoginPwd = function.MD532(LoginPwd); //登录密码
  722. maindb.SaveChanges();
  723. }
  724. return new AppResultJson() { Status = "1", Info = "", Data = Obj };
  725. }
  726. #endregion
  727. #region 我的-商户统计数据(个人中心主界面)
  728. // [Authorize]
  729. public JsonResult StatData(string value)
  730. {
  731. value = DesDecrypt(value);
  732. JsonData data = JsonMapper.ToObject(value);
  733. Dictionary<string, object> Obj = StatDataDo(value);
  734. return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
  735. }
  736. public Dictionary<string, object> StatDataDo(string value)
  737. {
  738. JsonData data = JsonMapper.ToObject(value);
  739. int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
  740. var Info = MySelfUtil.StatData(Id);
  741. return Info;
  742. }
  743. #endregion
  744. #region 首页-查询该商户是否已存在
  745. // [Authorize]
  746. public JsonResult CheckMerchant(string value)
  747. {
  748. value = DesDecrypt(value);
  749. JsonData data = JsonMapper.ToObject(value);
  750. bool Obj = CheckMerchantDo(value);
  751. return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
  752. }
  753. public bool CheckMerchantDo(string value)
  754. {
  755. JsonData data = JsonMapper.ToObject(value);
  756. string CertMerchantName = data["CertMerchantName"].ToString();
  757. var Info = MerchantAddInfoService.Query(" CertMerchantName='" + CertMerchantName + "'");
  758. if (Info.Id > 0)
  759. {
  760. return true;
  761. }
  762. return false;
  763. }
  764. #endregion
  765. #region 检查签名是否合法,合法返回1,不合法返回提示信息
  766. /// <summary>
  767. /// 检查签名是否合法,合法返回1,不合法返回提示信息
  768. /// </summary>
  769. /// <param name="value">请求的参数(json字符串)</param>
  770. /// <param name="signField">要签名的字段</param>
  771. /// <returns></returns>
  772. private string CheckSign(string value, string[] signField)
  773. {
  774. JsonData json = JsonMapper.ToObject(value);
  775. Dictionary<string, string> dic = new Dictionary<string, string>();
  776. for (int i = 0; i < signField.Length; i++)
  777. {
  778. dic.Add(signField[i], json[signField[i]].ToString());
  779. }
  780. string sign = json["sign"].ToString(); //客户端签名字符串
  781. return new Sign().sign(dic, sign);
  782. }
  783. #endregion
  784. }
  785. }