/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_OrderCallBack model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_OrderCallBack("); strSql.Append("OrderID,CheCi,FromStationName,FromStationCode,ToStationName,ToStationCode,TrainDate,UserOrderid,Orderamount,Ordernumber,Status,Msg,RefundMoney,Passengers)"); strSql.Append(" values ("); strSql.Append("@OrderID,@CheCi,@FromStationName,@FromStationCode,@ToStationName,@ToStationCode,@TrainDate,@UserOrderid,@Orderamount,@Ordernumber,@Status,@Msg,@RefundMoney,@Passengers)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.VarChar, 100), new SqlParameter("@CheCi", SqlDbType.VarChar, 100), new SqlParameter("@FromStationName", SqlDbType.VarChar, 100), new SqlParameter("@FromStationCode", SqlDbType.VarChar, 100), new SqlParameter("@ToStationName", SqlDbType.VarChar, 100), new SqlParameter("@ToStationCode", SqlDbType.VarChar), new SqlParameter("@TrainDate", SqlDbType.DateTime), new SqlParameter("@UserOrderid", SqlDbType.VarChar), new SqlParameter("@Orderamount", SqlDbType.Decimal), new SqlParameter("@Ordernumber", SqlDbType.VarChar), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@Msg", SqlDbType.VarChar), new SqlParameter("@RefundMoney", SqlDbType.VarChar), new SqlParameter("@Passengers", SqlDbType.VarChar) }; parameters[0].Value = model.OrderID; parameters[1].Value = model.CheCi; parameters[2].Value = model.FromStationName; parameters[3].Value = model.FromStationCode; parameters[4].Value = model.ToStationName; parameters[5].Value = model.ToStationCode; parameters[6].Value = model.TrainDate; parameters[7].Value = model.UserOrderid; parameters[8].Value = model.Orderamount; parameters[9].Value = model.Ordernumber; parameters[10].Value = model.Status; parameters[11].Value = model.Msg; parameters[12].Value = model.RefundMoney; parameters[13].Value = model.Passengers; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public void ProcessRequest(HttpContext context) { string s = "\r\n" + "\r\n" + "\r\n" + "\r\n" + "记录时间" + DateTime.Now.ToString() + "\r\n"; try { context.Response.ContentType = "text/plain"; string data = context.Request["data"]; s = s + "接受内容信息:" + data + "\r\n"; var emResult = JsonConvert.DeserializeObject <data>(data); if (emResult != null) { lgk.Model.tb_OrderCallBack Modelreback = orderCallbll.GetModel(" OrderID='" + emResult.orderid + "'"); if (Modelreback == null) { lgk.Model.tb_OrderCallBack Model = new lgk.Model.tb_OrderCallBack(); Model.OrderID = emResult.orderid.Trim(); Model.FromStationCode = emResult.from_station_code.Trim(); Model.FromStationName = emResult.from_station_name.Trim(); Model.CheCi = emResult.checi.Trim(); Model.Msg = emResult.msg.Trim(); if (string.IsNullOrEmpty(emResult.orderamount)) { Model.Orderamount = 0; } else { Model.Orderamount = Convert.ToDecimal(emResult.orderamount.Trim()); } if (string.IsNullOrEmpty(emResult.ordernumber)) { Model.Ordernumber = ""; } else { Model.Ordernumber = emResult.ordernumber.Trim(); } Model.Passengers = "["; for (int i = 0; i < emResult.passengers.Count; i++) { Model.Passengers += "{passengerid:" + emResult.passengers[i].passengerid + ",passengersename:" + emResult.passengers[i].passengersename + ",passportseno:" + emResult.passengers[i].passportseno + ",passporttypeseid:" + emResult.passengers[i].passporttypeseid + ",passporttypeseidname" + emResult.passengers[i].passporttypeseidname + ",piaotype:" + emResult.passengers[i].piaotype + ",piaotypename:" + emResult.passengers[i].piaotypename + ",price:" + emResult.passengers[i].price + ",zwcode:" + emResult.passengers[i].zwcode + ",zwname:" + emResult.passengers[i].zwname + "}"; if (i != emResult.passengers.Count - 1) { Model.Passengers += ","; } } Model.Passengers += "]"; //emResult.passengers = emResult.passengers; Model.RefundMoney = emResult.refund_money; Model.Status = Convert.ToInt32(emResult.status.Trim()); Model.ToStationCode = emResult.to_station_code.Trim(); Model.ToStationName = emResult.to_station_name.Trim(); Model.TrainDate = Convert.ToDateTime(emResult.train_date.Trim()); Model.UserOrderid = emResult.user_orderid; if (orderCallbll.Add(Model) > 0) { lgk.Model.tb_TrainTicketsOrder order = orderBLL.GetModel("OrderID='" + Model.OrderID + "'"); if (order != null) { List <lgk.Model.tb_TrainTicketsOrderDetail> list = bllorderdeil.GetModelList("OrderID=" + order.ID); order.State = Model.Status; if (orderBLL.Update(order)) { for (int i = 0; i < emResult.passengers.Count; i++) { bllorderdeil.UpdateStatus(emResult.passengers[i].cxin, Convert.ToInt32(Model.Status), order.ID, Convert.ToInt32(emResult.passengers[i].passengerid)); } //出票失败处理 if (Model.Status == 5) { lgk.Model.tb_user model = userBLL.GetModel(order.UserID); model.BonusAccount += order.OrderPrice; userBLL.Update(model); string bramk = "出票失败" + order.OrderCode + ",返回云图:" + order.OrderPrice; JournalAdd(order.UserID, bramk, 1, order.OrderPrice); bllaccount.UpdateBanlcen("TrainAccount", order.OrderPrice + 3 * list.Count, 2); } s = s + "更新订单状态成功,订单状态为:" + StateCode(Model.Status) + "\r\n"; context.Response.Write("success"); } } else { s = s + "订单不存在\r\n"; context.Response.Write("订单不存在"); } } } else { Modelreback.Status = Convert.ToInt32(emResult.status); if (orderCallbll.Update(Modelreback)) { lgk.Model.tb_TrainTicketsOrder order = orderBLL.GetModel("OrderID='" + Modelreback.OrderID + "'"); List <lgk.Model.tb_TrainTicketsOrderDetail> list = bllorderdeil.GetModelList("OrderID=" + order.ID); if (order != null) { order.State = Convert.ToInt32(emResult.status); if (orderBLL.Update(order)) { for (int i = 0; i < emResult.passengers.Count; i++) { bllorderdeil.UpdateStatus(emResult.passengers[i].cxin, Convert.ToInt32(Modelreback.Status), order.ID, Convert.ToInt32(emResult.passengers[i].passengerid)); } //出票失败处理 if (Modelreback.Status == 5) { lgk.Model.tb_user model = userBLL.GetModel(order.UserID); model.BonusAccount += order.OrderPrice; userBLL.Update(model); string bramk = "出票失败" + order.OrderCode + ",返回云图:" + order.OrderPrice; JournalAdd(order.UserID, bramk, 1, order.OrderPrice); bllaccount.UpdateBanlcen("TrainAccount", order.OrderPrice + 3 * list.Count, 2); } s = s + "更新订单状态成功,订单状态为:" + StateCode(Modelreback.Status) + "\r\n"; //context.Response.Write("success"); } } } // s = s + "重复推送\r\n"; context.Response.Write("success"); } } else { s = s + "没有回调\r\n"; context.Response.Write("没有回调数据"); } } catch (Exception ex) { s = s + "回调异常,错误信息" + ex.Message + "\r\n"; context.Response.Write("回调异常,错误信息" + ex.Message); } System.IO.File.AppendAllText(context.Server.MapPath("~/log/RequesTrainBacklog/RequestBacklog" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + ".txt"), s); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_OrderCallBack model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_OrderCallBack model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_OrderCallBack model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_OrderCallBack set "); strSql.Append("OrderID=@OrderID,"); strSql.Append("CheCi=@CheCi,"); strSql.Append("FromStationName=@FromStationName,"); strSql.Append("FromStationCode=@FromStationCode,"); strSql.Append("ToStationName=@ToStationName,"); strSql.Append("ToStationCode=@ToStationCode,"); strSql.Append("TrainDate=@TrainDate,"); strSql.Append("UserOrderid=@UserOrderid,"); strSql.Append("Orderamount=@Orderamount,"); strSql.Append("Ordernumber=@Ordernumber,"); strSql.Append("Status=@Status,"); strSql.Append("Msg=@Msg,"); strSql.Append("RefundMoney=@RefundMoney,"); strSql.Append("Passengers=@Passengers"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.VarChar, 100), new SqlParameter("@CheCi", SqlDbType.VarChar, 100), new SqlParameter("@FromStationName", SqlDbType.VarChar, 100), new SqlParameter("@FromStationCode", SqlDbType.VarChar, 100), new SqlParameter("@ToStationName", SqlDbType.VarChar, 100), new SqlParameter("@ToStationCode", SqlDbType.VarChar), new SqlParameter("@TrainDate", SqlDbType.DateTime), new SqlParameter("@UserOrderid", SqlDbType.VarChar), new SqlParameter("@Orderamount", SqlDbType.Decimal), new SqlParameter("@Ordernumber", SqlDbType.VarChar), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@Msg", SqlDbType.VarChar), new SqlParameter("@RefundMoney", SqlDbType.Decimal), new SqlParameter("@Passengers", SqlDbType.VarChar), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.OrderID; parameters[1].Value = model.CheCi; parameters[2].Value = model.FromStationName; parameters[3].Value = model.FromStationCode; parameters[4].Value = model.ToStationName; parameters[5].Value = model.ToStationCode; parameters[6].Value = model.TrainDate; parameters[7].Value = model.UserOrderid; parameters[8].Value = model.Orderamount; parameters[9].Value = model.Ordernumber; parameters[10].Value = model.Status; parameters[11].Value = model.Msg; parameters[12].Value = model.RefundMoney; parameters[13].Value = model.Passengers; parameters[14].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public lgk.Model.tb_OrderCallBack GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from tb_OrderCallBack "); strSql.Append(" where " + where); lgk.Model.tb_OrderCallBack model = new lgk.Model.tb_OrderCallBack(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["OrderID"] != null && ds.Tables[0].Rows[0]["OrderID"].ToString() != "") { model.OrderID = ds.Tables[0].Rows[0]["OrderID"].ToString(); } if (ds.Tables[0].Rows[0]["CheCi"] != null && ds.Tables[0].Rows[0]["CheCi"].ToString() != "") { model.CheCi = ds.Tables[0].Rows[0]["CheCi"].ToString(); } if (ds.Tables[0].Rows[0]["FromStationName"] != null && ds.Tables[0].Rows[0]["FromStationName"].ToString() != "") { model.FromStationName = ds.Tables[0].Rows[0]["FromStationName"].ToString(); } if (ds.Tables[0].Rows[0]["FromStationCode"] != null && ds.Tables[0].Rows[0]["FromStationCode"].ToString() != "") { model.FromStationCode = ds.Tables[0].Rows[0]["FromStationCode"].ToString(); } if (ds.Tables[0].Rows[0]["ToStationName"] != null && ds.Tables[0].Rows[0]["ToStationName"].ToString() != "") { model.ToStationName = ds.Tables[0].Rows[0]["ToStationName"].ToString(); } if (ds.Tables[0].Rows[0]["ToStationCode"] != null && ds.Tables[0].Rows[0]["ToStationCode"].ToString() != "") { model.ToStationCode = ds.Tables[0].Rows[0]["ToStationCode"].ToString(); } if (ds.Tables[0].Rows[0]["TrainDate"] != null && ds.Tables[0].Rows[0]["TrainDate"].ToString() != "") { model.TrainDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["TrainDate"].ToString()); } if (ds.Tables[0].Rows[0]["UserOrderid"] != null && ds.Tables[0].Rows[0]["UserOrderid"].ToString() != "") { model.UserOrderid = ds.Tables[0].Rows[0]["UserOrderid"].ToString(); } if (ds.Tables[0].Rows[0]["Orderamount"] != null && ds.Tables[0].Rows[0]["Orderamount"].ToString() != "") { model.Orderamount = Convert.ToDecimal(ds.Tables[0].Rows[0]["Orderamount"].ToString()); } if (ds.Tables[0].Rows[0]["Ordernumber"] != null && ds.Tables[0].Rows[0]["Ordernumber"].ToString() != "") { model.Ordernumber = ds.Tables[0].Rows[0]["Ordernumber"].ToString(); } if (ds.Tables[0].Rows[0]["Status"] != null && ds.Tables[0].Rows[0]["Status"].ToString() != "") { model.Status = Convert.ToInt32(ds.Tables[0].Rows[0]["Status"].ToString()); } if (ds.Tables[0].Rows[0]["Msg"] != null && ds.Tables[0].Rows[0]["Msg"].ToString() != "") { model.Msg = ds.Tables[0].Rows[0]["Msg"].ToString(); } if (ds.Tables[0].Rows[0]["RefundMoney"] != null && ds.Tables[0].Rows[0]["RefundMoney"].ToString() != "") { model.RefundMoney = ds.Tables[0].Rows[0]["RefundMoney"].ToString(); } if (ds.Tables[0].Rows[0]["Passengers"] != null && ds.Tables[0].Rows[0]["Passengers"].ToString() != "") { model.Passengers = ds.Tables[0].Rows[0]["Passengers"].ToString(); } return(model); } else { return(null); } }