/// <summary> /// 查询订单 /// </summary> /// <param name="dic"></param> /// <returns></returns> public string Getorder(Dictionary <string, object> dic) { try { string spond = RequestSumit(dic, "getorder"); var backmodel = JsonConvert.DeserializeObject <QueryRespon>(spond); if (backmodel.successcode == "T") { lgk.Model.tb_TicketOrder model = ordermodel.GetModel("OrdeID='" + backmodel.result.orderno + "'"); //更新订单状态 model.Status = Convert.ToInt32(backmodel.result.orderstatus); if (ordermodel.Update(model)) { for (int i = 0; i < backmodel.result.passengers.Count; i++) { passengmodel.UpdateStatus(backmodel.result.passengers[i].ticketnumber, backmodel.result.passengers[i].idnumber); } } } return(spond); } catch (Exception) { return("{\"reason\":\"error\",\"error_code\":\"1\",\"info\":\"查询异常\"}"); } }
/// <summary> /// 取消订单 /// </summary> /// <param name="dic"></param> /// <returns></returns> public string Cancel(Dictionary <string, object> dic) { string respon = RequestSumit(dic, "ordercancel"); if (respon != "error") { var Result = JsonConvert.DeserializeObject <respondTicketResult>(respon); if (Result.successcode == "T") { lgk.Model.tb_TicketOrder tickmodel = ordermodel.GetModel("OrdeID='" + dic["orderno"].ToString() + "'"); if (tickmodel.PayStatus == 1) { //取消订单返还账户金额 lgk.Model.tb_user model = userBLL.GetModel(tickmodel.UserID); model.Emoney += tickmodel.TicketPrice + 20; userBLL.Update(model); string bramk = "取消订单" + tickmodel.OrdeID + ",返回注册分:" + tickmodel.TicketPrice; JournalAdd(tickmodel.UserID, bramk, 1, tickmodel.TicketPrice); } //更新订单状态 ordermodel.UpdateStatus(10, 2, dic["orderno"].ToString()); return(respon); } return(respon); } else { return("{\"successcode\":\"F\",\"errorcode\":\"1\",\"info\":\"请求接口异常,请重试或联系接口商\"}"); } }
/// <summary> /// 自动支付 /// </summary> /// <param name="dic"></param> /// <returns></returns> public string PaySubmit(Dictionary<string, object> dic, string loacthpaypwd) { //提交订单到接口 lgk.BLL.tb_TicketOrder bllorder = new lgk.BLL.tb_TicketOrder(); lgk.Model.tb_TicketOrder model = bllorder.GetModel("OrdeID='" + dic["orderno"].ToString() + "'"); var usermodel = userBLL.GetModel(model.UserID); if (usermodel.IsLock == 1) { return "{\"successcode\":\"F\",\"errorcode\":\"1\",\"info\":\"账户已冻结,提交失败\"}"; } if (usermodel.SecondPassword.Equals(loacthpaypwd)) { if (usermodel.Emoney < model.PayPrice) { return "{\"successcode\":\"F\",\"errorcode\":\"1\",\"info\":\"原始币余额不足\"}"; } else { string respon = RequestSumit(dic, "autopayvm"); if (respon != "error") { var Result = JsonConvert.DeserializeObject<respondTicketResult>(respon); if (Result.successcode == "T") { //更新订单状态 if (ordermodel.UpdateStatus(Convert.ToInt32(Result.result.orderstatus), Convert.ToInt32(Result.result.paystatus), Result.result.orderno)) { //扣除原始币 string bonus = Bonus(usermodel, model.PayPrice); //扣除原始币账户 第三方账户 bllaccount.UpdateBanlcen("TicketAccount", model.PayPrice, 1); return respon; } else { return "{\"successcode\":\"F\",\"errorcode\":\"1\",\"info\":\"更新本地订单状态失败,请联系平台\"}"; } } else { return respon; } } else { return "{\"successcode\":\"F\",\"errorcode\":\"1\",\"info\":\"请求支付失败\"}"; } } } else { return "{\"successcode\":\"F\",\"errorcode\":\"1\",\"info\":\"支付密码不正确\"}"; } }
protected void Page_Load(object sender, EventArgs e) { orderid = Request["orderid"].ToString(); lgk.Model.tb_TicketOrder model = bllorder.GetModel("OrdeID='" + orderid + "'"); orderid = model.OrdeID; orderdate = model.DepDate.ToString("yyy-MM-dd"); price = model.PayPrice.ToString(); checi = model.Flight; deptime = model.DepcityName + "(" + model.DepTime.ToString("HH:mm") + ")"; arrytime = model.ArrcityName + "(" + model.ArrTime.ToString("HH:mm") + ")"; uid.Value = model.UserID.ToString(); }
protected void Page_Load(object sender, EventArgs e) { try { ordercode.Value = orderid = Request["ordercode"].ToString(); lgk.Model.tb_TicketOrder model = bllorder.GetModel("OrdeID='" + orderid + "'"); if (model != null) { price = model.PayPrice.ToString(); piaodate = model.DepDate.ToString("yyyy-MM-dd"); trancode = model.AirName; starttime = Convert.ToDateTime(model.DepTime).ToShortTimeString(); startstationname = model.DepcityName; arrivetime = Convert.ToDateTime(model.ArrTime).ToShortTimeString(); endstationname = model.ArrcityName; //usercode = usbll.GetModel(model.UserID).UserCode; // orderinfo = Request["orderinfo"].ToString(); linkman = model.LinkMan; linkmobile = model.LinkMobile; cabin = model.Cabin; List <lgk.Model.tb_Passengers> modeldite = bllorderdeil.GetModelList("OrderID=" + model.ID); List <orderinfo> order = new List <orderinfo>(); for (int i = 0; i < modeldite.Count; i++) { orderinfo ordermodel = new orderinfo(); ordermodel.name = modeldite[i].Name; ordermodel.cardno = modeldite[i].Cardno; order.Add(ordermodel); } DataSet ds = DataSetList(order); bind_repeater(ds, Repeater1, "cardno"); uid.Value = model.UserID.ToString(); status.Value = model.Status.ToString(); statusstr = statushand(model.Status.ToString()); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('系统异常,异常信息:" + ex.Message + "');", true); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_TicketOrder model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_TicketOrder model) { return(dal.Add(model)); }
/// <summary> /// 添加本地订单 /// </summary> /// <param name="dic"></param> /// <returns></returns> public int OrderHandle(Dictionary <string, object> dic, Dictionary <string, object> dic1) { int result = 0; string depdate = null; try { lgk.Model.tb_TicketOrder order = new lgk.Model.tb_TicketOrder(); lgk.Model.tb_Passengers orderdateil = new lgk.Model.tb_Passengers(); Dictionary <string, object> travelsheet = Util.JsonToDictionary(dic["travelsheet"].ToString()); //travelsheet对象 Dictionary <string, object> contact = Util.JsonToDictionary(dic["contact"].ToString()); //contact对象 Dictionary <string, object> segments = Util.JsonToDictionary(dic["segments"].ToString()); //segments对象 List <Dictionary <string, object> > passengers = Util.JsonToDictionaryList(dic["passengers"].ToString()); //passengers对象 foreach (var item in contact) { if (dic.ContainsKey(item.Key) == false) { dic.Add(item.Key, item.Value); } } foreach (var item in travelsheet) { if (dic.ContainsKey(item.Key) == false) { dic.Add(item.Key, item.Value); } } foreach (var item in segments) { if (item.Key == "depdate") { depdate = item.Value.ToString(); } if (item.Key == "deptime") { dic.Add(item.Key, depdate + " " + item.Value); } if (item.Key == "arrtime") { dic.Add(item.Key, depdate + " " + item.Value); //key = Convert.ToDateTime(depdate + " " + item.Value); } if (item.Key.Equals("prices")) { var prices = (Dictionary <string, object>)item.Value; foreach (var item1 in prices) { if (dic.ContainsKey(item1.Key) == false) { dic.Add(item1.Key, item1.Value); } } } else { if (dic.ContainsKey(item.Key) == false) { dic.Add(item.Key, item.Value); } } } //给tb_TicketOrder实体赋值 System.Reflection.PropertyInfo[] properties = order.GetType().GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public); foreach (System.Reflection.PropertyInfo item in properties) { foreach (var item1 in dic) { object key = null; if (item.Name.ToLower().Equals(item1.Key.ToLower())) { if (item.PropertyType.Name == "String") { key = item1.Value.ToString(); } if (item.PropertyType.Name == "Int32") { key = Convert.ToInt32(item1.Value); } if (item.PropertyType.Name == "Decimal") { key = Convert.ToDecimal(item1.Value); } if (item.PropertyType.Name == "DateTime") { key = Convert.ToDateTime(item1.Value); } item.SetValue(order, key, null); } } } order.AddDate = DateTime.Now; int uid = ordermodel.Add(order); Dictionary <string, object> passenger = new Dictionary <string, object>();//segments对象 //给tb_Passengers实体赋值 System.Reflection.PropertyInfo[] prssproperties = orderdateil.GetType().GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public); for (int i = 0; i < passengers.Count; i++) { foreach (var item in passengers[i]) { if (passenger.ContainsKey(item.Key)) { passenger[item.Key] = item.Value; } else { passenger.Add(item.Key, item.Value); } } foreach (System.Reflection.PropertyInfo item in prssproperties) { foreach (var item1 in passenger) { object key = null; if (item.Name.ToLower().Equals(item1.Key.ToLower())) { //dic2["deptime"] = dic["depdate"] + " " + dic["deptime"]; //dic2["arrtime"] = dic["depdate"] + " " + dic["arrtime"]; if (item.PropertyType.Name == "String") { key = item1.Value.ToString(); } if (item.PropertyType.Name == "Int32") { key = Convert.ToInt32(item1.Value); } if (item.PropertyType.Name == "Decimal") { key = Convert.ToDecimal(item1.Value); } if (item.PropertyType.Name == "DateTime") { key = Convert.ToDateTime(item1.Value); } item.SetValue(orderdateil, key, null); } } } orderdateil.OrderID = uid; passengmodel.Add(orderdateil); } } catch (Exception ex) { result = -1; } return(result); }
public lgk.Model.tb_TicketOrder GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from tb_TicketOrder "); strSql.Append(" where " + where); lgk.Model.tb_TicketOrder model = new lgk.Model.tb_TicketOrder(); 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]["OrdeID"] != null && ds.Tables[0].Rows[0]["OrdeID"].ToString() != "") { model.OrdeID = ds.Tables[0].Rows[0]["OrdeID"].ToString(); } if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = Convert.ToInt32(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["AddDate"] != null && ds.Tables[0].Rows[0]["AddDate"].ToString() != "") { model.AddDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["AddDate"].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]["PayPrice"] != null && ds.Tables[0].Rows[0]["PayPrice"].ToString() != "") { model.PayPrice = Convert.ToDecimal(ds.Tables[0].Rows[0]["PayPrice"].ToString()); } if (ds.Tables[0].Rows[0]["Totaltax"] != null && ds.Tables[0].Rows[0]["Totaltax"].ToString() != "") { model.Totaltax = Convert.ToDecimal(ds.Tables[0].Rows[0]["Totaltax"].ToString()); } if (ds.Tables[0].Rows[0]["TicketPrice"] != null && ds.Tables[0].Rows[0]["TicketPrice"].ToString() != "") { model.TicketPrice = Convert.ToDecimal(ds.Tables[0].Rows[0]["TicketPrice"].ToString()); } if (ds.Tables[0].Rows[0]["PolicyNum"] != null && ds.Tables[0].Rows[0]["PolicyNum"].ToString() != "") { model.PolicyNum = ds.Tables[0].Rows[0]["PolicyNum"].ToString(); } if (ds.Tables[0].Rows[0]["PostPrice"] != null && ds.Tables[0].Rows[0]["PostPrice"].ToString() != "") { model.PostPrice = Convert.ToDecimal(ds.Tables[0].Rows[0]["PostPrice"].ToString()); } if (ds.Tables[0].Rows[0]["InsurancePrice"] != null && ds.Tables[0].Rows[0]["InsurancePrice"].ToString() != "") { model.InsurancePrice = Convert.ToDecimal(ds.Tables[0].Rows[0]["InsurancePrice"].ToString()); } if (ds.Tables[0].Rows[0]["CouponPrice"] != null && ds.Tables[0].Rows[0]["CouponPrice"].ToString() != "") { model.CouponPrice = Convert.ToDecimal(ds.Tables[0].Rows[0]["CouponPrice"].ToString()); } if (ds.Tables[0].Rows[0]["LinkMan"] != null && ds.Tables[0].Rows[0]["LinkMan"].ToString() != "") { model.LinkMan = ds.Tables[0].Rows[0]["LinkMan"].ToString(); } if (ds.Tables[0].Rows[0]["LinkMobile"] != null && ds.Tables[0].Rows[0]["LinkMobile"].ToString() != "") { model.LinkMobile = ds.Tables[0].Rows[0]["LinkMobile"].ToString(); } if (ds.Tables[0].Rows[0]["Address"] != null && ds.Tables[0].Rows[0]["Address"].ToString() != "") { model.Address = ds.Tables[0].Rows[0]["Address"].ToString(); } if (ds.Tables[0].Rows[0]["Needsheet"] != null && ds.Tables[0].Rows[0]["Needsheet"].ToString() != "") { model.Needsheet = ds.Tables[0].Rows[0]["Needsheet"].ToString(); } if (ds.Tables[0].Rows[0]["Aircode"] != null && ds.Tables[0].Rows[0]["Aircode"].ToString() != "") { model.Aircode = ds.Tables[0].Rows[0]["Aircode"].ToString(); } if (ds.Tables[0].Rows[0]["DepCity"] != null && ds.Tables[0].Rows[0]["DepCity"].ToString() != "") { model.DepCity = ds.Tables[0].Rows[0]["DepCity"].ToString(); } if (ds.Tables[0].Rows[0]["ArrCity"] != null && ds.Tables[0].Rows[0]["ArrCity"].ToString() != "") { model.ArrCity = ds.Tables[0].Rows[0]["ArrCity"].ToString(); } if (ds.Tables[0].Rows[0]["Flight"] != null && ds.Tables[0].Rows[0]["Flight"].ToString() != "") { model.Flight = ds.Tables[0].Rows[0]["Flight"].ToString(); } if (ds.Tables[0].Rows[0]["FlightModel"] != null && ds.Tables[0].Rows[0]["FlightModel"].ToString() != "") { model.FlightModel = ds.Tables[0].Rows[0]["FlightModel"].ToString(); } if (ds.Tables[0].Rows[0]["Cabin"] != null && ds.Tables[0].Rows[0]["Cabin"].ToString() != "") { model.Cabin = ds.Tables[0].Rows[0]["Cabin"].ToString(); } if (ds.Tables[0].Rows[0]["DepDate"] != null && ds.Tables[0].Rows[0]["DepDate"].ToString() != "") { model.DepDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["DepDate"].ToString()); } if (ds.Tables[0].Rows[0]["DepTime"] != null && ds.Tables[0].Rows[0]["DepTime"].ToString() != "") { model.DepTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["DepTime"].ToString()); } if (ds.Tables[0].Rows[0]["ArrTime"] != null && ds.Tables[0].Rows[0]["LinkMobile"].ToString() != "") { model.ArrTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["ArrTime"].ToString()); } if (ds.Tables[0].Rows[0]["YPrice"] != null && ds.Tables[0].Rows[0]["YPrice"].ToString() != "") { model.YPrice = Convert.ToDecimal(ds.Tables[0].Rows[0]["YPrice"].ToString()); } if (ds.Tables[0].Rows[0]["Discount"] != null && ds.Tables[0].Rows[0]["Discount"].ToString() != "") { model.Discount = Convert.ToDecimal(ds.Tables[0].Rows[0]["Discount"].ToString()); } if (ds.Tables[0].Rows[0]["Depterminal"] != null && ds.Tables[0].Rows[0]["Depterminal"].ToString() != "") { model.Depterminal = ds.Tables[0].Rows[0]["Depterminal"].ToString(); } if (ds.Tables[0].Rows[0]["Arrterminal"] != null && ds.Tables[0].Rows[0]["Arrterminal"].ToString() != "") { model.Arrterminal = ds.Tables[0].Rows[0]["Arrterminal"].ToString(); } if (ds.Tables[0].Rows[0]["Airportfee"] != null && ds.Tables[0].Rows[0]["Airportfee"].ToString() != "") { model.Airportfee = Convert.ToDecimal(ds.Tables[0].Rows[0]["Airportfee"].ToString()); } if (ds.Tables[0].Rows[0]["Fuelfee"] != null && ds.Tables[0].Rows[0]["Fuelfee"].ToString() != "") { model.Fuelfee = Convert.ToDecimal(ds.Tables[0].Rows[0]["Fuelfee"].ToString()); } if (ds.Tables[0].Rows[0]["Staynum"] != null && ds.Tables[0].Rows[0]["Staynum"].ToString() != "") { model.Staynum = Convert.ToDecimal(ds.Tables[0].Rows[0]["Staynum"].ToString()); } if (ds.Tables[0].Rows[0]["AirName"] != null && ds.Tables[0].Rows[0]["AirName"].ToString() != "") { model.AirName = ds.Tables[0].Rows[0]["AirName"].ToString(); } if (ds.Tables[0].Rows[0]["DepcityName"] != null && ds.Tables[0].Rows[0]["DepcityName"].ToString() != "") { model.DepcityName = ds.Tables[0].Rows[0]["DepcityName"].ToString(); } if (ds.Tables[0].Rows[0]["ArrcityName"] != null && ds.Tables[0].Rows[0]["ArrcityName"].ToString() != "") { model.ArrcityName = ds.Tables[0].Rows[0]["ArrcityName"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_TicketOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_TicketOrder("); strSql.Append("OrdeID,UserID,AddDate,Status,PayPrice,Totaltax,TicketPrice,PolicyNum,PostPrice,InsurancePrice,CouponPrice,LinkMan,LinkMobile,Address,Needsheet,Aircode,DepCity,ArrCity,Flight,FlightModel,Cabin,DepDate,DepTime,ArrTime,YPrice,Discount,Depterminal,Arrterminal,Airportfee,Fuelfee,Staynum,AirName,DepcityName,ArrcityName)"); strSql.Append(" values ("); strSql.Append("@OrdeID,@UserID,@AddDate,@Status,@PayPrice,@Totaltax,@TicketPrice,@PolicyNum,@PostPrice,@InsurancePrice,@CouponPrice,@LinkMan,@LinkMobile,@Address,@Needsheet,@Aircode,@DepCity,@ArrCity,@Flight,@FlightModel,@Cabin,@DepDate,@DepTime,@ArrTime,@YPrice,@Discount,@Depterminal,@Arrterminal,@Airportfee,@Fuelfee,@Staynum,@AirName,@DepcityName,@ArrcityName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@OrdeID", SqlDbType.VarChar, 100), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@PayPrice", SqlDbType.Decimal), new SqlParameter("@Totaltax", SqlDbType.Decimal), new SqlParameter("@TicketPrice", SqlDbType.Decimal), new SqlParameter("@PolicyNum", SqlDbType.VarChar), new SqlParameter("@PostPrice", SqlDbType.Decimal), new SqlParameter("@InsurancePrice", SqlDbType.Decimal), new SqlParameter("@CouponPrice", SqlDbType.Decimal), new SqlParameter("@LinkMan", SqlDbType.VarChar), new SqlParameter("@LinkMobile", SqlDbType.VarChar), new SqlParameter("@Address", SqlDbType.VarChar), new SqlParameter("@Needsheet", SqlDbType.VarChar), new SqlParameter("@Aircode", SqlDbType.VarChar), new SqlParameter("@DepCity", SqlDbType.VarChar), new SqlParameter("@ArrCity", SqlDbType.VarChar), new SqlParameter("@Flight", SqlDbType.VarChar), new SqlParameter("@FlightModel", SqlDbType.VarChar), new SqlParameter("@Cabin", SqlDbType.VarChar), new SqlParameter("@DepDate", SqlDbType.DateTime), new SqlParameter("@DepTime", SqlDbType.DateTime), new SqlParameter("@ArrTime", SqlDbType.DateTime), new SqlParameter("@YPrice", SqlDbType.Decimal), new SqlParameter("@Discount", SqlDbType.Decimal), new SqlParameter("@Depterminal", SqlDbType.VarChar), new SqlParameter("@Arrterminal", SqlDbType.VarChar), new SqlParameter("@Airportfee", SqlDbType.Decimal), new SqlParameter("@Fuelfee", SqlDbType.Decimal), new SqlParameter("@Staynum", SqlDbType.Decimal), new SqlParameter("@AirName", SqlDbType.VarChar), new SqlParameter("@DepcityName", SqlDbType.VarChar), new SqlParameter("@ArrcityName", SqlDbType.VarChar) }; parameters[0].Value = model.OrdeID; parameters[1].Value = model.UserID; parameters[2].Value = model.AddDate; parameters[3].Value = model.Status; parameters[4].Value = model.PayPrice; parameters[5].Value = model.Totaltax; parameters[6].Value = model.TicketPrice; parameters[7].Value = model.PolicyNum; parameters[8].Value = model.PostPrice; parameters[9].Value = model.InsurancePrice; parameters[10].Value = model.CouponPrice; parameters[11].Value = model.LinkMan; parameters[12].Value = model.LinkMobile; parameters[13].Value = model.Address; parameters[14].Value = model.Needsheet; parameters[15].Value = model.Aircode; parameters[16].Value = model.DepCity; parameters[17].Value = model.ArrCity; parameters[18].Value = model.Flight; parameters[19].Value = model.FlightModel; parameters[20].Value = model.Cabin; parameters[21].Value = model.DepDate; parameters[22].Value = model.DepTime; parameters[23].Value = model.ArrTime; parameters[24].Value = model.YPrice; parameters[25].Value = model.Discount; parameters[26].Value = model.Depterminal; parameters[27].Value = model.Arrterminal; parameters[28].Value = model.Airportfee; parameters[29].Value = model.Fuelfee; parameters[30].Value = model.Staynum; parameters[31].Value = model.AirName; parameters[32].Value = model.DepcityName; parameters[33].Value = model.ArrcityName; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_TicketOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_TicketOrder set "); strSql.Append("OrdeID=@OrdeID,"); strSql.Append("UserID=@UserID,"); strSql.Append("AddDate=@AddDate,"); strSql.Append("Status=@Status,"); strSql.Append("PayPrice=@PayPrice,"); strSql.Append("Totaltax=@Totaltax,"); strSql.Append("TicketPrice=@TicketPrice,"); strSql.Append("PolicyNum=@PolicyNum,"); strSql.Append("PostPrice=@PostPrice,"); strSql.Append("InsurancePrice=@InsurancePrice,"); strSql.Append("CouponPrice=@CouponPrice,"); strSql.Append("LinkMan=@LinkMan,"); strSql.Append("LinkMobile=@LinkMobile,"); strSql.Append("Address=@Address,"); strSql.Append("Needsheet=@Needsheet,"); strSql.Append("Aircode=@Aircode,"); strSql.Append("DepCity=@DepCity,"); strSql.Append("ArrCity=@ArrCity,"); strSql.Append("Flight=@Flight,"); strSql.Append("FlightModel=@FlightModel,"); strSql.Append("Cabin=@Cabin,"); strSql.Append("DepDate=@DepDate,"); strSql.Append("DepTime=@DepTime,"); strSql.Append("ArrTime=@ArrTime,"); strSql.Append("YPrice=@YPrice,"); strSql.Append("Discount=@Discount,"); strSql.Append("Depterminal=@Depterminal,"); strSql.Append("Arrterminal=@Arrterminal,"); strSql.Append("Airportfee=@Airportfee,"); strSql.Append("Fuelfee=@Fuelfee,"); strSql.Append("Staynum=@Staynum,"); strSql.Append("AirName=@AirName,"); strSql.Append("DepcityName=@DepcityName,"); strSql.Append("ArrcityName=@ArrcityName"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@OrdeID", SqlDbType.VarChar, 100), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@PayPrice", SqlDbType.Decimal), new SqlParameter("@Totaltax", SqlDbType.Decimal), new SqlParameter("@TicketPrice", SqlDbType.Decimal), new SqlParameter("@PolicyNum", SqlDbType.VarChar), new SqlParameter("@PostPrice", SqlDbType.Decimal), new SqlParameter("@InsurancePrice", SqlDbType.Decimal), new SqlParameter("@CouponPrice", SqlDbType.Decimal), new SqlParameter("@LinkMan", SqlDbType.VarChar), new SqlParameter("@LinkMobile", SqlDbType.VarChar), new SqlParameter("@Address", SqlDbType.VarChar), new SqlParameter("@Needsheet", SqlDbType.VarChar), new SqlParameter("@Aircode", SqlDbType.VarChar), new SqlParameter("@DepCity", SqlDbType.VarChar), new SqlParameter("@ArrCity", SqlDbType.VarChar), new SqlParameter("@Flight", SqlDbType.VarChar), new SqlParameter("@FlightModel", SqlDbType.VarChar), new SqlParameter("@Cabin", SqlDbType.VarChar), new SqlParameter("@DepDate", SqlDbType.DateTime), new SqlParameter("@DepTime", SqlDbType.DateTime), new SqlParameter("@ArrTime", SqlDbType.DateTime), new SqlParameter("@YPrice", SqlDbType.Decimal), new SqlParameter("@Discount", SqlDbType.Decimal), new SqlParameter("@Depterminal", SqlDbType.VarChar), new SqlParameter("@Arrterminal", SqlDbType.VarChar), new SqlParameter("@Airportfee", SqlDbType.Decimal), new SqlParameter("@Fuelfee", SqlDbType.Decimal), new SqlParameter("@Staynum", SqlDbType.Decimal), new SqlParameter("@AirName", SqlDbType.VarChar), new SqlParameter("@DepcityName", SqlDbType.VarChar), new SqlParameter("@ArrcityName", SqlDbType.VarChar), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.OrdeID; parameters[1].Value = model.UserID; parameters[2].Value = model.AddDate; parameters[3].Value = model.Status; parameters[4].Value = model.PayPrice; parameters[5].Value = model.Totaltax; parameters[6].Value = model.TicketPrice; parameters[7].Value = model.PolicyNum; parameters[8].Value = model.PostPrice; parameters[9].Value = model.InsurancePrice; parameters[10].Value = model.CouponPrice; parameters[11].Value = model.LinkMan; parameters[12].Value = model.LinkMobile; parameters[13].Value = model.Address; parameters[14].Value = model.Needsheet; parameters[15].Value = model.Aircode; parameters[16].Value = model.DepCity; parameters[17].Value = model.ArrCity; parameters[18].Value = model.Flight; parameters[19].Value = model.FlightModel; parameters[20].Value = model.Cabin; parameters[21].Value = model.DepDate; parameters[22].Value = model.DepTime; parameters[23].Value = model.ArrTime; parameters[24].Value = model.YPrice; parameters[25].Value = model.Discount; parameters[26].Value = model.Depterminal; parameters[27].Value = model.Arrterminal; parameters[28].Value = model.Airportfee; parameters[29].Value = model.Fuelfee; parameters[30].Value = model.Staynum; parameters[31].Value = model.AirName; parameters[32].Value = model.DepcityName; parameters[33].Value = model.ArrcityName; parameters[34].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
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"; lgk.Model.tb_TicketBack Model = new lgk.Model.tb_TicketBack(); if (context.Request["type"] == null) { s = s + "没有回调\r\n"; context.Response.Write("没有回调数据"); } else { Model.Type = context.Request["type"]; if (Model.Type == "0") { Model.OrderNo = context.Request["orderno"]; Model.OrderStatus = context.Request["orderstatus"]; Model.Reason = context.Request["reason"]; } else if (Model.Type == "1") { Model.OrderNo = context.Request["orderno"]; Model.OrderStatus = context.Request["orderstatus"]; Model.TicketNos = context.Request["ticketnos"]; } else if (Model.Type == "3") { Model.FefundMoney = context.Request["fefundmoney"]; Model.PoundageFee = context.Request["poundagefee"]; Model.Reason = context.Request["fefunstatemsg"]; Model.OrderStatus = context.Request["fefundstate"]; Model.OrderNo = context.Request["fefundno"]; } Model.Sign = context.Request["sign"]; s = s + "接受内容信息:通知类型:" + Model.Type + ",订单号:" + Model.OrderNo + ",订单状态:" + Model.OrderStatus + ",返回结果集:" + Model.Reason + "\r\n"; if (Model != null) { lgk.Model.tb_TicketBack Modelreback = orderCallbll.GetModel(" OrderNo='" + Model.OrderNo + "'"); if (Modelreback == null) { if (orderCallbll.Add(Model) > 0) { lgk.Model.tb_TicketOrder order = orderBLL.GetModel("OrdeID='" + Model.OrderNo + "'"); if (order != null) { if (orderBLL.UpdateStatus(Convert.ToInt32(Model.OrderStatus), 1, Model.OrderNo)) { s = s + "更新订单状态成功,订单状态为:" + StateCode(Model.OrderStatus.ToString()) + "\r\n"; //退票退款通知 返还金额到账户 if (Model.Type == "3" || Model.Type == "0" || Model.OrderStatus != "3") { lgk.Model.tb_user model = userBLL.GetModel(order.UserID); model.Emoney += Convert.ToDecimal(order.PayPrice); userBLL.Update(model); string bramk = "退票退款:" + order.PayPrice; ac.AddJournal(Convert.ToInt32(order.UserID), bramk, Convert.ToDecimal(order.PayPrice), 0, model.Emoney, 1); bllaccount.UpdateBanlcen("TicketAccount", Convert.ToDecimal(order.PayPrice), 2); } context.Response.Write("SUCCESS"); } } else { s = s + "订单不存在\r\n"; context.Response.Write("订单不存在"); } } } else { if (orderCallbll.Update(Model)) { lgk.Model.tb_TicketOrder order = orderBLL.GetModel("OrdeID='" + Model.OrderNo + "'"); if (order != null) { if (orderBLL.UpdateStatus(Convert.ToInt32(Model.OrderStatus), 1, Model.OrderNo)) { s = s + "更新订单状态成功,订单状态为:" + StateCode(Model.OrderStatus.ToString()) + "\r\n"; //退票退款通知 返还金额到账户 if (Model.Type == "3" || Model.Type == "0" || Model.OrderStatus != "3") { lgk.Model.tb_user model = userBLL.GetModel(order.UserID); model.Emoney += Convert.ToDecimal(Model.FefundMoney); userBLL.Update(model); string bramk = "退票退款"; ac.AddJournal(Convert.ToInt32(order.UserID), bramk, Convert.ToDecimal(Model.FefundMoney), 0, model.Emoney, 1); bllaccount.UpdateBanlcen("TicketAccount", Convert.ToDecimal(Model.FefundMoney), 2); } } } else { s = s + "订单不存在\r\n"; context.Response.Write("订单不存在"); } } 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/RequesTicketBacklog/RequestBacklog" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + ".txt"), s); }