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