public bool addTgOrder(TgOrder modle)
{
using (DbOperator operators = ConnectionManager.CreateConnection())
{
return(Add(modle, operators));
}
}
/// <summary>
/// 添加推广人员成功订单记录
/// </summary>
/// <param name="modle"></param>
/// <returns></returns>
public static bool Addperson(TgOrder modle)
{
ITgOrder factory = TgOrderFactory.GetFactory();
bool result = factory.addTgOrder(modle);
if (result)
{
OperateLogServices.AddOperateLog(OperateType.Add, string.Format("orderId:{0},personName:{1},parkingname:{2}", modle.ID, modle.PersonName, modle.PKName));
}
return(result);
}
public bool Add(TgOrder modle, DbOperator operators)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("insert into TgOrder(OrderID,PKID,PKName,PlateNo,Amount,RealPayTime,PersonId,PersonName)");
sb.AppendFormat("values(@OrderID,@PKID,@PKName,@PlateNo,@Amount,@RealPayTime,@PersonId,@PersonName)");
operators.ClearParameters();
operators.AddParameter("OrderID", modle.OrderID);
operators.AddParameter("PKID", modle.PKID);
operators.AddParameter("PKName", modle.PKName);
operators.AddParameter("PlateNo", modle.PlateNo);
operators.AddParameter("Amount", modle.Amount);
operators.AddParameter("RealPayTime", modle.RealPayTime);
operators.AddParameter("PersonId", modle.PersonId);
operators.AddParameter("PersonName", modle.PersonName);
return(operators.ExecuteNonQuery(sb.ToString()) > 0);
}
public List <TgOrder> CountTgPersonOrder(InParams paras, int PageSize, int PageIndex)
{
List <TgOrder> Personlist = new List <TgOrder>();
string strSql = "select top " + PageSize + " * from ( select top " + PageIndex * PageSize + " PersonId,PersonName,PKID,PKName,sum(Amount) as Amount,COUNT(OrderID) as count from TgOrder where 1=1";
if (!string.IsNullOrEmpty(paras.ParkingID))
{
strSql += " and PKID=@PKID";
}
if (paras.StartTime != null)
{
strSql += " and RealPayTime>=@StartTime";
}
if (paras.EndTime != null)
{
strSql += " and RealPayTime<@EndTime";
}
strSql += " group by PersonId,PersonName,PKID,PKName order by PersonId desc )a order by PersonId";
using (DbOperator dboperator = ConnectionManager.CreateReadConnection())
{
dboperator.ClearParameters();
dboperator.AddParameter("PKID", paras.ParkingID);
dboperator.AddParameter("StartTime", paras.StartTime);
dboperator.AddParameter("EndTime", paras.EndTime);
using (DbDataReader dr = dboperator.ExecuteReader(strSql))
{
while (dr.Read())
{
TgOrder tg = new TgOrder();
tg.PersonId = int.Parse(dr["PersonId"].ToString());
tg.PersonName = dr["PersonName"].ToString();
tg.PKID = dr["PKID"].ToString();
tg.PKName = dr["PKName"].ToString();
tg.Amount = decimal.Parse(dr["Amount"].ToString());
tg.Count = int.Parse(dr["count"].ToString());
Personlist.Add(tg);
}
}
}
return(Personlist);
}
/// <summary>
/// 订单支付通道
/// </summary>
public void Index()
{
ReturnMessage returnMsg = new ReturnMessage()
{
Return_Code = "SUCCESS", Return_Msg = ""
};
string xmlString = GetXmlString(Request);
NotifyMessage message = null;
try
{
TxtLogServices.WriteTxtLogEx("WeiXinPayNotify", xmlString);
//此处应记录日志
message = XmlHelper.Deserialize <NotifyMessage>(xmlString);
XmlDocument doc = new XmlDocument();
doc.LoadXml(xmlString);
Dictionary <string, string> dic = new Dictionary <string, string>();
string sign = string.Empty;
foreach (XmlNode node in doc.FirstChild.ChildNodes)
{
if (node.Name.ToLower() != "sign")
{
dic.Add(node.Name, node.InnerText);
}
else
{
sign = node.InnerText;
}
}
//处理通知
decimal orderId;
if (!dic.ContainsKey("out_trade_no") || !decimal.TryParse(dic["out_trade_no"], out orderId))
{
throw new MyException("支付回调订单编号格式不正确");
}
OnlineOrder order = OnlineOrderServices.QueryByOrderId(orderId);
if (order == null)
{
throw new MyException("订单存在,orderId:" + orderId);
}
UnifiedPayModel model = UnifiedPayModel.CreateUnifiedModel(order.CompanyID);
if (!model.ValidateMD5Signature(dic, sign))
{
throw new Exception("签名未通过！");
}
if (!dic.ContainsKey("transaction_id"))
{
throw new MyException("支付流水号不存在");
}
string payTradeNo = dic["transaction_id"];
DateTime payTime = DateTime.Now;
if (dic.ContainsKey("time_end") && dic["time_end"].Length == 14)
{
string strDate = dic["time_end"].Insert(4, "-").Insert(7, "-").Insert(10, " ").Insert(13, ":").Insert(16, ":");
if (!DateTime.TryParse(strDate, out payTime))
{
payTime = DateTime.Now;
}
}
string payAccount = string.Empty;
if (dic.ContainsKey("attach") && dic["attach"] == "MWEB" && dic.ContainsKey("openid") && !string.IsNullOrWhiteSpace(dic["openid"]))
{
payAccount = dic["openid"];
}
else if (dic.ContainsKey("attach") && dic["attach"].Length > 0)
{
//统计二维码推广订单信息
string sAgendID = dic["attach"];
tgPerson person = tgPersonServices.QueryPersonByID(int.Parse(sAgendID));
TgOrder to = new TgOrder();
to.OrderID = order.OrderID;
to.PKID = order.PKID;
to.PKName = order.PKName;
to.PlateNo = order.PlateNo;
to.Amount = order.Amount;
to.RealPayTime = payTime;
to.PersonId = person.id;
to.PersonName = person.name;
TgOrderService.Addperson(to);
}
//if (Request.Cookies["SmartSystem_WeiXinTg_personid"] != null)
//{
//}
WeiXinInerface.ParkingFeeService.DeleteParkingFee(order.PlateNo + order.PKID);
OnlineOrderServices.PaySuccess(orderId, payTradeNo, payTime, payAccount);
}
catch (MyException ex)
{
ExceptionsServices.AddExceptionToDbAndTxt("WeiXinPayNotify", "支付通知出错:" + ex.Message, ex, LogFrom.WeiXin);
//此处记录异常日志
returnMsg.Return_Code = "FAIL";
returnMsg.Return_Msg = ex.Message;
}
catch (Exception ex)
{
ExceptionsServices.AddExceptionToDbAndTxt("WeiXinPayNotify", "支付通知出错", ex, LogFrom.WeiXin);
//此处记录异常日志
returnMsg.Return_Code = "FAIL";
returnMsg.Return_Msg = ex.Message;
}
Response.Write(returnMsg.ToXmlString());
Response.End();
}
