public RiskInfo GetRiskInfo(string CommunityId, string custId, string roomId, string connStr)
{
IDbConnection conn = new SqlConnection(connStr);
string query = "SELECT CommName as omName,RoomName as omId,CustName as ownerName FROM view_HSPR_Room_Filter WHERE IsDelete = 0 and CommID=@CommunityId and RoomID=@RoomId and CustID=@CustId";
RiskInfo T = conn.Query <RiskInfo>(query, new { CommunityId = roomId.Substring(0, 6), RoomId = roomId, CustId = custId }).SingleOrDefault();
return(T);
}
/// <summary>
/// 生成订单
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
private string GenerateOrder(DataRow row)
{
#region 获取参数
if (!row.Table.Columns.Contains("CommunityId") || string.IsNullOrEmpty(row["CommunityId"].ToString()))
{
return(new ApiResult(false, "缺少参数CommunityId").toJson());
}
string CommunityId = row["CommunityId"].ToString();
if (!row.Table.Columns.Contains("CustID") || string.IsNullOrEmpty(row["CustID"].ToString()))
{
return(new ApiResult(false, "缺少参数CustID").toJson());
}
long CustID = Convert.ToInt64(row["CustID"].ToString());
if (!row.Table.Columns.Contains("RoomID") || string.IsNullOrEmpty(row["RoomID"].ToString()))
{
return(new ApiResult(false, "缺少参数RoomID").toJson());
}
long RoomID = Convert.ToInt64(row["RoomID"].ToString());
if (!row.Table.Columns.Contains("PayData") || string.IsNullOrEmpty(row["PayData"].ToString()))
{
return(new ApiResult(false, "缺少参数PayData").toJson());
}
string PayData = row["PayData"].ToString();
if (!row.Table.Columns.Contains("PayType") || string.IsNullOrEmpty(row["PayType"].ToString()))
{
return(new ApiResult(false, "缺少参数PayType").toJson());
}
// 默认为微信支付
//if (!int.TryParse(row["PayType"].ToString(), out int PayType) || (PayType != 0 && PayType != 1))
//{
//int PayType = 0;
//}
#endregion
#region 验证小区是否存在
Tb_Community tb_Community = GetCommunity(CommunityId);
if (null == tb_Community)
{
return(new ApiResult(false, "该项目未在运营系统中配置").toJson());
}
string erpConnStr = GetConnectionStr(tb_Community);
#endregion
#region 获取小区支付配置
WxPayConfig payConfig = GenerateConfig(CommunityId);
if (payConfig == null)
{
log.Error("支付配置有误");
return(new ApiResult(false, "支付配置有误").toJson());
}
#endregion
#region 检测支付数据格式
if (!CheckPayData(erpConnStr, CustID, RoomID, PayData, out decimal Amt, out string errMsg, true))
{
return(new ApiResult(false, errMsg).toJson());
}
//Amt = decimal.Parse("0.01");
decimal orderAmt = Amt;
Amt = Amt * 100;
if (Amt <= 0.00M)
{
return(new ApiResult(false, "订单已被支付或者支付金额小于0").toJson());
}
#endregion
DateTime DateNow = DateTime.Now;
string OrderSN = DateNow.ToString("yyyyMMddHHmmssfff") + GetRandomCode(3);
string strBack = "";
string strStart = DateTime.Now.ToString("yyyyMMddHHmmss");
string strEnd = DateTime.Now.AddMinutes(10).ToString("yyyyMMddHHmmss");
SortedDictionary <String, String> orderInfoDic = new SortedDictionary <string, string>();
orderInfoDic.AddOrPeplace("version", "V2.0");
orderInfoDic.AddOrPeplace("merchant", payConfig.MCHID.Trim());
orderInfoDic.AddOrPeplace("tradeNum", OrderSN);
orderInfoDic.AddOrPeplace("tradeName", "鸿坤瑞邦物业管理有限公司-物业缴费");
orderInfoDic.AddOrPeplace("tradeTime", strStart);
orderInfoDic.AddOrPeplace("amount", ((int)Amt).ToString().Trim());
orderInfoDic.AddOrPeplace("orderType", "1");
orderInfoDic.AddOrPeplace("currency", "CNY");
orderInfoDic.AddOrPeplace("notifyUrl", payConfig.NOTIFY_URL.Trim());
orderInfoDic.AddOrPeplace("userId", CustID.ToString().Trim());
orderInfoDic.AddOrPeplace("userType", "BIZ");
orderInfoDic.AddOrPeplace("expireTime", "600");
//获取风控信息
RiskInfo risk = GetRiskInfo(CommunityId, CustID.ToString(), RoomID.ToString(), erpConnStr);
if (risk != null)
{
orderInfoDic.AddOrPeplace("riskInfo", JsonConvert.SerializeObject(risk));
}
//获取支付详细信息
List <GoodsInfo> googsInfoList = new List <GoodsInfo>();
JObject PayDataObj = JObject.Parse(PayData);
int Type = (int)PayDataObj["Type"];
if (Type == 1)
{
//实付
JArray Data = (JArray)PayDataObj["Data"];
string strFeeds = "";
foreach (JObject item in Data)
{
strFeeds += $"{(string)item["FeesId"]},";
}
strFeeds = strFeeds.TrimEnd(',');
using (IDbConnection conn = new SqlConnection(erpConnStr))
{
string QuerySql = $"select c.CostID,c.CostName from tb_hspr_fees f inner join Tb_HSPR_CostItem c on f.CostID = c.CostID where f.FeesID in ({strFeeds})";
var costInfo = conn.Query(QuerySql);
foreach (var vc in costInfo)
{
GoodsInfo gd = new GoodsInfo()
{
id = vc.CostID + "",
name = vc.CostName
};
googsInfoList.Add(gd);
}
}
}
if (Type == 2)
{
//预付
JObject Data = (JObject)PayDataObj["Data"];
string CostID = (string)Data["CostID"];
using (IDbConnection conn = new SqlConnection(erpConnStr))
{
dynamic costInfo = conn.QueryFirstOrDefault <dynamic>("SELECT CostID, CostName FROM view_HSPR_CostStanSetting_Filter WHERE CustID = @CustID " + (0 == RoomID ? "" : " AND RoomID = @RoomID ") + " AND CostID= @CostID GROUP BY CostID, CostName", new { CustID = CustID, RoomID = RoomID, CostID = CostID });
GoodsInfo gd = new GoodsInfo()
{
id = costInfo.CostID + "",
name = costInfo.CostName
};
googsInfoList.Add(gd);
}
}
orderInfoDic.AddOrPeplace("goodsInfo", JsonConvert.SerializeObject(googsInfoList));
WxPayData data = new WxPayData();
String reqXmlStr = XMLUtil.encryptReqXml(payConfig.APPSECRET, payConfig.KEY, orderInfoDic);
String refundUrl = PropertyUtils.getProperty("wepay.server.uniorder.url");
String resultJsonData = HttpUtil.postRest(refundUrl, reqXmlStr);
log.Error("京东支付第二步，返回结果:" + resultJsonData);
res = XMLUtil.decryptResXml <CreateOrderResponse>(payConfig.APPID, payConfig.KEY, resultJsonData);
if (res.result.code != "000000")
{
log.Error("京东支付时调用服务器统一下单接口失败:");
return(new ApiResult(false, "京东支付失败,请联系客服人员").toJson());
}
else
{
#region 插入订单表
using (IDbConnection conn = new SqlConnection(PubConstant.UnifiedContionString))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("PayConfigId", 999999);
parameters.Add("OrderSN", OrderSN);
parameters.Add("CustID", CustID);
parameters.Add("RoomID", RoomID);
parameters.Add("PayData", PayData);
parameters.Add("Amt", orderAmt);
parameters.Add("CreateTime", DateNow.ToString());
parameters.Add("PayConfigNewId", payConfig.ID);
if (conn.Execute(@"INSERT INTO Tb_CCBPay_Order(PayConfigId, OrderSN, CustID, RoomID, PayData, Amt, CreateTime,PayConfigNewId,orderType)
VALUES(@PayConfigId, @OrderSN, @CustID, @RoomID, @PayData, @Amt, @CreateTime,@PayConfigNewId,2)", parameters) <= 0)
{
return(new ApiResult(false, "保存订单信息失败,请重试").toJson());
}
}
#endregion
string signData = "";
try
{
//MD5加密
string needMd5Str = "merchant=" + payConfig.MCHID + "&orderId=" + res.orderId + "&key=" + payConfig.SSLCERT_PASSWORD;
var md5 = MD5.Create();
var bs = md5.ComputeHash(Encoding.UTF8.GetBytes(needMd5Str));
var sb = new StringBuilder();
foreach (byte b in bs)
{
sb.Append(b.ToString("x2"));
}
//所有字符转为大写
signData = sb.ToString().ToLower();
}
catch (Exception ex)
{
}
strBack += $"out_trade_no={OrderSN}&orderId={res.orderId}&merchant={payConfig.MCHID}&signData={signData}";
log.Info("给APP返回的数据:" + strBack);
return(new ApiResult(true, strBack).toJson());
}
}