public void ProcessRequest(HttpContext context) { try { //接收回调xml信息 byte[] byts = new byte[context.Request.InputStream.Length]; context.Request.InputStream.Read(byts, 0, byts.Length); string req = Encoding.UTF8.GetString(byts); PubInfo.GetLog().Info("鸿坤京东收款通接收内容:" + req); if (string.IsNullOrEmpty(req)) { throw new Exception("接口未获取到任何数据"); } //初步解析接收内容,获取到商家编号 var res = XMLUtil.decryptResXmlNew <JdPayResponse>(req); //根据商家编号获取配置信息 WxPayConfig payConfig = GenerateConfig(res.merchant); if (payConfig == null) { throw new Exception("根据商家编号没有找到配置信息"); } //根据配置的密钥进行解析数据 AsynNotifyResponse anyResponse = XMLUtil.decryptResXml <AsynNotifyResponse>(payConfig.APPID, payConfig.KEY, req); //判断订单是否成过 if ("success".Equals(anyResponse.result.desc)) { DateTime DateNow = DateTime.Now; string orderId = anyResponse.tradeNum; string amt = anyResponse.amount.ToString(); // 通过OrderID订单号查询对应订单 using (IDbConnection conn = new SqlConnection(PubConstant.UnifiedContionString)) { dynamic OrderInfo = conn.QueryFirstOrDefault("SELECT * FROM Tb_CCBPay_Order WHERE OrderSN = @OrderSN", new { OrderSN = orderId }); if (null == OrderInfo) { PubInfo.GetLog().Info("鸿坤京东收款通知内容:订单不存在"); return; } if (3 == Convert.ToInt32(OrderInfo.IsSucc)) { PubInfo.GetLog().Info("鸿坤京东收款通知内容:订单已下账"); return; } // 获取支付配置信息 dynamic PayConfig = conn.QueryFirstOrDefault("SELECT * FROM Tb_JDPay_Config WHERE Id = @Id", new { Id = OrderInfo.PayConfigNewId }); if (null == PayConfig) { PubInfo.GetLog().Info("鸿坤京东收款通知内容:支付配置不存在"); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, null, 0, req, 2, "支付配置不存在"); return; } // 获取小区信息 Tb_Community tb_Community = PubInfo.GetCommunity(Convert.ToString(PayConfig.CommunityId)); if (null == tb_Community) { PubInfo.GetLog().Info("鸿坤京东收款通知内容:小区配置不存在"); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, null, 0, req, 2, "小区配置不存在"); return; } decimal SAmt = Convert.ToDecimal(amt) / 100; // 判断金额是否一致 if (Convert.ToDecimal(OrderInfo.Amt) != SAmt) { PubInfo.GetLog().InfoFormat("鸿坤京东收款通知内容:账单金额与实收金额不一致(SAmt={0})", SAmt); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, null, 0, req, 2, "账单金额与实收金额不一致"); return; } string erpConnStr = PubInfo.GetConnectionStr(tb_Community); JObject PayData = JsonConvert.DeserializeObject <JObject>(Convert.ToString(OrderInfo.PayData)); int Type = (int)PayData["Type"]; if (Type == 1) { JArray Data = (JArray)PayData["Data"]; if (null == Data || Data.Count == 0) { PubInfo.GetLog().InfoFormat("鸿坤京东收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, req, 2, "下账失败(订单支付信息有误)"); return; } StringBuilder FeesIds = new StringBuilder(); foreach (JObject item in Data) { FeesIds.Append((string)item["FeesId"] + ","); } if (PubInfo.ReceFees(erpConnStr, out long ReceID, Convert.ToString(tb_Community.CommID), Convert.ToString(OrderInfo.CustID), Convert.ToString(OrderInfo.RoomID), FeesIds.ToString(), 0.00M, "自助缴费-京东")) { PubInfo.GetLog().InfoFormat("鸿坤京东收款通知内容:下账成功(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString().ToString(), SAmt, req, 3, "下账成功"); return; } else { PubInfo.GetLog().InfoFormat("鸿坤京东收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString().ToString(), SAmt, req, 4, "下账失败"); return; } } else if (Type == 2) { JObject Data = (JObject)PayData["Data"]; if (null == Data) { PubInfo.GetLog().InfoFormat("鸿坤京东收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, req, 2, "支付金额必须大于0"); return; } string CostID = (string)Data["CostID"]; decimal Amt = (Decimal)Data["Amt"]; if (PubInfo.RecePreFees(erpConnStr, out long ReceID, Convert.ToString(tb_Community.CommID), Convert.ToString(OrderInfo.CustID), Convert.ToString(OrderInfo.RoomID), CostID, Amt, "自助缴费-京东")) { PubInfo.GetLog().InfoFormat("鸿坤京东收款通知内容:下账成功(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, req, 3, "下账成功"); return; } else { PubInfo.GetLog().InfoFormat("鸿坤京东收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, req, 4, "下账失败"); return; } } else { PubInfo.GetLog().InfoFormat("鸿坤京东收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, req, 2, "下账失败(订单支付信息有误)"); return; } }
public void ProcessRequest(HttpContext context) { try { DateTime DateNow = DateTime.Now; List <string> list = new List <string>(); foreach (var item in context.Request.Params.AllKeys) { list.Add($"{item}={context.Request.Params[item]}"); } Business.Alipay.Log("收到微信通知" + context.Request.RawUrl + "?" + string.Join("&", list)); HttpRequest Request = context.Request; context.Response.ContentType = "text/plain"; string respcode = ""; string respmsg = ""; string orderId = ""; //string CommunityId = ""; string amt = ""; //返回报文中不包含UPOG,表示Server端正确接收交易请求,则需要验证Server端返回报文的签名 bool IsValidate = false; WxPayData WxPostData = new WxPayData(); string Result = Notify.NotifyDataFromContext(context, ref IsValidate, ref WxPostData); respcode = WxPostData.GetValue("result_code").ToString(); respmsg = WxPostData.GetValue("result_code").ToString(); orderId = WxPostData.GetValue("out_trade_no").ToString(); //CommunityId = WxPostData.GetValue("attach").ToString(); amt = WxPostData.GetValue("total_fee").ToString(); //string userId = null; //if (CommunityId.Contains(",")) //{ // userId = CommunityId.Split(',')[1]; // CommunityId = CommunityId.Split(',')[0]; //} if (IsValidate == false) { //Business.WeiXinPay.Log("验签失败:" + CommunityId + "," + orderId.ToString()); Business.WeiXinPay.Log("验签失败:" + orderId.ToString()); Result = SetNotifyResult("FAIL", Result); context.Response.Write(Result); return; } Business.WeiXinPay.Log("微信支付验签成功:" + orderId.ToString()); if (IsValidate == true) { // 通过OrderID订单号查询对应订单 using (IDbConnection conn = new SqlConnection(PubConstant.UnifiedContionString)) { dynamic OrderInfo = conn.QueryFirstOrDefault("SELECT * FROM Tb_CCBPay_Order WHERE OrderSN = @OrderSN", new { OrderSN = orderId }); if (null == OrderInfo) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:订单不存在"); return; } if (3 == Convert.ToInt32(OrderInfo.IsSucc)) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:订单已下账"); return; } // 获取支付配置信息 dynamic PayConfig = conn.QueryFirstOrDefault("SELECT * FROM Tb_WeiXinPay_Config WHERE Id = @Id", new { Id = OrderInfo.PayConfigNewId }); if (null == PayConfig) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:支付配置不存在"); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, null, 0, JsonConvert.SerializeObject(WxPostData), 2, "支付配置不存在"); return; } // 获取小区信息 Tb_Community tb_Community = PubInfo.GetCommunity(Convert.ToString(PayConfig.CommunityId)); if (null == tb_Community) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:小区配置不存在"); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, null, 0, JsonConvert.SerializeObject(WxPostData), 2, "小区配置不存在"); return; } decimal SAmt = Convert.ToDecimal(amt) / 100; // 判断金额是否一致 if (Convert.ToDecimal(OrderInfo.Amt) != SAmt) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:账单金额与实收金额不一致(SAmt={0})", SAmt); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, null, 0, JsonConvert.SerializeObject(WxPostData), 2, "账单金额与实收金额不一致"); return; } string erpConnStr = PubInfo.GetConnectionStr(tb_Community); JObject PayData = JsonConvert.DeserializeObject <JObject>(Convert.ToString(OrderInfo.PayData)); int Type = (int)PayData["Type"]; if (Type == 1) { JArray Data = (JArray)PayData["Data"]; if (null == Data || Data.Count == 0) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, JsonConvert.SerializeObject(WxPostData), 2, "下账失败(订单支付信息有误)"); return; } StringBuilder FeesIds = new StringBuilder(); foreach (JObject item in Data) { FeesIds.Append((string)item["FeesId"] + ","); } if (PubInfo.ReceFees(erpConnStr, out long ReceID, Convert.ToString(tb_Community.CommID), Convert.ToString(OrderInfo.CustID), Convert.ToString(OrderInfo.RoomID), FeesIds.ToString(), 0.00M, "自助缴费-微信")) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账成功(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString().ToString(), SAmt, JsonConvert.SerializeObject(WxPostData), 3, "下账成功"); return; } else { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString().ToString(), SAmt, JsonConvert.SerializeObject(WxPostData), 4, "下账失败"); return; } } else if (Type == 2) { JObject Data = (JObject)PayData["Data"]; if (null == Data) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, JsonConvert.SerializeObject(WxPostData), 2, "支付金额必须大于0"); return; } string CostID = (string)Data["CostID"]; decimal Amt = (Decimal)Data["Amt"]; if (PubInfo.RecePreFees(erpConnStr, out long ReceID, Convert.ToString(tb_Community.CommID), Convert.ToString(OrderInfo.CustID), Convert.ToString(OrderInfo.RoomID), CostID, Amt, "自助缴费-微信")) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账成功(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, JsonConvert.SerializeObject(WxPostData), 3, "下账成功"); return; } else { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, JsonConvert.SerializeObject(WxPostData), 4, "下账失败"); return; } } else { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, orderId, DateNow.ToString(), SAmt, JsonConvert.SerializeObject(WxPostData), 2, "下账失败(订单支付信息有误)"); return; } }
public void ProcessRequest(HttpContext context) { HttpRequest Request = context.Request; HttpResponse Response = context.Response; Response.ContentType = "text/plain"; DateTime DateNow = DateTime.Now; try { if (!"POST".Equals(Request.HttpMethod.ToUpper())) { PubInfo.GetLog().Info("不是鸿坤建行收款通知"); return; } Dictionary <string, string> param = new Dictionary <string, string>(); foreach (var item in Request.QueryString.AllKeys) { param.Add(item, Request.QueryString[item]); } PubInfo.GetLog().Info("收到鸿坤建行收款通知:" + JsonConvert.SerializeObject(param)); if (!"Y".Equals(param["SUCCESS"].ToUpper())) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:交易状态不是成功状态"); return; } // 通过OrderID订单号查询对应订单 using (IDbConnection conn = new SqlConnection(PubConstant.UnifiedContionString)) { dynamic OrderInfo = conn.QueryFirstOrDefault("SELECT * FROM Tb_CCBPay_Order WHERE OrderSN = @OrderSN", new { OrderSN = param["ORDERID"] }); if (null == OrderInfo) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:订单不存在"); return; } if (3 == Convert.ToInt32(OrderInfo.IsSucc)) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:订单已下账"); return; } // 获取支付配置信息 dynamic PayConfig = conn.QueryFirstOrDefault("SELECT * FROM Tb_CCBPay_Config WHERE Id = @Id", new { Id = OrderInfo.PayConfigId }); if (null == PayConfig) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:支付配置不存在"); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], null, 0, JsonConvert.SerializeObject(param), 2, "支付配置不存在"); return; } #region 需要进行验签 Dictionary <string, string> tempDic = new Dictionary <string, string>(param); tempDic.Remove("SIGN"); string initStr = ""; foreach (var item in tempDic) { initStr += string.Format("{0}={1}&", item.Key, item.Value); } initStr = initStr.Trim('&'); string sign = param["SIGN"]; string pubKey = Convert.ToString(PayConfig.Pub); if (!Business.HKCCBPay.VerifySign(initStr, sign, pubKey)) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:签名校验失败"); return; } #endregion // 获取小区信息 Tb_Community tb_Community = PubInfo.GetCommunity(Convert.ToString(PayConfig.CommunityId)); if (null == tb_Community) { PubInfo.GetLog().Info("鸿坤建行收款通知内容:小区配置不存在"); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], null, 0, JsonConvert.SerializeObject(param), 2, "小区配置不存在"); return; } decimal SAmt = Convert.ToDecimal(param["PAYMENT"]); // 判断金额是否一致 if (Convert.ToDecimal(OrderInfo.Amt) != SAmt) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:账单金额与实收金额不一致(SAmt={0})", SAmt); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], null, 0, JsonConvert.SerializeObject(param), 2, "账单金额与实收金额不一致"); return; } string erpConnStr = PubInfo.GetConnectionStr(tb_Community); JObject PayData = JsonConvert.DeserializeObject <JObject>(Convert.ToString(OrderInfo.PayData)); int Type = (int)PayData["Type"]; if (Type == 1) { JArray Data = (JArray)PayData["Data"]; if (null == Data || Data.Count == 0) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], DateNow.ToString(), SAmt, JsonConvert.SerializeObject(param), 2, "下账失败(订单支付信息有误)"); return; } StringBuilder FeesIds = new StringBuilder(); foreach (JObject item in Data) { FeesIds.Append((string)item["FeesId"] + ","); } if (PubInfo.ReceFees(erpConnStr, out long ReceID, Convert.ToString(tb_Community.CommID), Convert.ToString(OrderInfo.CustID), Convert.ToString(OrderInfo.RoomID), FeesIds.ToString(), 0.00M, "自助缴费-微信")) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账成功(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], DateNow.ToString().ToString(), SAmt, JsonConvert.SerializeObject(param), 3, "下账成功"); return; } else { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], DateNow.ToString().ToString(), SAmt, JsonConvert.SerializeObject(param), 4, "下账失败"); return; } } else if (Type == 2) { JObject Data = (JObject)PayData["Data"]; if (null == Data) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], DateNow.ToString(), SAmt, JsonConvert.SerializeObject(param), 2, "支付金额必须大于0"); return; } string CostID = (string)Data["CostID"]; decimal Amt = (Decimal)Data["Amt"]; if (PubInfo.RecePreFees(erpConnStr, out long ReceID, Convert.ToString(tb_Community.CommID), Convert.ToString(OrderInfo.CustID), Convert.ToString(OrderInfo.RoomID), CostID, Amt, "自助缴费-微信")) { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账成功(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], DateNow.ToString(), SAmt, JsonConvert.SerializeObject(param), 3, "下账成功"); return; } else { PubInfo.GetLog().InfoFormat("鸿坤建行收款通知内容:下账失败(订单支付信息有误)(PayData={0})", OrderInfo.PayData); Business.HKCCBPay.UpdateOrderInfo(PubConstant.UnifiedContionString, param["ORDERID"], DateNow.ToString(), SAmt, JsonConvert.SerializeObject(param), 4, "下账失败"); return; } }
/// <summary> /// 计算赠送积分 /// </summary> private void PresentedPoint(string communityId, string orderId, string userId, string useHistoryId, decimal paidAmount) { using (var appConn = new SqlConnection(PubConstant.UnifiedContionString)) { if (appConn.State == ConnectionState.Closed) { appConn.Open(); } var trans = appConn.BeginTransaction(); short corpId = 0; try { decimal propertyMaxDiscountsAmount = 0.0m; // 物管费最大可抵用金额 decimal parkingMaxDiscountsAmount = 0.0m; // 车位费最大可抵用金额 var deductionObject = new List <string>(); // 积分可抵扣对象 using (var erpConn = new SqlConnection(PubInfo.GetConnectionStr(PubInfo.GetCommunity(communityId)))) { var feesIds = erpConn.Query <long>(@"SELECT FeesId FROM Tb_OL_AlipayDetail WHERE PayOrderId= (SELECT Id FROM Tb_OL_AlipayOrder WHERE out_trade_no=@out_trade_no)", new { out_trade_no = orderId }); if (feesIds.Count() == 0) { return; } #region 获取积分抵扣规则 // 企业编号 corpId = appConn.Query <short>("SELECT CorpID FROM Tb_Community WHERE Id=@CommunityId", new { CommunityId = communityId }, trans).FirstOrDefault(); // 积分权限控制 var controlInfo = appConn.Query <Tb_Control_AppPoint>(@"SELECT * FROM Tb_Control_AppPoint WHERE CorpID=@CorpID AND IsEnable=1 AND (CommunityID=@CommunityId OR CommunityID IS NULL) ORDER BY CommunityID DESC", new { CorpID = corpId, CommunityId = communityId }, trans).FirstOrDefault(); if (controlInfo == null || controlInfo.IsEnable == false) { controlInfo = Tb_Control_AppPoint.DefaultControl; controlInfo.CommunityID = Guid.Empty.ToString(); } // 允许抵用物业费 if (controlInfo.AllowDeductionPropertyFees) { deductionObject.Add($@"'{AppPointUsableObjectConverter.GetKey(AppPointUsableObject.PropertyFee)}'"); } // 允许抵用车位费 if (controlInfo.AllowDeductionParkingFees) { deductionObject.Add($@"'{AppPointUsableObjectConverter.GetKey(AppPointUsableObject.ParkingFee)}'"); } #endregion // 不计算违约金 string sql = $@"SELECT isnull(sum(isnull(DebtsAmount,0)),0) FROM view_HSPR_Fees_Filter WHERE FeesID IN({string.Join(",", feesIds)}) AND SysCostSign = 'B0001'; SELECT isnull(sum(isnull(DebtsAmount,0)),0) FROM view_HSPR_Fees_Filter WHERE FeesID IN({string.Join(",", feesIds)}) AND SysCostSign = 'B0002';"; var reader = erpConn.QueryMultiple(sql); // 物业费、车位费实际欠费总额 decimal propertyAmount = reader.Read <decimal>().FirstOrDefault(); decimal parkingAmount = reader.Read <decimal>().FirstOrDefault(); // 积分抵用了部分金额 if (!string.IsNullOrEmpty(useHistoryId)) { // 积分抵用的金额数量 var deductionAmount = appConn.Query <decimal>(@"SELECT isnull(DeductionAmount,0) FROM Tb_App_Point_UseHistory WHERE IID=@IID;", new { IID = useHistoryId }, trans).FirstOrDefault(); // 计算相关抵用的金额 if (deductionAmount != 0) { // 积分抵用规则 var ruleInfo = appConn.Query($@"SELECT IID,ConditionAmount,DiscountsAmount,DeductionObject,b.Remark AS SysCostSign,StartTime,EndTime FROM Tb_App_Point_PropertyDeductionRule a LEFT JOIN Tb_Dictionary_Point_UsableObject b ON a.DeductionObject=b.[Key] WHERE CommunityID=@CommunityId AND DeductionObject IN({string.Join(", ", deductionObject) }) AND getdate() BETWEEN StartTime AND EndTime AND a.IsDelete=0 ORDER BY ConditionAmount,DiscountsAmount", new { CommunityId = communityId }, trans); if (ruleInfo.Count() == 0) { Business.Alipay.Log("支付宝下账:计算赠送积分失败,相关积分抵用规则已被禁用"); return; } // 确定物管费可抵用金额 if (propertyAmount > 0) { string key = AppPointUsableObjectConverter.GetKey(AppPointUsableObject.PropertyFee); foreach (var item in ruleInfo) { if (item.DeductionObject == key && propertyAmount >= item.ConditionAmount) { propertyMaxDiscountsAmount = item.DiscountsAmount; } } } // 确定车位费可抵用金额 if (parkingAmount > 0) { string key = AppPointUsableObjectConverter.GetKey(AppPointUsableObject.ParkingFee); foreach (var item in ruleInfo) { if (item.DeductionObject == key && parkingAmount >= item.ConditionAmount) { parkingMaxDiscountsAmount = item.DiscountsAmount; } } } // 积分数量不正常 if (deductionAmount > (parkingMaxDiscountsAmount + propertyMaxDiscountsAmount)) { Business.Alipay.Log("支付宝下账:计算赠送积分失败,积分实际抵用金额超出可抵用金额"); return; } else { decimal tmp = deductionAmount; // 部分抵扣物业费 if (propertyMaxDiscountsAmount != 0) { if (tmp <= propertyMaxDiscountsAmount) { propertyMaxDiscountsAmount = tmp; tmp = 0; } else { tmp -= propertyMaxDiscountsAmount; } } // 部分抵扣车位费 if (parkingMaxDiscountsAmount != 0 && tmp > 0) { if (tmp <= parkingMaxDiscountsAmount) { parkingMaxDiscountsAmount = tmp; tmp = 0; } else { tmp -= parkingMaxDiscountsAmount; } } if (tmp != 0) { Business.Alipay.Log("支付宝下账:计算赠送积分失败,积分实际抵用金额与可抵用金额不相等,可能是更改了积分抵用规则"); return; } } } } // 计算要赠送的积分数量 new AppPoint().CalcPresentedPointForPropertyFees(communityId, propertyAmount - propertyMaxDiscountsAmount, parkingAmount - parkingMaxDiscountsAmount, out int p1, out int p2); if (p1 == 0 && p2 == 0) { return; } int presentedPoints = p1 + p2; var userPoint = appConn.Query("SELECT * FROM Tb_App_UserPoint WHERE UserID=@UserID", new { UserID = userId }, trans).FirstOrDefault(); int balance = 0; if (userPoint == null) { balance = 0; appConn.Execute(@"INSERT INTO Tb_App_UserPoint(UserID, PointBalance) VALUES(@UserID, @PointBalance)", new { UserID = userId, PointBalance = presentedPoints }, trans); } else { balance = userPoint.PointBalance; appConn.Execute("UPDATE Tb_App_UserPoint SET PointBalance=(PointBalance+@PresentedPoints) WHERE UserID=@UserID", new { PresentedPoints = presentedPoints, UserID = userId }, trans); } // 赠送历史 appConn.Execute(@"INSERT INTO Tb_App_Point_PresentedHistory(UserID, PresentedWay, PresentedPoints, PointBalance, Remark) VALUES(@UserID, @PresentedWay, @PresentedPoints, @PointBalance, @Remark)", new { UserID = userId, PresentedWay = AppPointPresentedWayConverter.GetKey(AppPointPresentedWay.PropertyArrearsPayment), PresentedPoints = presentedPoints, PointBalance = balance + presentedPoints, Remark = AppPointPresentedWayConverter.GetValue(AppPointPresentedWay.PropertyArrearsPayment), }, trans); Business.Alipay.Log("支付宝下账:赠送积分=" + presentedPoints); // 力帆,缴清,额外赠送 if (corpId == 2015) { // 查询CustID、RoomID var custInfo = erpConn.Query(@"SELECT CustID,RoomID FROM Tb_HSPR_Fees WHERE FeesID= (SELECT TOP 1 FeesId FROM Tb_OL_AlipayDetail WHERE PayOrderId IN (SELECT Id FROM Tb_OL_AlipayOrder WHERE out_trade_no=@out_trade_no))", new { out_trade_no = orderId }).FirstOrDefault(); if (custInfo != null && custInfo.CustID != 0 && custInfo.RoomID != 0) { // 无欠费 if (erpConn.Query(@"SELECT * FROM Tb_HSPR_Fees WHERE CustID=@CustID AND RoomID=@RoomID AND isnull(IsCharge,0)=0", new { CustID = custInfo.CustID, RoomID = custInfo.RoomID }).Count() == 0) { int extraPoints = new AppPoint().CalcPresentedPointForPayAll(); if (extraPoints > 0) { presentedPoints += extraPoints; // 赠送积分 appConn.Execute(@"UPDATE Tb_App_UserPoint SET PointBalance=(PointBalance+@PresentedPoints) WHERE UserID=@UserID; INSERT INTO Tb_App_Point_PresentedHistory(UserID, PresentedWay, PresentedPoints, PointBalance, Remark) VALUES(@UserID, @PresentedWay, @PresentedPoints, @PointBalance, @Remark);", new { UserID = userId, PresentedWay = AppPointPresentedWayConverter.GetKey(AppPointPresentedWay.PropertyArrearsPayment), PresentedPoints = extraPoints, PointBalance = balance + presentedPoints, Remark = "物业欠费缴清赠送", }, trans); } } } } } trans.Commit(); } catch (Exception ex) { trans.Rollback(); Business.Alipay.Log("支付宝下账:计算赠送积分异常," + ex.Message + Environment.NewLine + ex.StackTrace); } } }
public string GenerateOrder(DataRow row) { #region 获取基本参数 string CommunityId = string.Empty; if (row.Table.Columns.Contains("CommunityId")) { CommunityId = row["CommunityId"].ToString(); } string RoomID = string.Empty; if (row.Table.Columns.Contains("RoomID")) { RoomID = row["RoomID"].ToString(); } string CustID = string.Empty; if (row.Table.Columns.Contains("CustID")) { CustID = row["CustID"].ToString(); } if (!row.Table.Columns.Contains("PayChannel") || string.IsNullOrEmpty(row["PayChannel"].ToString())) { return(new ApiResult(false, "参数PayChannel有误").toJson()); } var payChannel = row["PayChannel"].ToString(); var payType = 0; if (payChannel.ToLower() == "allinpay_alipay") { payChannel = "A03"; payType = 1; } else if (payChannel.ToLower() == "allinpay_wechatpay") { payChannel = "W06"; payType = 2; } else { return(new ApiResult(false, "参数PayChannel有误").toJson()); } #endregion var community = PubInfo.GetCommunity(CommunityId); if (community == null) { return(JSONHelper.FromString(false, "未查询到小区信息")); } int CommID = AppGlobal.StrToInt(community.CommID); PubConstant.hmWyglConnectionString = PubInfo.GetConnectionStr(community); // 获取对应支付配置 AllinConfig allinConfig; using (IDbConnection erpConn = new SqlConnection(PubConstant.hmWyglConnectionString)) { dynamic tb_Payment_Config = erpConn.QueryFirstOrDefault <dynamic>("SELECT * FROM Tb_Payment_Config WITH(NOLOCK) WHERE CommID = @CommID", new { CommID }); if (null == tb_Payment_Config) { return(new ApiResult(false, "该项目未开通对应支付方式").toJson()); } try { allinConfig = JsonConvert.DeserializeObject <AllinConfig>(tb_Payment_Config.Config); if (null == allinConfig) { return(new ApiResult(false, "该项目支付类型对应配置有误").toJson()); } } catch (Exception) { return(new ApiResult(false, "该项目支付类型对应配置有误").toJson()); } #region 计算金额 if (!row.Table.Columns.Contains("PayData") || string.IsNullOrEmpty(row["PayData"].ToString())) { return(new ApiResult(false, "缺少参数PayData").toJson()); } string PayData = row["PayData"].ToString(); if (!PubInfo.CheckPayData(Global_Fun.BurstConnectionString(CommID, Global_Fun.BURST_TYPE_CHARGE), Convert.ToInt64(CustID), Convert.ToInt64(RoomID), PayData, out decimal Amt, out string errMsg, true, false, !"1940".Equals(Global_Var.LoginCorpID))) { return(new ApiResult(false, errMsg).toJson()); } if (Amt <= 0.00M) { return(new ApiResult(false, "金额必须大于0").toJson()); } #endregion JObject PayDataObj = JObject.Parse(PayData); int Type = (int)PayDataObj["Type"]; #region 查询项目名称和房屋编号,拼接费用备注 string FeesMemo = string.Empty; string RoomSign = string.Empty; if (Type == 1) { FeesMemo = "物业综合费用缴纳"; string CommName = erpConn.QueryFirstOrDefault <string>("SELECT CommName FROM Tb_HSPR_Community WHERE CommID = @CommID", new { CommID }); if (string.IsNullOrEmpty(CommName)) { CommName = Convert.ToString(CommID); } RoomSign = erpConn.QueryFirstOrDefault <string>("SELECT ISNULL(RoomSign,RoomName) AS RoomSign FROM Tb_HSPR_Room WHERE RoomID = @RoomID", new { RoomID }); if (string.IsNullOrEmpty(RoomSign)) { RoomSign = Convert.ToString(RoomID); } FeesMemo += string.Format("-{0}-{1}", CommName, RoomSign); } else { FeesMemo = "物业综合费用预存"; string CommName = erpConn.QueryFirstOrDefault <string>("SELECT CommName FROM Tb_HSPR_Community WHERE CommID = @CommID", new { CommID }); if (string.IsNullOrEmpty(CommName)) { CommName = Convert.ToString(CommID); } RoomSign = erpConn.QueryFirstOrDefault <string>("SELECT ISNULL(RoomSign,RoomName) AS RoomSign FROM Tb_HSPR_Room WHERE RoomID = @RoomID", new { RoomID }); if (string.IsNullOrEmpty(RoomSign)) { RoomSign = Convert.ToString(RoomID); } FeesMemo += string.Format("-{0}-{1}", CommName, RoomSign); } #endregion string NoticeId = Guid.NewGuid().ToString(); // 生成订单 if (erpConn.Execute("INSERT INTO Tb_Notice(Id, CommID, RoomID, CustID, PayData, CreateTime) VALUES(@Id, @CommID, @RoomID, @CustID, @PayData, @CreateTime)", new { Id = NoticeId, CommID, RoomID, CustID, PayData, CreateTime = DateTime.Now.ToString() }) <= 0) { return(new ApiResult(false, "创建收款订单失败,请重试").toJson()); } string ChargeMode = "业主APP缴费"; #region 修改收款方式 if (erpConn.QueryFirstOrDefault <int>("SELECT COUNT(1) FROM syscolumns WHERE id=object_id('Tb_Notice') AND name = 'ChargeMode'") > 0) { erpConn.Execute("UPDATE Tb_Notice SET ChargeMode = @ChargeMode WHERE Id = @Id", new { ChargeMode, Id = NoticeId }); } #endregion #region 请求通联微信支付 DateTime dateNow = DateTime.Now; string OrderSN = dateNow.ToString("yyyyMMddHHmmssfff") + Utils.BuildRandomStr(3); #region 获取对应类型的下账地址 string PaymentNotifyUrl = string.Empty; if (Type == 1) { PaymentNotifyUrl = AppGlobal.GetAppSetting("AllinPay_Notify_Url") + "?CommID=" + CommID; } else { PaymentNotifyUrl = AppGlobal.GetAppSetting("AllinPay_Prec_Notify_Url") + "?CommID=" + CommID; } #endregion Dictionary <string, string> param; try { param = SybWxPayService.Pay(Convert.ToInt64(Amt * 100), OrderSN, payChannel, FeesMemo, RoomSign, "", "", PaymentNotifyUrl, "", "", "", "", allinConfig.orgid, allinConfig.appid, allinConfig.custid, allinConfig.appkey, allinConfig.subbranch); if (param == null) { return(new ApiResult(false, "生成支付订单失败,请重试").toJson()); } } #pragma warning disable CS0168 // 声明了变量“ex”,但从未使用过 catch (Exception ex) #pragma warning restore CS0168 // 声明了变量“ex”,但从未使用过 { return(new ApiResult(false, "生成支付订单失败,请重试").toJson()); } #endregion if (erpConn.Execute(@"INSERT INTO Tb_Payment_Order(PayType, OrderSN, NoticeId, Amt, CreateTime) VALUES(@PayType, @OrderSN, @NoticeId, @Amt, @CreateTime)", new { PayType = payType, OrderSN = OrderSN, NoticeId = NoticeId, Amt = Amt, CreateTime = dateNow }) <= 0) { return(new ApiResult(false, "生成支付订单失败,请重试(1003)").toJson()); } return(new ApiResult(true, new { OrderSN = OrderSN, QrCode = param["payinfo"].ToString() }).toJson()); } }