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());
}
}
