using System; using System.Collections.Generic; using System.Linq; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Http; using Microsoft.Extensions.Logging; using Microsoft.Extensions.Options; using Microsoft.AspNetCore.Authorization; using System.Web; using MySystem.Models.Main1; using MySystem.Service.Main1; using LitJson; using Library; using MySystem.Service.KxsMain; namespace MySystem.Areas.Api.Controllers.v1.Main1 { [Area("Api")] [Route("/v1/QrCodePlateMain/[controller]/[action]")] public class MerchantAddInfoController : BaseController { public MerchantAddInfoController(IHttpContextAccessor accessor) : base(accessor) { } #region 进件管理-直连商户列表 [Authorize] public JsonResult DirectList(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Other = new Dictionary(); List> dataList = DirectListDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } private List> DirectListDo(string value, out Dictionary Other) { JsonData data = JsonMapper.ToObject(value); string SubjectType = data["SubjectType"].ToString(); //主体类型(1 企业 2 个体) string CertMerchantName = data["CertMerchantName"].ToString(); //商户名称 string ServicePhone = data["ServicePhone"].ToString(); //客服电话 string MakerCode = data["MakerCode"].ToString(); //所属创客编号 string Status = data["Status"].ToString(); //商户状态(0 审核中 1 已通过 -1 审核失败 20 微信待签约 21 微信已签约 10 支付宝待签约 11 支付宝已签约) int pageSize = int.Parse(function.CheckInt(data["page_size"].ToString())); int pageNum = int.Parse(function.CheckInt(data["page_num"].ToString())); string condition = ""; var merIds = MerchantInfoUtil.QuerySenedMerchantId(); condition = " and Id in (" + merIds + ")"; if (!string.IsNullOrEmpty(data["SubjectType"].ToString())) { if (data["SubjectType"].ToString() == "1") SubjectType = "SUBJECT_TYPE_ENTERPRISE"; //企业公司 if (data["SubjectType"].ToString() == "2") SubjectType = "SUBJECT_TYPE_INDIVIDUAL"; //个体工商户 condition += " and SubjectType='" + SubjectType + "'"; } if (!string.IsNullOrEmpty(data["CertMerchantName"].ToString())) { condition += " and CertMerchantName='" + CertMerchantName + "'"; } if (!string.IsNullOrEmpty(data["ServicePhone"].ToString())) { condition += " and ServicePhone='" + ServicePhone + "'"; } if (!string.IsNullOrEmpty(data["MakerCode"].ToString())) { var Ids = MerchantInfoUtil.QueryMerchantIdByMakerCode(MakerCode); condition += " and Id in (" + Ids + ")"; } if (!string.IsNullOrEmpty(data["Status"].ToString())) { if (Status == "0") condition += " and Status=0 and QueryCount=0"; //待审核 if (Status == "-1") condition += " and (Status=-1 or QueryCount=-1)"; //审核失败 if (Status == "1") condition += " and (Status=1 or QueryCount=1)"; //待签约 if (Status == "2") condition += " and Status=2 and QueryCount=2"; //已通过 } List relationData = new List(); List> dataList = new List>(); Other = new Dictionary(); int count = 0; List> source = MerchantAddInfoService.List(relationData, condition, out count, pageNum, pageSize); foreach (Dictionary subdata in source) { Dictionary curData = new Dictionary(); var status = int.Parse(subdata["Status"].ToString()); var queryCount = int.Parse(subdata["QueryCount"].ToString()); //商户Id var MerchantId = int.Parse(subdata["Id"].ToString()); //主体类型 var subjectType = 0; if (subdata["SubjectType"].ToString() == "SUBJECT_TYPE_ENTERPRISE") subjectType = 1; //企业公司 if (subdata["SubjectType"].ToString() == "SUBJECT_TYPE_INDIVIDUAL") subjectType = 2; //个体工商户 curData.Add("Id", subdata["Id"].ToString()); //Id curData.Add("SubjectType", subjectType); //主体类型(1 企业 2 个体) curData.Add("CertMerchantName", subdata["CertMerchantName"].ToString()); //商户名称 curData.Add("ServicePhone", subdata["ServicePhone"].ToString()); //客服电话 curData.Add("BizStoreAddress", subdata["BizStoreAddress"].ToString()); //门店地址 curData.Add("CreateDate", subdata["CreateDate"].ToString() == null ? "" : DateTime.Parse(subdata["CreateDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss")); //进件时间 var userInfo = UsersService.Query(MerchantInfoService.Query(MerchantId).UserId); curData.Add("MakerCode", userInfo.MakerCode); //所属创客编号 curData.Add("RealName", userInfo.RealName); //所属创客姓名 //商户状态 var MerStatus = 0; if (status == 0 && queryCount == 0) MerStatus = 0; //待审核 if (status == -1 || queryCount == -1) MerStatus = -1; //审核失败 if (status == 1 || queryCount == 1) MerStatus = 1; //待签约 if (status == 2 && queryCount == 2) MerStatus = 1; //已通过 curData.Add("Status", MerStatus); //商户状态 //审核平台 var AuditInfo = 1; if (status == -1 && queryCount >= 1) AuditInfo = 2; if (status >= 1 && queryCount == -1) AuditInfo = 1; curData.Add("AuditInfo", AuditInfo); //审核平台(1 支付宝 2 微信) dataList.Add(curData); } Other.Add("Count", count); //总数 return dataList; } #endregion #region 进件管理-直连查看失败原因 [Authorize] public JsonResult DirectQueryFailReason(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Obj = DirectQueryFailReasonDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj }); } private Dictionary DirectQueryFailReasonDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantId = data["MerchantId"].ToString(); //商户Id Dictionary Obj = new Dictionary(); MerchantAddInfo query = new MerchantAddInfo(); query = MerchantAddInfoService.Query(int.Parse(MerchantId)); var info = ""; if (query.Status == -1) { info += "微信:" + query.WeChatRemark + "\n"; } if (query.QueryCount == -1) { info += "支付宝:" + query.AlipayRemark + "\n"; } Obj.Add("Info", info); //失败原因 return Obj; } #endregion #region 进件管理-直连进件详情 [Authorize] public JsonResult DirectDetail(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Obj = DirectDetailDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj }); } private Dictionary DirectDetailDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantId = data["MerchantId"].ToString(); //商户Id Dictionary Obj = new Dictionary(); Obj = MerchantAddInfoUtil.MerchantAddInfoDetail(int.Parse(MerchantId)); return Obj; } #endregion #region 进件管理-直连提交进件 [Authorize] public JsonResult DirectSubmit(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); AppResultJson result = DirectSubmitDo(value); return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data }); } private AppResultJson DirectSubmitDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantId = data["MerchantId"].ToString(); //商户Id var info = MerchantAddInfoUtil.DirectSubmitDo(int.Parse(MerchantId)); if (info == "success") { return new AppResultJson() { Status = "1", Info = "成功", Data = info }; } else { return new AppResultJson() { Status = "-1", Info = "失败", Data = info }; } } #endregion #region 商户管理-直连查询商户交易信息 [Authorize] public JsonResult DirectQueryMerchantTradeInfo(string value) { value = PublicFunction.DesDecrypt(value); ; JsonData data = JsonMapper.ToObject(value); Dictionary Other = new Dictionary(); List> dataList = DirectQueryMerchantTradeInfoDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } private List> DirectQueryMerchantTradeInfoDo(string value, out Dictionary Other) { JsonData data = JsonMapper.ToObject(value); string MerchantName = data["MerchantName"].ToString(); //商户名称 string Mobile = data["Mobile"].ToString(); //手机号码 string MakerCode = data["MakerCode"].ToString(); //所属创客 string MatchNo = data["MatchNo"].ToString(); //商户号 string AliPID = data["AliPID"].ToString(); //支付宝PID string WeChatNo = data["WeChatNo"].ToString(); //微信商户号 string SubjectType = data["SubjectType"].ToString(); //主体类型(1 企业 2 个体) int pageSize = int.Parse(function.CheckInt(data["page_size"].ToString())); int pageNum = int.Parse(function.CheckInt(data["page_num"].ToString())); string condition = ""; var merIds = MerchantInfoUtil.QuerySenedMerchantId(); condition = " and Id in (" + merIds + ")"; if (!string.IsNullOrEmpty(MerchantName)) { condition += " and CertMerchantName='" + MerchantName + "'"; } if (!string.IsNullOrEmpty(Mobile)) { condition += " and MobilePhone='" + Mobile + "'"; } if (!string.IsNullOrEmpty(MakerCode)) { var Ids = MerchantInfoUtil.QueryMerchantIdByMakerCode(MakerCode); condition += " and Id in (" + Ids + ")"; } if (!string.IsNullOrEmpty(AliPID)) { condition += " and AlipayPid='" + AliPID + "'"; } if (!string.IsNullOrEmpty(WeChatNo)) { condition += " and SubMchid='" + WeChatNo + "'"; } if (!string.IsNullOrEmpty(SubjectType)) { if (SubjectType == "1") SubjectType = "SUBJECT_TYPE_ENTERPRISE"; //企业公司 if (SubjectType == "2") SubjectType = "SUBJECT_TYPE_INDIVIDUAL"; //个体工商户 condition += " and SubjectType='" + SubjectType + "'"; } List relationData = new List(); List> dataList = new List>(); Other = new Dictionary(); int count = 0; List> source = MerchantAddInfoService.List(relationData, condition, out count, pageNum, pageSize); foreach (Dictionary subdata in source) { Dictionary curData = new Dictionary(); //商户Id var MerchantId = int.Parse(subdata["Id"].ToString()); curData.Add("MerchantId", subdata["Id"].ToString()); //商户Id curData.Add("MerchantName", subdata["CertMerchantName"].ToString()); //商户名称 curData.Add("Mobile", subdata["MobilePhone"].ToString()); //手机号码 curData.Add("MakerCode", UsersService.Query(MerchantInfoService.Query(MerchantId).UserId).MakerCode); //所属创客 var subjectType = 0; if (subdata["SubjectType"].ToString() == "SUBJECT_TYPE_ENTERPRISE") subjectType = 1; //企业公司 if (subdata["SubjectType"].ToString() == "SUBJECT_TYPE_INDIVIDUAL") subjectType = 2; //个体工商户 curData.Add("AliPID", subdata["AlipayPid"].ToString()); //支付宝PID curData.Add("WeChatNo", subdata["SubMchid"].ToString()); //微信商户号 curData.Add("SubjectType", subjectType); //主体类型(1 企业 2 个体 3 小微) curData.Add("MatchNo", subdata["MchtNo"].ToString()); //商户号 curData.Add("OrderCount", ConsumerOrdersService.Count(" and Status>0 and MerchantId=" + MerchantId + "")); //订单总数 curData.Add("InComeAmount", ConsumerOrdersService.Sum(" and Status>0 and MerchantId=" + MerchantId + "", "MerchantActualAmount")); //实收总金额 curData.Add("TradeAmount", ConsumerOrdersService.Sum(" and Status>0 and MerchantId=" + MerchantId + "", "PayMoney")); //营业总金额 dataList.Add(curData); } Other.Add("Count", count); //总数 return dataList; #endregion } #region 商户管理-直连添加支付宝PID和微信商户号 [Authorize] public JsonResult DirectAddPIDOrWeChatNo(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); AppResultJson result = DirectAddPIDOrWeChatNoDo(value); return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data }); } private AppResultJson DirectAddPIDOrWeChatNoDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantId = data["MerchantId"].ToString(); //商户Id string AliPPID = data["AliPPID"].ToString(); //支付宝PID string WeChatNo = data["WeChatNo"].ToString(); //微信商户号 Dictionary Obj = new Dictionary(); var query = MerchantAddInfoService.Query(int.Parse(MerchantId)); Dictionary fields = new Dictionary(); if (query.Id > 0) { if (!string.IsNullOrEmpty(query.AlipayPid)) { fields.Add("AlipayPid", AliPPID); //支付宝PID } if (!string.IsNullOrEmpty(query.SubMchid)) { fields.Add("SubMchid", WeChatNo); //微信商户号 } } AppResultJson resultJson = MerchantAddInfoService.Edit(fields, int.Parse(MerchantId)); return new AppResultJson() { Status = "1", Info = "添加成功", Data = Obj }; } #endregion } }