MerchantAddInfoController.cs 46 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using Microsoft.AspNetCore.Mvc;
  5. using Microsoft.AspNetCore.Http;
  6. using Microsoft.Extensions.Logging;
  7. using Microsoft.Extensions.Options;
  8. using Microsoft.AspNetCore.Authorization;
  9. using MySystem.Service.Main;
  10. using System.Web;
  11. using MySystem.Models.Main;
  12. using LitJson;
  13. using Library;
  14. namespace MySystem.Areas.Api.Controllers.v1
  15. {
  16. [Area("Api")]
  17. [Route("Api/v1/[controller]/[action]")]
  18. public class MerchantAddInfoController : BaseController
  19. {
  20. public MerchantAddInfoController(IHttpContextAccessor accessor) : base(accessor)
  21. {
  22. }
  23. #region 创客-首页-新增商户
  24. // [Authorize]
  25. public JsonResult Add(string value)
  26. {
  27. value = DesDecrypt(value);
  28. JsonData data = JsonMapper.ToObject(value);
  29. AppResultJson result = AddDo(value);
  30. return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
  31. }
  32. public AppResultJson AddDo(string value)
  33. {
  34. function.WriteLog(value, "创客-首页-新增商户");
  35. // value = "{\"LicenseCopy\":\"/static/upload/2023/8/16/MT0bebebbf73dc38e2.png\",\"CertMerchantName\":\"门头\",\"LicenseNumber\":\"410900100013231\",\"SubjectType\":\"SUBJECT_TYPE_ENTERPRISE\",\"MerchantShortname\":\"mentou\",\"ServicePhone\":\"13308240813\",\"SalesScenesType\":62,\"MchtNo\":\"\",\"BizStoreName\":\"mentou\",\"BizAddressCode\":\"北京市,东城区\",\"BizStoreAddress\":\"四川省成都市武侯区力德时代7栋客小爽二楼\",\"IdCardCopy\":\"/static/upload/2023/8/16/MT562f81c2651ea325.png\",\"IdCardNational\":\"/static/upload/2023/8/16/MTfcce2c67986eb10a.png\",\"CertLegalPerson\":\"名字\",\"IdCardNumber\":\"51382219940929723x\",\"CardPeriodBegin\":\"2023-08-16\",\"CardPeriodEnd\":\"2050-01-01\",\"PeriodBegin\":\"2023-08-16\",\"PeriodEnd\":\"9999-12-31\",\"MobilePhone\":\"13308240813\",\"AccountName\":\"门头\",\"ChannelKind\":\"000002\",\"BankAccountType\":\"BANK_ACCOUNT_TYPE_CORPORATE\",\"AccountNumber\":\"1234567899654514\",\"AccountBank\":\"中国银行\",\"BankCard\":\"/static/upload/2023/8/16/MT001e52d37c926681.png\",\"OpenAccountLicenses\":\"/static/upload/2023/8/16/MTbd2519a719966813.png\",\"BankName\":\"中国银行上海市北京东路支行\",\"BankAddressCode\":\"北京市,东城区\",\"PersonWithIdCard\":\"/static/upload/2023/8/16/MT374848dbbd1a10fc.png\",\"StoreEntrancePic\":\"/static/upload/2023/8/16/MTc991f44f8e92523b.png\",\"IndoorPic\":\"/static/upload/2023/8/16/MTc4c21727b4d51405.png\",\"CheckstandImg\":\"/static/upload/2023/8/16/MT9c5d940e98a72f90.png\",\"Extra1\":\"/static/upload/2023/8/16/MTd2dea8cfbed28c69.png,/static/upload/2023/8/16/MTf4016b1b53a3e12e.png\",\"IndustryLicense1\":\"\",\"ResserveMobile\":\"13308240813\",\"ContactName\":\"名字\",\"ContactIdNumber\":\"51382219940929723x\",\"IdCardName\":\"名字\",\"Finish\":0,\"UserId\":\"1\",\"Id\":\"\"}";
  36. JsonData data = JsonMapper.ToObject(value);
  37. string LicenseCopy = data["LicenseCopy"].ToString(); //- 营业执照
  38. string CertMerchantName = data["CertMerchantName"].ToString(); //- 商户名称
  39. string LicenseNumber = data["LicenseNumber"].ToString(); //- 商户信用代码
  40. string SubjectType = data["SubjectType"].ToString(); //- 主体类型
  41. string MerchantShortname = data["MerchantShortname"].ToString(); //- 用户名称简写
  42. string ServicePhone = data["ServicePhone"].ToString(); //- 商户电话
  43. string SalesScenesType = data["SalesScenesType"].ToString(); //- 所属行业
  44. string MchtNo = data["MchtNo"].ToString(); // 收款商户号
  45. string BizStoreName = data["BizStoreName"].ToString(); //- 门店名称
  46. string BizAddressCode = data["BizAddressCode"].ToString(); //- 门店区域
  47. string BizStoreAddress = data["BizStoreAddress"].ToString(); //- 门店地址
  48. string IdCardCopy = data["IdCardCopy"].ToString(); //- 身份证正面
  49. string IdCardNational = data["IdCardNational"].ToString(); //- 身份证反面
  50. string CertLegalPerson = data["CertLegalPerson"].ToString(); //- 真实姓名
  51. string IdCardNumber = data["IdCardNumber"].ToString(); //- 身份证号码
  52. string CardPeriodBegin = data["CardPeriodBegin"].ToString(); //- 身份证有效期开始
  53. string CardPeriodEnd = data["CardPeriodEnd"].ToString(); //- 身份证有效期结束
  54. string PeriodBegin = "";
  55. string PeriodEnd = "";
  56. if(SubjectType != "SUBJECT_TYPE_SMALL")
  57. {
  58. PeriodBegin = data["PeriodBegin"].ToString(); //- 身份证有效期开始
  59. PeriodEnd = data["PeriodEnd"].ToString(); //- 身份证有效期结束
  60. }
  61. else
  62. {
  63. PeriodBegin = "1900-01-01";
  64. PeriodEnd = "1900-01-01";
  65. }
  66. string MobilePhone = data["MobilePhone"].ToString(); //- 手机号码
  67. string AccountName = data["AccountName"].ToString(); //- 开户名称
  68. string ChannelKind = data["ChannelKind"].ToString(); // 商户类型
  69. string BankAccountType = data["BankAccountType"].ToString(); //- 账户类型
  70. string AccountNumber = data["AccountNumber"].ToString(); //- 银行卡号
  71. string AccountBank = data["AccountBank"].ToString(); //- 开户行
  72. string BankCard = data["BankCard"].ToString(); // 银行卡照片
  73. string OpenAccountLicenses = data["OpenAccountLicenses"].ToString(); // 开户许可证
  74. string BankName = data["BankName"].ToString(); //- 开户行全称
  75. string BankAddressCode = data["BankAddressCode"].ToString(); //- 开户地区
  76. string PersonWithIdCard = data["PersonWithIdCard"].ToString(); //- 手持身份证照片(小微)
  77. string StoreEntrancePic = data["StoreEntrancePic"].ToString(); // 门头照片组
  78. string IndoorPic = data["IndoorPic"].ToString(); // 环境照片组
  79. string CheckstandImg = data["CheckstandImg"].ToString(); // 收银照片组
  80. string Extra1 = data["Extra1"].ToString(); // 补充资料照片组
  81. string IndustryLicense1 = data["IndustryLicense1"].ToString(); //- 特殊资质照片组
  82. // string ContactName = data["ContactName"].ToString(); //管理员姓名
  83. // string ContactIdNumber = data["ContactIdNumber"].ToString(); //管理员身份证件号码
  84. // string MobilePhone = data["MobilePhone"].ToString(); //联系手机
  85. // string ContactEmail = data["ContactEmail"].ToString(); //联系邮箱
  86. // string SubjectType = data["SubjectType"].ToString(); //主体类型 0-企业法人营业执照 1-个体工商户营业执照
  87. // string LicenseCopy = data["LicenseCopy"].ToString(); //营业执照照片
  88. // string LicenseNumber = data["LicenseNumber"].ToString(); //统一社会信用代码
  89. // string CertMerchantName = data["CertMerchantName"].ToString(); //商户名称
  90. // string CertLegalPerson = data["CertLegalPerson"].ToString(); //法人姓名
  91. // string IdCardCopy = data["IdCardCopy"].ToString(); //身份证人像面照片
  92. // string IdCardNational = data["IdCardNational"].ToString(); //身份证国徽面照片
  93. // string IdCardName = data["IdCardName"].ToString(); //身份证姓名
  94. // string IdCardNumber = data["IdCardNumber"].ToString(); //身份证号码
  95. // string IdCardAddress = data["IdCardAddress"].ToString(); //身份证号码
  96. // string CardPeriodBeginString = data["CardPeriodBegin"].ToString();
  97. // if (string.IsNullOrEmpty(CardPeriodBeginString))
  98. // {
  99. // CardPeriodBeginString = "1900-01-01";
  100. // }
  101. // DateTime CardPeriodBegin = DateTime.Parse(CardPeriodBeginString); //身份证有效期开始时间
  102. // string CardPeriodEndString = data["CardPeriodEnd"].ToString();
  103. // if (string.IsNullOrEmpty(CardPeriodEndString))
  104. // {
  105. // CardPeriodEndString = "1900-01-01";
  106. // }
  107. // DateTime CardPeriodEnd = DateTime.Parse(CardPeriodEndString); //身份证有效期结束时间
  108. // string ServicePhone = data["ServicePhone"].ToString(); //客服电话
  109. // string BizStoreName = data["BizStoreName"].ToString(); //门店名称
  110. // string BizAddressCode = data["BizAddressCode"].ToString(); //门店省市编码
  111. // string BizStoreAddress = data["BizStoreAddress"].ToString(); //门店地址
  112. // string StoreEntrancePic = data["StoreEntrancePic"].ToString(); //门店门头照片
  113. // string IndoorPic = data["IndoorPic"].ToString(); //店内环境照片
  114. // string QualificationType = data["QualificationType"].ToString(); //所属行业
  115. // string SettlementId = data["SettlementId"].ToString(); //入驻结算规则ID
  116. // string AlipayMccCode = "";
  117. // if (!string.IsNullOrEmpty(SettlementId))
  118. // {
  119. // AlipayMccCode = SettlementId.Substring(SettlementId.IndexOf("_") + 1);
  120. // SettlementId = SettlementId.Substring(0, SettlementId.IndexOf("_"));
  121. // }
  122. // string AlipayAccount = data["AlipayAccount"].ToString(); //支付宝账号
  123. // string BankAccountType = data["BankAccountType"].ToString(); //账户类型 1 对私 0 对公
  124. // string AccountName = data["AccountName"].ToString(); //开户名称
  125. // string AccountBank = data["AccountBank"].ToString(); //开户银行
  126. // string BankAddressCode = data["BankAddressCode"].ToString(); //开户银行省市编码
  127. // string MerchantShortname = data["MerchantShortname"].ToString();
  128. // string BankName = data["BankName"].ToString(); //开户银行全称
  129. // string AccountNumber = data["AccountNumber"].ToString(); //银行账号
  130. // string Qualifications = data["Qualifications"].ToString(); //特殊资质图
  131. // //new add parameters:
  132. // string PeriodBegin = data["PeriodBegin"].ToString();//营业执照有效开始时间
  133. // string PeriodEnd = data["PeriodEnd"].ToString();//营业执照有效结束时间
  134. // string ChannelKind = data["ChannelKind"].ToString(); //商户类型 有执照填000002无执照填000001
  135. // string ResserveMobile = data["ResserveMobile"].ToString(); //银行预留手机号 channelkind为000001时必填
  136. // string BusinessId = data["BusinessId"].ToString(); //经营范围 参考经营范围表
  137. // string OpenAccountLicenses = data["OpenAccountLicenses"].ToString(); //开户许可证(对公凭证)
  138. // // string RentAgreement = data["RentAgreement"].ToString(); //租赁协议
  139. // // string OperatorMcht = data["OperatorMcht"].ToString(); //盒伙人商户合影
  140. // // string AgentProtocol = data["AgentProtocol"].ToString(); //委托结算协议
  141. // // string SignaturePicture = data["SignaturePicture"].ToString(); //商户签名图片
  142. // // string Support = data["Support"].ToString(); //辅助照片
  143. // string CheckstandImg = data["CheckstandImg"].ToString(); //收银台
  144. // // string ProductImg = data["ProductImg"].ToString(); //商品照片
  145. // // string Agreement = data["Agreement"].ToString(); //合同签名
  146. // // string TaxImage = data["TaxImage"].ToString(); //税务登记证
  147. // // string OrganizationCopy = data["OrganizationCopy"].ToString(); //组织机构证照片
  148. // string IndustryLicense1 = data["IndustryLicense1"].ToString(); //行业许可证
  149. // // string FaceRecognition = data["FaceRecognition"].ToString(); //正面人像图片
  150. // string Extra1 = data["Extra1"].ToString(); //补充资料
  151. // string BankCard = data["BankCard"].ToString(); //银行卡照片
  152. // string PersonWithIdCard = data["PersonWithIdCard"].ToString(); //手持身份证
  153. // // string TakeCreditCard = data["TakeCreditCard"].ToString(); //拍卡
  154. // string MchtNo = data["MchtNo"].ToString(); //收款商户号
  155. int Finish = int.Parse(function.CheckInt(data["Finish"].ToString()));
  156. int UserId = int.Parse(function.CheckInt(data["UserId"].ToString()));
  157. int MerchantAddInfoId = int.Parse(function.CheckInt(data["Id"].ToString()));
  158. string BankBranchId = "";
  159. if (Finish == 1)
  160. {
  161. var openBank = OpenBankTableService.Query(" BankName='" + BankName + "'");
  162. if (openBank == null)
  163. {
  164. return new AppResultJson() { Status = "-1", Info = "开户银行全称不正确" };
  165. }
  166. BankBranchId = openBank.BankCode;
  167. }
  168. Dictionary<string, object> Obj = new Dictionary<string, object>();
  169. // var query = MerchantAddInfoService.Query(" CertMerchantName='" + CertMerchantName + "'");
  170. // if (query == null)
  171. // {
  172. // Dictionary<string, object> Fiel = new Dictionary<string, object>();
  173. // Fiel.Add("CertMerchantName", CertMerchantName);
  174. // MerchantAddInfoService.Add(Fiel);
  175. // }
  176. // var ActivitiesId = "20191030111cff5b5e";
  177. // var ActivitiesRate = "0.38";
  178. // MerchantAddInfoUtil.EditMerchantAddInfo(query.Id, ContactName, ContactIdNumber, MobilePhone, ContactEmail, SubjectType, LicenseCopy, LicenseNumber, CertLegalPerson, CertMerchantName, CertLegalPerson, ServicePhone, BizStoreName, BizAddressCode, BizStoreAddress, StoreEntrancePic, IndoorPic, QualificationType, SettlementId, BankAccountType, AccountName, AccountBank, BankAddressCode, BankName, BankBranchId, AccountNumber, IdCardCopy, IdCardNational, IdCardName, IdCardNumber, IdCardAddress, CardPeriodBegin, CardPeriodEnd, MerchantShortname, Qualifications, ActivitiesId, ActivitiesRate, AlipayAccount, AlipayMccCode, ChannelKind, SalesScenesType, OpenAccountLicenses, RentAgreement, OperatorMcht, AgentProtocol, SignaturePicture, Support, CheckstandImg, ProductImg, Agreement, TaxImage, OrganizationCopy, IndustryLicense1, FaceRecognition, Extra1, BankCard, PersonWithIdCard, TakeCreditCard, MchtNo);
  179. Dictionary<string, object> Fields = new Dictionary<string, object>();
  180. Fields.Add("LicenseCopy", LicenseCopy); //- 营业执照
  181. Fields.Add("CertMerchantName", CertMerchantName); //- 商户名称
  182. Fields.Add("LicenseNumber", LicenseNumber); //- 商户信用代码
  183. Fields.Add("SubjectType", SubjectType); //- 主体类型
  184. Fields.Add("MerchantShortname", MerchantShortname); //- 用户名称简写
  185. Fields.Add("ServicePhone", ServicePhone); //- 商户电话
  186. Fields.Add("SalesScenesType", SalesScenesType); //- 所属行业
  187. Fields.Add("MchtNo", MchtNo); // 收款商户号
  188. Fields.Add("BizStoreName", BizStoreName); //- 门店名称
  189. Fields.Add("BizAddressCode", BizAddressCode); //- 门店区域
  190. Fields.Add("BizStoreAddress", BizStoreAddress); //- 门店地址
  191. Fields.Add("IdCardCopy", IdCardCopy); //- 身份证正面
  192. Fields.Add("IdCardNational", IdCardNational); //- 身份证反面
  193. Fields.Add("CertLegalPerson", CertLegalPerson); //- 真实姓名
  194. Fields.Add("IdCardNumber", IdCardNumber); //- 身份证号码
  195. Fields.Add("CardPeriodBegin", CardPeriodBegin); //- 身份证有效期开始
  196. Fields.Add("CardPeriodEnd", CardPeriodEnd); //- 身份证有效期结束
  197. Fields.Add("PeriodBegin", PeriodBegin); //- 身份证有效期开始
  198. Fields.Add("PeriodEnd", PeriodEnd); //- 身份证有效期结束
  199. Fields.Add("MobilePhone", MobilePhone); //- 手机号码
  200. Fields.Add("AccountName", AccountName); //- 开户名称
  201. Fields.Add("ChannelKind", ChannelKind); // 商户类型
  202. Fields.Add("BankAccountType", BankAccountType); //- 账户类型
  203. Fields.Add("AccountNumber", AccountNumber); //- 银行卡号
  204. Fields.Add("AccountBank", AccountBank); //- 开户行
  205. Fields.Add("BankCard", BankCard); // 银行卡照片
  206. Fields.Add("openAccountLicenses", OpenAccountLicenses); // 开户许可证
  207. Fields.Add("BankName", BankName); //- 开户行全称
  208. Fields.Add("BankAddressCode", BankAddressCode); //- 开户地区
  209. Fields.Add("PersonWithIdCard", PersonWithIdCard); //- 手持身份证照片(小微)
  210. Fields.Add("StoreEntrancePic", StoreEntrancePic); // 门头照片组
  211. Fields.Add("IndoorPic", IndoorPic); // 环境照片组
  212. Fields.Add("checkstandImg", CheckstandImg); // 收银照片组
  213. Fields.Add("extra1", Extra1); // 补充资料照片组
  214. Fields.Add("industryLicense1", IndustryLicense1); //- 特殊资质照片组
  215. MerchantAddInfoUtil.EditMerchantAddInfo(Fields, MerchantAddInfoId);
  216. MerchantAddInfoId = (int)MerchantInfoUtil.EditMerchantInfo(MerchantAddInfoId, UserId, CertMerchantName, MobilePhone, BizAddressCode, BizStoreAddress).Data;
  217. if (Finish == 1)
  218. {
  219. Dictionary<string, object> Fiel = new Dictionary<string, object>();
  220. Fiel.Add("Sort", 1);
  221. MerchantInfoService.Edit(Fiel, MerchantAddInfoId);
  222. // 如果提交完整资料,则发送到BsServer执行进件操作
  223. RedisDbconn.Instance.AddList("MerchantConfirmQueue", "{\"MerchantId\":\"" + MerchantAddInfoId + "\"}");
  224. }
  225. Obj.Add("Id", MerchantAddInfoId); //Id
  226. return new AppResultJson() { Status = "1", Info = "", Data = Obj };
  227. }
  228. #endregion
  229. #region 创客-首页-商户进件详情
  230. // [Authorize]
  231. public JsonResult Detail(string value)
  232. {
  233. value = DesDecrypt(value);
  234. JsonData data = JsonMapper.ToObject(value);
  235. Dictionary<string, object> Obj = DetailDo(value);
  236. return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
  237. }
  238. public Dictionary<string, object> DetailDo(string value)
  239. {
  240. JsonData data = JsonMapper.ToObject(value);
  241. int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
  242. var query = MerchantAddInfoService.Query(Id);
  243. Dictionary<string, string> Subjects = GetSubjects();
  244. Dictionary<string, string> AccountTypes = GetAccountTypes();
  245. List<SettleData> Settles = GetSettles(query.SubjectType);
  246. return MerchantAddInfoUtil.MerchantAddInfoDetail(query, Subjects, AccountTypes, Settles);
  247. }
  248. #endregion
  249. #region 创客-首页-经营范围
  250. // [Authorize]
  251. public JsonResult BusinessScope(string value)
  252. {
  253. value = DesDecrypt(value);
  254. JsonData data = JsonMapper.ToObject(value);
  255. List<Dictionary<string, object>> dataList = BusinessScopeDo(value);
  256. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
  257. }
  258. public List<Dictionary<string, object>> BusinessScopeDo(string value)
  259. {
  260. JsonData data = JsonMapper.ToObject(value);
  261. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  262. var first = maindb.BusinessScopeType.OrderBy(m => m.Id).ToList();
  263. foreach (var itemf in first)
  264. {
  265. Dictionary<string, object> item = new Dictionary<string, object>();
  266. item.Add("value", itemf.Id);
  267. item.Add("text", itemf.KindName);
  268. var second = maindb.BusinessScope.Where(m => m.KindId == itemf.Id).OrderBy(m => m.Id).ToList();
  269. List<Dictionary<string, object>> sublist = new List<Dictionary<string, object>>();
  270. foreach (var items in second)
  271. {
  272. Dictionary<string, object> subitem = new Dictionary<string, object>();
  273. subitem.Add("value", items.Id);
  274. subitem.Add("text", items.Name);
  275. sublist.Add(subitem);
  276. }
  277. item.Add("children", sublist);
  278. dataList.Add(item);
  279. }
  280. return dataList;
  281. }
  282. #endregion
  283. #region 创客-首页-进件选项接口
  284. // [Authorize]
  285. public JsonResult Options(string value)
  286. {
  287. value = DesDecrypt(value);
  288. JsonData data = JsonMapper.ToObject(value);
  289. List<Dictionary<string, object>> dataList = OptionsDo(value);
  290. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
  291. }
  292. public List<Dictionary<string, object>> OptionsDo(string value)
  293. {
  294. JsonData data = JsonMapper.ToObject(value);
  295. string Kind = data["Kind"].ToString(); //分类
  296. int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
  297. int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
  298. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  299. // if (Kind == "2")
  300. // {
  301. // dataList = GetPersonSettles();
  302. // }
  303. // else if (Kind == "21")
  304. // {
  305. // dataList = GetBusinessSettles();
  306. // }
  307. // if (!string.IsNullOrEmpty(Kind))
  308. if (Kind == "2" || Kind == "21")
  309. {
  310. Dictionary<string, object> item = new Dictionary<string, object>();
  311. var first = maindb.BusinessScopeType.OrderBy(m => m.Id).ToList();
  312. foreach (var itemf in first)
  313. {
  314. item.Add("Id", itemf.Id);
  315. item.Add("Name", itemf.KindName);
  316. var second = maindb.BusinessScope.Where(m => m.KindId == itemf.Id).OrderBy(m => m.Id).ToList();
  317. List<Dictionary<string, object>> sublist = new List<Dictionary<string, object>>();
  318. foreach (var items in second)
  319. {
  320. Dictionary<string, object> subitem = new Dictionary<string, object>();
  321. subitem.Add("Id", items.Id);
  322. subitem.Add("Name", items.Name);
  323. sublist.Add(subitem);
  324. }
  325. item.Add("Children", sublist);
  326. dataList.Add(item);
  327. }
  328. }
  329. else
  330. {
  331. Dictionary<string, string> query = new Dictionary<string, string>();
  332. if (Kind == "1")
  333. {
  334. query = GetSubjects();
  335. }
  336. else if (Kind == "3")
  337. {
  338. query = GetAccountTypes();
  339. }
  340. else if (Kind == "4")
  341. {
  342. query = GetBanks();
  343. }
  344. foreach (string key in query.Keys)
  345. {
  346. Dictionary<string, object> curData = new Dictionary<string, object>();
  347. curData.Add("text", query[key]); //文本
  348. curData.Add("value", key); //值
  349. dataList.Add(curData);
  350. }
  351. }
  352. return dataList;
  353. }
  354. public Dictionary<string, string> GetSubjects()
  355. {
  356. Dictionary<string, string> dic = new Dictionary<string, string>();
  357. dic.Add("SUBJECT_TYPE_INDIVIDUAL", "个体工商户");
  358. dic.Add("SUBJECT_TYPE_ENTERPRISE", "企业公司");
  359. dic.Add("SUBJECT_TYPE_SMALL", "小微商户");
  360. // dic.Add("SUBJECT_TYPE_INSTITUTIONS", "党政、机关及事业单位");
  361. // dic.Add("SUBJECT_TYPE_OTHERS", "其他组织");
  362. return dic;
  363. }
  364. public List<SettleData> GetSettles(string Kind)
  365. {
  366. if (Kind == "SUBJECT_TYPE_INDIVIDUAL")
  367. {
  368. return GetPersonSettleItems();
  369. }
  370. return GetBusinessSettleItems();
  371. }
  372. public List<SettleData> GetPersonSettleItems()
  373. {
  374. List<SettleData> dic = new List<SettleData>();
  375. dic.Add(new SettleData() { ptext = "食品生鲜", text = "肉、禽、蛋及水产品等", value = "719", code = "A0002_B0202" });
  376. dic.Add(new SettleData() { ptext = "健身运动服务", text = "健身房", value = "719", code = "A0004_B0064" });
  377. dic.Add(new SettleData() { ptext = "健身运动服务", text = "体育场馆", value = "719", code = "A0004_B0068" });
  378. dic.Add(new SettleData() { ptext = "居民生活服务", text = "公共交通", value = "719", code = "A0006_B0088" });
  379. dic.Add(new SettleData() { ptext = "景区/酒店", text = "旅行住宿", value = "719", code = "A0010_B0157" });
  380. dic.Add(new SettleData() { ptext = "居民生活服务", text = "生活服务", value = "719", code = "A0003_B0116" });
  381. dic.Add(new SettleData() { ptext = "零售", text = "百货商城", value = "719", code = "A0002_B0017" });
  382. dic.Add(new SettleData() { ptext = "服饰鞋包", text = "服饰鞋包", value = "719", code = "A0002_B0026" });
  383. dic.Add(new SettleData() { ptext = "零售", text = "家居家纺建材", value = "719", code = "A0002_B0216" });
  384. dic.Add(new SettleData() { ptext = "零售", text = "母婴玩具", value = "719", code = "A0002_B0032" });
  385. dic.Add(new SettleData() { ptext = "零售", text = "数码家电", value = "719", code = "A0003_B0051" });
  386. dic.Add(new SettleData() { ptext = "零售", text = "图书音像", value = "719", code = "A0002_B0031" });
  387. dic.Add(new SettleData() { ptext = "居民生活服务", text = "文化玩乐宠物", value = "719", code = "A0004_B0070" });
  388. dic.Add(new SettleData() { ptext = "咨询/娱乐票务", text = "娱乐票务", value = "719", code = "A0004_B0065" });
  389. dic.Add(new SettleData() { ptext = "零售", text = "办公用品", value = "719", code = "A0002_B0203" });
  390. dic.Add(new SettleData() { ptext = "零售", text = "工业产品", value = "719", code = "A0002_B0042" });
  391. dic.Add(new SettleData() { ptext = "咨询/娱乐票务", text = "专业咨询", value = "719", code = "A0008_B0139" });
  392. dic.Add(new SettleData() { ptext = "其他", text = "其他类别", value = "716", code = "A0002_B0043" });
  393. // dic.Add(new SettleData() { ptext = "餐饮", text = "餐饮", code = "C_C05_5814", value = "719", special = 0});
  394. // dic.Add(new SettleData() { ptext = "食品生鲜", text = "酒类", code = "C_C05_5921", value = "719", special = 1});
  395. // dic.Add(new SettleData() { ptext = "食品生鲜", text = "肉、禽、蛋及水产品等", code = "C_C05_5422", value = "719", special = 0});
  396. // dic.Add(new SettleData() { ptext = "私立/民营医院/诊所", text = "医疗服务", code = "P_P01_8011", value = "719", special = 1});
  397. // dic.Add(new SettleData() { ptext = "保健器械/医疗器械/非处方药品", text = "药品、药品经营者(批发商)", code = "B_B04_5122", value = "719", special = 1});
  398. // dic.Add(new SettleData() { ptext = "保健器械/医疗器械/非处方药品", text = "医疗器械", code = "B_B04_5047", value = "719", special = 1});
  399. // dic.Add(new SettleData() { ptext = "游艺厅/KTV/网吧", text = "游艺厅/KTV", code = "D_D01_7999", value = "719", special = 1});
  400. // dic.Add(new SettleData() { ptext = "游艺厅/KTV/网吧", text = "网吧", code = "D_D01_7999", value = "719", special = 1});
  401. // dic.Add(new SettleData() { ptext = "宠物医院", text = "宠物及宠物用品", code = "C_C10_5995", value = "719", special = 1});
  402. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "公共交通", code = "A_A01_4121", value = "719", special = 0});
  403. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "旅行住宿", code = "A_A04_7011", value = "719", special = 0});
  404. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "公共仓储、集装整理", code = "A_A02_4225", value = "719", special = 0});
  405. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "商业服务", code = "S_S05_7338", value = "719", special = 0});
  406. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "汽车租赁和服务", code = "S_S10_7512", value = "719", special = 0});
  407. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "生活服务", code = "S_S08_7295", value = "719", special = 0});
  408. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "百货商城", code = "C_C04_5411", value = "719", special = 0});
  409. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "服饰鞋包", code = "C_C06_5699", value = "719", special = 0});
  410. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "家居家纺建材", code = "C_C03_5211", value = "719", special = 0});
  411. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "母婴玩具", code = "C_C02_5641", value = "719", special = 0});
  412. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "数码家电", code = "C_C07_5732", value = "719", special = 0});
  413. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "图书音像", code = "C_C09_5942", value = "719", special = 0});
  414. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "文化玩乐宠物", code = "C_C10_5995", value = "719", special = 0});
  415. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "彩票", code = "D_D03_7995", value = "719", special = 0});
  416. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "娱乐票务", code = "D_D01_7999", value = "719", special = 0});
  417. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "法律咨询和律师事务所", code = "P_P04_8111", value = "719", special = 1});
  418. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "办公用品", code = "B_B01_5943", value = "719", special = 0});
  419. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "工业产品", code = "B_B02_5065", value = "719", special = 0});
  420. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "汽车和运输工具", code = "B_B03_5599", value = "719", special = 0});
  421. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/其他", text = "专业咨询", code = "P_P04_8999", value = "719", special = 0});
  422. // dic.Add(new SettleData() { ptext = "话费通讯", text = "话费充值与缴费", code = "D_D04_4815", value = "720", special = 1});
  423. // dic.Add(new SettleData() { ptext = "加油", text = "加油站、服务站", code = "B_B03_5541", value = "721", special = 1});
  424. return dic;
  425. }
  426. public List<Dictionary<string, object>> GetPersonSettles()
  427. {
  428. List<SettleData> dic = GetPersonSettleItems();
  429. int i = 0;
  430. List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
  431. foreach (string sub in dic.Select(m => m.ptext).Distinct().ToList())
  432. {
  433. i += 1;
  434. Dictionary<string, object> bigDic = new Dictionary<string, object>();
  435. bigDic.Add("value", i.ToString());
  436. bigDic.Add("text", sub);
  437. List<Dictionary<string, object>> children = new List<Dictionary<string, object>>();
  438. foreach (SettleData ssub in dic.Where(m => m.ptext == sub).ToList())
  439. {
  440. Dictionary<string, object> smallDic = new Dictionary<string, object>();
  441. smallDic.Add("value", ssub.value + "_" + ssub.code);
  442. smallDic.Add("text", ssub.text);
  443. smallDic.Add("special", ssub.special);
  444. children.Add(smallDic);
  445. }
  446. bigDic.Add("children", children);
  447. list.Add(bigDic);
  448. }
  449. return list;
  450. }
  451. public List<SettleData> GetBusinessSettleItems()
  452. {
  453. List<SettleData> dic = new List<SettleData>();
  454. dic.Add(new SettleData() { ptext = "餐饮", text = "餐饮", value = "716", code = "A0001_B0001" });
  455. dic.Add(new SettleData() { ptext = "食品生鲜", text = "肉、禽、蛋及水产品等", value = "716", code = "A0002_B0202" });
  456. dic.Add(new SettleData() { ptext = "健身运动服务", text = "健身房", value = "716", code = "A0004_B0064" });
  457. dic.Add(new SettleData() { ptext = "健身运动服务", text = "体育场馆", value = "716", code = "A0004_B0068" });
  458. dic.Add(new SettleData() { ptext = "城市公共交通", text = "公共交通", value = "716", code = "A0006_B0088" });
  459. dic.Add(new SettleData() { ptext = "景区/酒店", text = "旅行住宿", value = "716", code = "A0010_B0157" });
  460. dic.Add(new SettleData() { ptext = "居民生活服务", text = "生活服务", value = "716", code = "A0003_B0116" });
  461. dic.Add(new SettleData() { ptext = "零售", text = "百货商城", value = "716", code = "A0002_B0017" });
  462. dic.Add(new SettleData() { ptext = "服饰鞋包", text = "服饰鞋包", value = "716", code = "A0002_B0026" });
  463. dic.Add(new SettleData() { ptext = "零售", text = "家居家纺建材", value = "716", code = "A0002_B0216" });
  464. dic.Add(new SettleData() { ptext = "零售", text = "母婴玩具", value = "716", code = "A0002_B0032" });
  465. dic.Add(new SettleData() { ptext = "零售", text = "数码家电", value = "716", code = "A0003_B0051" });
  466. dic.Add(new SettleData() { ptext = "零售", text = "图书音像", value = "716", code = "A0002_B0031" });
  467. dic.Add(new SettleData() { ptext = "居民生活服务", text = "文化玩乐宠物", value = "716", code = "A0004_B0070" });
  468. dic.Add(new SettleData() { ptext = "咨询/娱乐票务", text = "娱乐票务", value = "716", code = "A0004_B0065" });
  469. dic.Add(new SettleData() { ptext = "零售", text = "办公用品", value = "716", code = "A0002_B0203" });
  470. dic.Add(new SettleData() { ptext = "零售", text = "工业产品", value = "716", code = "A0002_B0042" });
  471. dic.Add(new SettleData() { ptext = "婚介平台/就业信息平台/其他信息服务平台", text = "婚介服务", value = "720", code = "A0003_B0053" });
  472. dic.Add(new SettleData() { ptext = "零售", text = "其它类别", value = "716", code = "A0002_B0043" });
  473. // dic.Add(new SettleData() { ptext = "餐饮", text = "餐饮", code = "C_C05_5814", value = "716", special = 0});
  474. // dic.Add(new SettleData() { ptext = "电商平台", text = "电商平台", code = "C_C05_5814", value = "716", special = 0});
  475. // dic.Add(new SettleData() { ptext = "食品生鲜", text = "酒类", code = "C_C05_5921", value = "716", special = 1});
  476. // dic.Add(new SettleData() { ptext = "食品生鲜", text = "肉、禽、蛋及水产品等", code = "C_C05_5422", value = "716", special = 0});
  477. // dic.Add(new SettleData() { ptext = "电信运营商/宽带收费", text = "电信通讯", code = "D_D04_4814", value = "716", special = 1});
  478. // dic.Add(new SettleData() { ptext = "私立/民营医院/诊所", text = "医疗服务", code = "P_P01_8011", value = "716", special = 1});
  479. // dic.Add(new SettleData() { ptext = "保健器械/医疗器械/非处方药品", text = "医疗器械", code = "B_B04_5047", value = "716", special = 1});
  480. // dic.Add(new SettleData() { ptext = "保健器械/医疗器械/非处方药品", text = "药品、药品经营者(批发商)", code = "B_B04_5122", value = "716", special = 1});
  481. // dic.Add(new SettleData() { ptext = "游艺厅/KTV/网吧", text = "游艺厅/KTV", code = "D_D01_7999", value = "716", special = 1});
  482. // dic.Add(new SettleData() { ptext = "游艺厅/KTV/网吧", text = "网吧", code = "D_D01_7999", value = "716", special = 1});
  483. // dic.Add(new SettleData() { ptext = "宠物医院", text = "宠物及宠物用品", code = "C_C10_5995", value = "716", special = 1});
  484. // dic.Add(new SettleData() { ptext = "旅行社", text = "旅行社和旅游服务", code = "A_A04_4722", value = "716", special = 1});
  485. // dic.Add(new SettleData() { ptext = "宗教组织", text = "宗教物品", code = "C_C10_5973", value = "716", special = 0});
  486. // dic.Add(new SettleData() { ptext = "宗教组织", text = "其他宗教服务", code = "P_P04_8999", value = "716", special = 1});
  487. // dic.Add(new SettleData() { ptext = "文物经营/文物复制品销售", text = "文物经营/文物复制品销售", code = "C_C10_5971", value = "716", special = 1});
  488. // dic.Add(new SettleData() { ptext = "拍卖典当", text = "典当行", code = "S_S04_5933", value = "716", special = 1});
  489. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "公共交通", code = "A_A01_4121", value = "716", special = 0});
  490. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "旅行住宿", code = "A_A04_7011", value = "716", special = 0});
  491. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "公共仓储、集装整理", code = "A_A02_4225", value = "716", special = 0});
  492. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "商业服务", code = "S_S05_7338", value = "716", special = 0});
  493. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "汽车租赁和服务", code = "S_S10_7512", value = "716", special = 0});
  494. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "生活服务", code = "S_S08_7295", value = "716", special = 0});
  495. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "百货商城", code = "C_C04_5411", value = "716", special = 0});
  496. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "服饰鞋包", code = "C_C06_5699", value = "716", special = 0});
  497. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "家居家纺建材", code = "C_C03_5211", value = "716", special = 0});
  498. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "母婴玩具", code = "C_C02_5641", value = "716", special = 0});
  499. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "数码家电", code = "C_C07_5732", value = "716", special = 0});
  500. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "图书音像", code = "C_C09_5942", value = "716", special = 0});
  501. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "文化玩乐宠物", code = "C_C10_5995", value = "716", special = 0});
  502. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "彩票", code = "D_D03_7995", value = "716", special = 0});
  503. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "娱乐票务", code = "D_D01_7999", value = "716", special = 0});
  504. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "法律咨询和律师事务所", code = "P_P04_8111", value = "716", special = 1});
  505. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "办公用品", code = "B_B01_5943", value = "716", special = 0});
  506. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "工业产品", code = "B_B02_5065", value = "716", special = 0});
  507. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "汽车和运输工具", code = "B_B03_5599", value = "716", special = 0});
  508. // dic.Add(new SettleData() { ptext = "零售批发/生活娱乐/网上商城/其他", text = "专业咨询", code = "P_P04_8999", value = "716", special = 0});
  509. // dic.Add(new SettleData() { ptext = "话费通讯", text = "话费充值与缴费", code = "D_D04_4815", value = "728", special = 1});
  510. // dic.Add(new SettleData() { ptext = "婚介平台/就业信息平台/其他", text = "婚介服务", code = "S_S08_7273", value = "728", special = 0});
  511. // dic.Add(new SettleData() { ptext = "门户论坛/网络广告及推广/软件开发/其他互联网服务", text = "计算机服务/其他", code = "D_D05_7372", value = "711", special = 0});
  512. // dic.Add(new SettleData() { ptext = "快递", text = "快递服务", code = "A_A02_4215", value = "717", special = 1});
  513. // dic.Add(new SettleData() { ptext = "加油", text = "加油站、服务站", code = "B_B03_5541", value = "717", special = 1});
  514. // dic.Add(new SettleData() { ptext = "公共事业(水电煤气)", text = "公共事业(电、气、水)", code = "S_S06_4900", value = "730", special = 1});
  515. // dic.Add(new SettleData() { ptext = "公共事业(水电煤气)", text = "公共事业-电力缴费", code = "S_S06_4901", value = "730", special = 1});
  516. // dic.Add(new SettleData() { ptext = "公共事业(水电煤气)", text = "公共事业-煤气缴费", code = "S_S06_4902", value = "730", special = 1});
  517. // dic.Add(new SettleData() { ptext = "公共事业(水电煤气)", text = "公共事业-自来水缴费", code = "S_S06_4903", value = "730", special = 1});
  518. return dic;
  519. }
  520. public List<Dictionary<string, object>> GetBusinessSettles()
  521. {
  522. List<SettleData> dic = GetBusinessSettleItems();
  523. int i = 0;
  524. List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
  525. foreach (string sub in dic.Select(m => m.ptext).Distinct().ToList())
  526. {
  527. i += 1;
  528. Dictionary<string, object> bigDic = new Dictionary<string, object>();
  529. bigDic.Add("value", i.ToString());
  530. bigDic.Add("text", sub);
  531. List<Dictionary<string, object>> children = new List<Dictionary<string, object>>();
  532. foreach (SettleData ssub in dic.Where(m => m.ptext == sub).ToList())
  533. {
  534. Dictionary<string, object> smallDic = new Dictionary<string, object>();
  535. smallDic.Add("value", ssub.value + "_" + ssub.code);
  536. smallDic.Add("text", ssub.text);
  537. smallDic.Add("special", ssub.special);
  538. children.Add(smallDic);
  539. }
  540. bigDic.Add("children", children);
  541. list.Add(bigDic);
  542. }
  543. return list;
  544. }
  545. public Dictionary<string, string> GetAccountTypes()
  546. {
  547. Dictionary<string, string> dic = new Dictionary<string, string>();
  548. dic.Add("BANK_ACCOUNT_TYPE_CORPORATE", "企业对公银行账号");
  549. dic.Add("BANK_ACCOUNT_TYPE_PERSONAL", "法人个人银行卡");
  550. return dic;
  551. }
  552. public Dictionary<string, string> GetBanks()
  553. {
  554. Dictionary<string, string> dic = new Dictionary<string, string>();
  555. dic.Add("工商银行", "工商银行");
  556. dic.Add("农业银行", "农业银行");
  557. dic.Add("邮储银行", "邮储银行");
  558. dic.Add("建设银行", "建设银行");
  559. dic.Add("招商银行", "招商银行");
  560. dic.Add("中国银行", "中国银行");
  561. dic.Add("交通银行", "交通银行");
  562. dic.Add("浦发银行", "浦发银行");
  563. dic.Add("广发银行", "广发银行");
  564. dic.Add("民生银行", "民生银行");
  565. dic.Add("平安银行", "平安银行");
  566. dic.Add("光大银行", "光大银行");
  567. dic.Add("兴业银行", "兴业银行");
  568. dic.Add("中信银行", "中信银行");
  569. dic.Add("上海银行", "上海银行");
  570. dic.Add("其他银行", "其他银行");
  571. return dic;
  572. }
  573. #endregion
  574. #region 检查签名是否合法,合法返回1,不合法返回提示信息
  575. /// <summary>
  576. /// 检查签名是否合法,合法返回1,不合法返回提示信息
  577. /// </summary>
  578. /// <param name="value">请求的参数(json字符串)</param>
  579. /// <param name="signField">要签名的字段</param>
  580. /// <returns></returns>
  581. private string CheckSign(string value, string[] signField)
  582. {
  583. JsonData json = JsonMapper.ToObject(value);
  584. Dictionary<string, string> dic = new Dictionary<string, string>();
  585. for (int i = 0; i < signField.Length; i++)
  586. {
  587. dic.Add(signField[i], json[signField[i]].ToString());
  588. }
  589. string sign = json["sign"].ToString(); //客户端签名字符串
  590. return new Sign().sign(dic, sign);
  591. }
  592. #endregion
  593. }
  594. }