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.Main2; using MySystem.Service.Main2; using LitJson; using Library; using MySystem.Service.KxsMain; namespace MySystem.Areas.Api.Controllers.v1.Main2 { [Area("Api")] [Route("/v1/QrCodePlateMain/[controller]/[action]")] public class MerchantAddInfoController : BaseController { public MerchantAddInfoController(IHttpContextAccessor accessor) : base(accessor) { } #region 进件管理-银联商户列表 [Authorize] public JsonResult UnionPayList(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Other = new Dictionary(); List> dataList = UnionPayListDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } private List> UnionPayListDo(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 HDStatus = data["HDStatus"].ToString(); //好哒状态(-1 审核失败 0 待审核 3 已通过) string WeChatStatus = data["WeChatStatus"].ToString(); //微信状态(-1 审核失败 0 待审核 1 待签约 2 已通过) string AliPayStatus = data["AliPayStatus"].ToString(); //支付宝状态(-1 审核失败 0 待审核 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(data["SubjectType"].ToString())) { if (data["SubjectType"].ToString() == "1") SubjectType = "SUBJECT_TYPE_ENTERPRISE"; //企业公司 if (data["SubjectType"].ToString() == "2") SubjectType = "SUBJECT_TYPE_INDIVIDUAL"; //个体工商户 if (data["SubjectType"].ToString() == "3") SubjectType = "SUBJECT_TYPE_SMALL"; //小微商户 condition += " and SubjectType='" + SubjectType + "'"; } if (!string.IsNullOrEmpty(data["CertMerchantName"].ToString())) { condition += " and CertMerchantName like '%" + 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["HDStatus"].ToString())) { if (int.Parse(HDStatus) == 3) { condition += " and HdStatus in(1,2,3)"; } else { condition += " and Status=" + HDStatus + ""; } } if (!string.IsNullOrEmpty(data["WeChatStatus"].ToString())) { condition += " and Status=" + WeChatStatus + ""; } if (!string.IsNullOrEmpty(data["AliPayStatus"].ToString())) { condition += " and QueryCount=" + AliPayStatus + ""; } 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 hdStatus = int.Parse(subdata["HdStatus"].ToString()); var status = int.Parse(subdata["Status"].ToString()); var queryCount = int.Parse(subdata["QueryCount"].ToString()); if (hdStatus != 3) { hdStatus = status; } //商户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; //个体工商户 if (subdata["SubjectType"].ToString() == "SUBJECT_TYPE_SMALL") subjectType = 3; //小微商户 curData.Add("Id", subdata["Id"].ToString()); //Id curData.Add("SubjectType", subjectType); //主体类型(1 企业 2 个体 3 小微) curData.Add("CertMerchantName", subdata["CertMerchantName"].ToString()); //商户名称 curData.Add("ServicePhone", subdata["ServicePhone"].ToString()); //客服电话 curData.Add("BizStoreAddress", subdata["BizStoreAddress"].ToString()); //门店地址 curData.Add("CreateDate", subdata["CreateDate"].ToString() == "" ? "" : 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); //所属创客姓名 curData.Add("HDStatus", hdStatus); //好哒状态(-1 审核失败 0 待审核 3 已通过) curData.Add("WeChatStatus", status); //微信状态(-1 审核失败 0 待审核 1 待签约 2 已通过) curData.Add("AliPayStatus", queryCount); //支付宝状态(-1 审核失败 0 待审核 1 待签约 2 已通过) dataList.Add(curData); } Other.Add("Count", count); //总数 return dataList; } #endregion #region 进件管理-银联查看失败原因 [Authorize] public JsonResult UnionPayQueryFailReason(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Obj = UnionPayQueryFailReasonDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj }); } private Dictionary UnionPayQueryFailReasonDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantId = data["MerchantId"].ToString(); //商户Id Dictionary Obj = new Dictionary(); var query = MerchantAddInfoService.Query(int.Parse(MerchantId)); Obj.Add("HdReason", query.WeChatRemark); //好哒原因 Obj.Add("WeChatReason", query.WeChatRemark); //微信原因 Obj.Add("AlipayReason", query.AlipayRemark); //支付宝原因 return Obj; } #endregion #region 进件管理-银联进件详情 [Authorize] public JsonResult UnionPayDetail(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Obj = UnionPayDetailDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj }); } private Dictionary UnionPayDetailDo(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 UnionPaySubmit(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); AppResultJson result = UnionPaySubmitDo(value); return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data }); } private AppResultJson UnionPaySubmitDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantId = data["MerchantId"].ToString(); //商户Id var info = MerchantAddInfoUtil.UnionPaySubmitDo(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 UnionPayQueryMerchantTradeInfo(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Other = new Dictionary(); List> dataList = UnionPayQueryMerchantTradeInfoDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } private List> UnionPayQueryMerchantTradeInfoDo(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 SubjectType = data["SubjectType"].ToString(); //主体类型(1 企业 2 个体 3 小微) string IsAct = data["IsAct"].ToString(); //激活状态(0 未激活 1 已激活) string ActDate = data["ActDate"].ToString(); //激活时间 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.QueryAnyIsOkMerchantId(); condition = " and Id in (" + merIds + ")"; if (!string.IsNullOrEmpty(MerchantName)) { condition += " and CertMerchantName like '%" + 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(MatchNo)) { condition += " and MchtNo='" + MatchNo + "'"; } if (!string.IsNullOrEmpty(SubjectType)) { if (SubjectType == "1") SubjectType = "SUBJECT_TYPE_ENTERPRISE"; //企业公司 if (SubjectType == "2") SubjectType = "SUBJECT_TYPE_INDIVIDUAL"; //个体工商户 if (SubjectType == "3") SubjectType = "SUBJECT_TYPE_SMALL"; //小微 condition += " and SubjectType='" + SubjectType + "'"; } if (!string.IsNullOrEmpty(IsAct)) { var Ids = MerchantInfoUtil.QueryIsActMerchantId(int.Parse(IsAct)); condition += " and Id in (" + Ids + ")"; } if (!string.IsNullOrEmpty(data["ActDate"].ToString())) { string[] datelist = ActDate.Split(new string[] { " - " }, StringSplitOptions.None); string start = datelist[0]; string end = datelist[1]; var Ids = MerchantInfoUtil.QueryActDateMerchantId(start, end); condition += " and Id in (" + Ids + ")"; } 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()); var merInfo = MerchantInfoService.Query(MerchantId); var userInfo = UsersService.Query(merInfo.UserId); curData.Add("MerchantId", subdata["Id"].ToString()); //商户Id curData.Add("IsAct", merInfo.IsAct); //激活状态(0 未激活 1 已激活) var actDate = ""; var order = MerchantDepositOrderService.Query(" and Status>0 and MerchantId=" + MerchantId + ""); if (order.Id > 0) { actDate = order.UpdateDate.Value.ToString("yyyy-MM-dd HH:mm:ss"); } curData.Add("ActDate", actDate); //激活时间 curData.Add("MerchantName", subdata["CertMerchantName"].ToString()); //商户名称 curData.Add("Mobile", subdata["MobilePhone"].ToString()); //手机号码 curData.Add("MakerCode", userInfo.MakerCode); //所属创客 curData.Add("RealName", userInfo.RealName); //所属创客姓名 var subjectType = 0; if (subdata["SubjectType"].ToString() == "SUBJECT_TYPE_ENTERPRISE") subjectType = 1; //企业公司 if (subdata["SubjectType"].ToString() == "SUBJECT_TYPE_INDIVIDUAL") subjectType = 2; //个体工商户 if (subdata["SubjectType"].ToString() == "SUBJECT_TYPE_SMALL") subjectType = 3; //小微 curData.Add("SubjectType", subjectType); //主体类型(1 企业 2 个体 3 小微) curData.Add("MatchNo", subdata["MchtNo"].ToString()); //商户号 var amountInfo = MerchantAmountSummayService.Sum("TradeCount,TotalActual,TradeAmount", " and MerchantId=" + MerchantId + ""); curData.Add("OrderCount", decimal.Parse(amountInfo["TradeCount"].ToString())); //订单总数 curData.Add("InComeAmount", decimal.Parse(amountInfo["TotalActual"].ToString()).ToString("f2")); //实收总金额 curData.Add("TradeAmount", decimal.Parse(amountInfo["TradeAmount"].ToString()).ToString("f2")); //营业总金额 dataList.Add(curData); } Other.Add("Count", count); //总数 return dataList; } #endregion #region 进件管理-银联修改商户名称 [Authorize] public JsonResult UnionPayEditMerchantName(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); AppResultJson result = UnionPayEditMerchantNameDo(value); return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data }); } private AppResultJson UnionPayEditMerchantNameDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantId = data["MerchantId"].ToString(); //商户Id string MerchantName = data["MerchantName"].ToString(); //新商户名称 string MerchantShortName = data["MerchantShortName"].ToString(); //新商户简称 Dictionary Obj = new Dictionary(); var Id = int.Parse(MerchantId); var query = main2db.MerchantAddInfo.FirstOrDefault(m => m.Id == Id) ?? new MerchantAddInfo(); var merInfo = main2db.MerchantInfo.FirstOrDefault(m => m.Id == Id) ?? new MerchantInfo(); Dictionary fields = new Dictionary(); if (query.Id > 0) { if (string.IsNullOrEmpty(MerchantName)) { query.CertMerchantName = MerchantName; merInfo.Name = MerchantName; } if (!string.IsNullOrEmpty(MerchantShortName)) { fields.Add("MerchantShortname", MerchantShortName); } } main2db.SaveChanges(); return new AppResultJson() { Status = "1", Info = "", Data = Obj }; } #endregion #region 商户管理-银联查询商户交易信息导出 [Authorize] public JsonResult ExportUnionPayQueryMerchantTradeInfo(string value) { value = PublicFunction.DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); AppResultJson result = ExportUnionPayQueryMerchantTradeInfoDo(value); return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data }); } private AppResultJson ExportUnionPayQueryMerchantTradeInfoDo(string value) { 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 SubjectType = data["SubjectType"].ToString(); //主体类型(1 企业 2 个体 3 小微) string IsAct = data["IsAct"].ToString(); //激活状态(0 未激活 1 已激活) string ActDate = data["ActDate"].ToString(); //激活时间 string condition = ""; var merIds = MerchantInfoUtil.QueryAnyIsOkMerchantId(); condition = " and Id in (" + merIds + ")"; if (!string.IsNullOrEmpty(MerchantName)) { condition += " and CertMerchantName like '%" + 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(MatchNo)) { condition += " and MchtNo='" + MatchNo + "'"; } if (!string.IsNullOrEmpty(SubjectType)) { if (SubjectType == "1") SubjectType = "SUBJECT_TYPE_ENTERPRISE"; //企业公司 if (SubjectType == "2") SubjectType = "SUBJECT_TYPE_INDIVIDUAL"; //个体工商户 if (SubjectType == "3") SubjectType = "SUBJECT_TYPE_SMALL"; //小微 condition += " and SubjectType='" + SubjectType + "'"; } if (!string.IsNullOrEmpty(IsAct)) { var Ids = MerchantInfoUtil.QueryIsActMerchantId(int.Parse(IsAct)); condition += " and Id in (" + Ids + ")"; } if (!string.IsNullOrEmpty(data["ActDate"].ToString())) { string[] datelist = ActDate.Split(new string[] { " - " }, StringSplitOptions.None); string start = datelist[0]; string end = datelist[1]; var Ids = MerchantInfoUtil.QueryActDateMerchantId(start, end); condition += " and Id in (" + Ids + ")"; } Dictionary Obj = new Dictionary(); var Sql = "SELECT a.Id '商户Id',(CASE WHEN b.IsAct=0 THEN '未激活' WHEN b.IsAct=1 THEN '已激活' ELSE '' end) '激活状态',c.UpdateDate '激活时间',a.CertMerchantName '商户名称',a.MobilePhone '手机号码',b.UserId '所属创客Id',(CASE WHEN a.SubjectType='SUBJECT_TYPE_ENTERPRISE' THEN '企业公司' WHEN a.SubjectType='SUBJECT_TYPE_INDIVIDUAL' THEN '个体工商户' WHEN a.SubjectType='SUBJECT_TYPE_SMALL' THEN '小微' ELSE '' end) '主体类型',a.MchtNo '商户号',(SELECT SUM(TradeCount) TradeCount FROM MerchantAmountSummay WHERE 1=1 AND MerchantId=a.Id) '订单总数',(SELECT SUM(TotalActual) TotalActual FROM MerchantAmountSummay WHERE 1=1 AND MerchantId=a.Id)' 实收总金额',(SELECT SUM(TradeAmount) TradeAmount FROM MerchantAmountSummay WHERE 1=1 AND MerchantId=a.Id) '营业总金额' FROM(SELECT Id,CertMerchantName,MobilePhone,MchtNo,SubjectType FROM MerchantAddInfo WHERE 1=1 " + condition + " AND (Status=2 or QueryCount=2)) a LEFT JOIN (SELECT Id,IsAct,UserId FROM MerchantInfo WHERE 1=1 AND Status=2 or QueryCount=2) b ON a.Id=b.Id LEFT JOIN (SELECT MerchantId,UpdateDate FROM MerchantDepositOrder WHERE `Status`>0)c ON a.Id=c.MerchantId"; var FileName = "商户管理-银联查询商户交易信息" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string SendData = "{\"Operater\":\"" + AppConfig.LoginSession.sysId + "\",\"SqlString\":\"" + Sql + "\",\"FileName\":\"" + FileName + "\",\"MaxCount\":\"0\"}"; RedisDbconn.Instance.AddList("ExportQueue", SendData); return new AppResultJson() { Status = "1", Info = "", Data = Obj }; } #endregion #region 银联结算管理-银联结算记录 [Authorize] public JsonResult UnionPaySettlementRecordList(string value) { value = PublicFunction.DesDecrypt(value); ; JsonData data = JsonMapper.ToObject(value); List> dataList = UnionPaySettlementRecordListDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } private List> UnionPaySettlementRecordListDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantName = data["MerchantName"].ToString(); //商户名称 string MerchantNo = data["MerchantNo"].ToString(); //商户号 string SettlementDate = data["SettlementDate"].ToString(); //结算时间(必填) string pageSize = data["page_size"].ToString(); string pageNum = data["page_num"].ToString(); var MerchantId = 0; string StartDate = ""; string EndDate = ""; if (!string.IsNullOrEmpty(data["MerchantName"].ToString())) { var merAddInfo = MerchantAddInfoService.Query(" and CertMerchantName='" + MerchantName + "'"); MerchantId = merAddInfo.Id; } if (!string.IsNullOrEmpty(data["MerchantNo"].ToString())) { var merAddInfo = MerchantAddInfoService.Query(" and OutMchtNo='" + MerchantNo + "'"); MerchantId = merAddInfo.Id; } if (!string.IsNullOrEmpty(data["SettlementDate"].ToString())) { string[] datelist = SettlementDate.Split(new string[] { " - " }, StringSplitOptions.None); StartDate = datelist[0]; EndDate = datelist[1]; } var dataList = MySelfUtil.CardInComeRecordList(MerchantId, StartDate, EndDate, pageSize, pageNum); return dataList; } #endregion #region 重置交易额-银联重置商户交易额 [Authorize] public JsonResult UnionPayResetMerchantAmount(string value) { value = PublicFunction.DesDecrypt(value); ; JsonData data = JsonMapper.ToObject(value); AppResultJson result = UnionPayResetMerchantAmountDo(value); return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data }); } private AppResultJson UnionPayResetMerchantAmountDo(string value) { JsonData data = JsonMapper.ToObject(value); string MerchantId = data["MerchantId"].ToString(); //商户Id string TradeDate = data["TradeDate"].ToString(); //交易时间 if (string.IsNullOrEmpty(data["MerchantId"].ToString()) || string.IsNullOrEmpty(data["TradeDate"].ToString())) { return new AppResultJson() { Status = "-1", Info = "商户Id和交易时间不能为空" }; } string[] datelist = TradeDate.Split(new string[] { " - " }, StringSplitOptions.None); string start = DateTime.Parse(datelist[0]).ToString("yyyyMMdd"); string end = DateTime.Parse(datelist[1]).ToString("yyyyMMdd"); string info = "{\"MerchantId\":\"" + MerchantId + "\",\"StartDate\":\"" + start + "\",\"EndDate\": \"" + end + "\"}"; RedisDbconn.Instance.AddList("ResetMerchantStatDataQueue2", info); Dictionary Obj = new Dictionary(); return new AppResultJson() { Status = "1", Info = "成功", Data = Obj }; } #endregion } }