/// <summary>
/// 查询订单状态
/// </summary>
/// <param name="dic"></param>
/// <param name="dic1"></param>
/// <param name="dic2"></param>
/// <returns></returns>
public string Getorder(Dictionary <string, string> dic, Dictionary <string, string> dic1, Dictionary <string, string> dic2)
{
try
{
string spond = RequestSumit(dic2, orderStatusUrl, "getorder");
var backmodel = JsonConvert.DeserializeObject <OrderQuery>(spond);
if (backmodel.error_code == "0")
{
lgk.Model.tb_TrainTicketsOrder model = bllorder.GetModel("OrderCode='" + backmodel.result.user_orderid + "'");
//更新订单状态
model.State = Convert.ToInt32(backmodel.result.status);
if (bllorder.Update(model))
{
for (int i = 0; i < backmodel.result.passengers.Count; i++)
{
// bllorderdeil.UpdateStatus(backmodel.result.passengers[i].cxin, Convert.ToInt32(backmodel.result.status), model.ID, Convert.ToInt32(backmodel.result.passengers[i].passengerid));
bllorderdeil.UpdateStatus("", Convert.ToInt32(backmodel.result.status), model.ID, Convert.ToInt32(backmodel.result.passengers[i].passengerid));
}
}
}
return(spond);
}
catch (Exception)
{
return("{\"reason\":\"error\",\"error_code\":\"1\",\"info\":\"查询异常\"}");
}
}
public string CancelOrder(Dictionary <string, string> dic, Dictionary <string, string> dic1, Dictionary <string, string> dic2)
{
string respon = RequestSumit(dic2, dic1["RequestUrl"].ToString(), dic["act"].ToLower());
if (respon != "error")
{
var Result = JsonConvert.DeserializeObject <RespondResult>(respon);
if (Result.result != null)
{
dic2.Add("OrderID", Result.result.orderid);
if (Result.result != null)
{
//更改本地订单状态
lgk.Model.tb_TrainTicketsOrder order = bllorder.GetModel("OrderID='" + Result.result.orderid + "'");
order.State = Convert.ToInt32(Result.result.status);
bllorder.Update(order);
//取消订单返还账户金额
//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);
}
}
return(respon);
}
else
{
return("{\"reason\":\"error\",\"error_code\":\"1\",\"info\":\"请求取消订单失败\"}");
}
}
/// <summary>
/// 请求出票(支付)
/// </summary>
/// <param name="dic"></param>
/// <param name="dic2"></param>
/// <returns></returns>
public string Pay(Dictionary <string, string> dic, Dictionary <string, string> dic2)
{
lgk.Model.tb_TrainTicketsOrder model = bllorder.GetModel("OrderID='" + dic2["orderid"].ToString() + "'");
List <lgk.Model.tb_TrainTicketsOrderDetail> list = bllorderdeil.GetModelList("OrderID=" + model.ID);
var user = userBLL.GetModel(model.UserID);
if (user.SecondPassword.Equals(Util.GetMD5(dic["paypwd"].ToString()).ToUpper()))
{
if (user.IsLock == 1)
{
return("{\"reason\":\"error\",\"error_code\":\"1\",\"info\":\"账户已冻结，提交失败\"}");
}
if (user.Emoney < model.OrderPrice)
{
return("{\"reason\":\"error\",\"error_code\":\"1\",\"info\":\"注册分余额不足\"}");
}
else
{
Bonus(user, model.OrderPrice);
//扣除注册分金额
bllaccount.UpdateBanlcen("TrainAccount", model.OrderPrice + 3 * list.Count, 1);
return(RequestSumit(dic2, payUrl, "pay"));
}
}
else
{
return("{\"reason\":\"error\",\"error_code\":\"1\",\"info\":\"支付密码不正确\"}");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_TrainTicketsOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_TrainTicketsOrder(");
strSql.Append("OrderCode,ISAcceptStanding,FromStationCode,ToStationCode,CheCi,TrainDate,UserID,OrderID,State,FromStationName,ToStationName,FromStationDate,ToStationDate,OrderPrice,LinkMan,LinkPhone)");
strSql.Append(" values (");
strSql.Append("@OrderCode,@ISAcceptStanding,@FromStationCode,@ToStationCode,@CheCi,@TrainDate,@UserID,@OrderID,@State,@FromStationName,@ToStationName,@FromStationDate,@ToStationDate,@OrderPrice,@LinkMan,@LinkPhone)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@OrderCode", SqlDbType.VarChar, 100),
new SqlParameter("@ISAcceptStanding", SqlDbType.VarChar, 100),
new SqlParameter("@FromStationCode", SqlDbType.VarChar, 100),
new SqlParameter("@ToStationCode", SqlDbType.VarChar, 100),
new SqlParameter("@CheCi", SqlDbType.VarChar, 100),
new SqlParameter("@TrainDate", SqlDbType.DateTime),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@OrderID", SqlDbType.VarChar),
new SqlParameter("@State", SqlDbType.Int),
new SqlParameter("@FromStationName", SqlDbType.VarChar),
new SqlParameter("@ToStationName", SqlDbType.VarChar),
new SqlParameter("@FromStationDate", SqlDbType.VarChar),
new SqlParameter("@ToStationDate", SqlDbType.VarChar),
new SqlParameter("@OrderPrice", SqlDbType.Decimal),
new SqlParameter("@LinkMan", SqlDbType.VarChar),
new SqlParameter("@LinkPhone", SqlDbType.VarChar)
};
parameters[0].Value = model.OrderCode;
parameters[1].Value = model.ISAcceptStanding;
parameters[2].Value = model.FromStationCode;
parameters[3].Value = model.ToStationCode;
parameters[4].Value = model.CheCi;
parameters[5].Value = model.TrainDate;
parameters[6].Value = model.UserID;
parameters[7].Value = model.OrderID;
parameters[8].Value = model.State;
parameters[9].Value = model.FromStationName;
parameters[10].Value = model.ToStationName;
parameters[11].Value = model.FromStationDate;
parameters[12].Value = model.ToStationDate;
parameters[13].Value = model.OrderPrice;
parameters[14].Value = model.LinkMan;
parameters[15].Value = model.LinkPhone;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void Page_Load(object sender, EventArgs e)
{
orderid = Request["orderid"].ToString();
lgk.Model.tb_TrainTicketsOrder model = bllorder.GetModel("OrderID='" + orderid + "'");
orderid = model.OrderCode;
orderdate = model.FromStationDate.ToString();
price = model.OrderPrice.ToString();
checi = model.CheCi;
weizhi = model.FromStationName + "-" + model.ToStationName;
uid.Value = model.UserID.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
orderid = Request["ordercode"].ToString();
lgk.Model.tb_TrainTicketsOrder model = bllorder.GetModel("OrderID='" + orderid + "'");
if (model != null)
{
piaodate = Convert.ToDateTime(model.FromStationDate).ToString("yyyy-MM-dd");
trancode = model.CheCi;
starttime = Convert.ToDateTime(model.FromStationDate).ToShortTimeString();
startstationname = model.FromStationName;
arrivetime = Convert.ToDateTime(model.ToStationDate).ToShortTimeString();
endstationname = model.ToStationName;
usercode = model.LinkMan;
linkphone = model.LinkPhone;
// orderinfo = Request["orderinfo"].ToString();
price = model.OrderPrice.ToString();
orderid = model.OrderCode;
uid.Value = model.UserID.ToString();
ordercode.Value = model.OrderID;
status.Value = model.State.ToString();
states = States(model.State.ToString());
List <lgk.Model.tb_TrainTicketsOrderDetail> 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].PassengerseName;
ordermodel.idcard = modeldite[i].PassportseNO;
if (modeldite[i].InsuranceID != 0)
{
ordermodel.insurance = "1份";
}
else if (modeldite[i].InsuranceID == 0)
{
ordermodel.insurance = "无";
}
order.Add(ordermodel);
}
DataSet ds = DataSetList(order);
bind_repeater(ds, Repeater1, "idcard");
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('系统异常，异常信息：" + ex.Message + "');", true);
}
}
}
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>
/// <param name="dic"></param>
/// <returns></returns>
public int OrderHandle(Dictionary <string, string> dic)
{
int result = 0;
try
{
lgk.Model.tb_TrainTicketsOrder order = new lgk.Model.tb_TrainTicketsOrder();
lgk.Model.tb_TrainTicketsOrderDetail orderdateil = new lgk.Model.tb_TrainTicketsOrderDetail();
lgk.Model.tb_Insurance insurance = new lgk.Model.tb_Insurance();
//订单信息
order.OrderCode = dic["user_orderid"].ToString().Trim();
order.ISAcceptStanding = dic["is_accept_standing"].ToString().Trim();
order.FromStationCode = dic["from_station_code"].ToString().Trim();
order.ToStationCode = dic["to_station_code"].ToString().Trim();
order.CheCi = dic["checi"].ToString().Trim();
order.TrainDate = DateTime.Now;
order.UserID = Convert.ToInt32(dic["UserID"].ToString());
order.State = 0;
order.OrderID = dic["OrderID"].ToString().Trim();
order.FromStationName = dic["FromStationName"].ToString().Trim();
order.ToStationName = dic["ToStationName"].ToString().Trim();
order.FromStationDate = dic["FromStationDate"].ToString().Trim();
order.ToStationDate = dic["ToStationDate"].ToString().Trim();
order.OrderPrice = Convert.ToDecimal(dic["OrderPrice"].ToString().Trim());
order.LinkMan = dic["LinkMan"].ToString().Trim();
order.LinkPhone = dic["LinkPhone"].ToString().Trim();
var orderdail = JsonConvert.DeserializeObject <List <passengers> >(dic["passengers"].ToString());
int id = bllorder.Add(order);
if (id > 0)
{
for (int i = 0; i < orderdail.Count; i++)
{
//订单乘客信息
orderdateil.OrderID = id;
orderdateil.PassengerseName = orderdail[i].passengersename;
orderdateil.PiaoType = orderdail[i].piaotype;
orderdateil.PiaotypeName = orderdail[i].piaotypename;
orderdateil.Passporttypeseid = orderdail[i].passporttypeseid;
orderdateil.PassporttypeseidName = orderdail[i].passporttypeseidname;
orderdateil.PassportseNO = orderdail[i].passportseno;
orderdateil.Price = orderdail[i].price;
orderdateil.ZWCode = orderdail[i].zwcode;
orderdateil.State = 0;
orderdateil.ZWName = orderdail[i].zwname;
orderdateil.PassengerId = Convert.ToInt32(orderdail[i].passengerid);
orderdateil.Disacount = 3;
if (orderdail[i].insurance.name != null)
{
//免费出行险
insurance.Name = orderdail[i].insurance.name;
insurance.Mobile = orderdail[i].insurance.mobile;
insurance.Gender = orderdail[i].insurance.gender;
insurance.Birth = orderdail[i].insurance.birth;
insurance.City = orderdail[i].insurance.city;
insurance.Idcard = orderdail[i].insurance.idcard;
int inid = bllince.Add(insurance);
if (inid > 0)
{
orderdateil.InsuranceID = inid;
}
}
else
{
orderdateil.InsuranceID = 0;
}
bllorderdeil.Add(orderdateil);
}
result = id;
}
else
{
result = 0;
}
}
catch (Exception ex)
{
result = -1;
}
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_TrainTicketsOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_TrainTicketsOrder set ");
strSql.Append("OrderCode=@OrderCode,");
strSql.Append("ISAcceptStanding=@ISAcceptStanding,");
strSql.Append("FromStationCode=@FromStationCode,");
strSql.Append("ToStationCode=@ToStationCode,");
strSql.Append("CheCi=@CheCi,");
strSql.Append("TrainDate=@TrainDate,");
strSql.Append("OrderID=@OrderID,");
strSql.Append("State=@State,");
strSql.Append("FromStationName=@FromStationName,");
strSql.Append("ToStationName=@ToStationName,");
strSql.Append("FromStationDate=@FromStationDate,");
strSql.Append("ToStationDate=@ToStationDate,");
strSql.Append("OrderPrice=@OrderPrice,");
strSql.Append("LinkMan=@LinkMan,");
strSql.Append("LinkPhone=@LinkPhone");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@OrderCode", SqlDbType.VarChar, 100),
new SqlParameter("@ISAcceptStanding", SqlDbType.VarChar, 100),
new SqlParameter("@FromStationCode", SqlDbType.VarChar, 100),
new SqlParameter("@ToStationCode", SqlDbType.VarChar, 100),
new SqlParameter("@CheCi", SqlDbType.VarChar, 100),
new SqlParameter("@TrainDate", SqlDbType.DateTime),
new SqlParameter("@OrderID", SqlDbType.VarChar),
new SqlParameter("@State", SqlDbType.Int),
new SqlParameter("@FromStationName", SqlDbType.VarChar),
new SqlParameter("@ToStationName", SqlDbType.VarChar),
new SqlParameter("@FromStationDate", SqlDbType.VarChar),
new SqlParameter("@ToStationDate", SqlDbType.VarChar),
new SqlParameter("@OrderPrice", SqlDbType.Decimal),
new SqlParameter("@LinkMan", SqlDbType.VarChar),
new SqlParameter("@LinkPhone", SqlDbType.VarChar),
new SqlParameter("@ID", SqlDbType.Int)
};
parameters[0].Value = model.OrderCode;
parameters[1].Value = model.ISAcceptStanding;
parameters[2].Value = model.FromStationCode;
parameters[3].Value = model.ToStationCode;
parameters[4].Value = model.CheCi;
parameters[5].Value = model.TrainDate;
parameters[6].Value = model.OrderID;
parameters[7].Value = model.State;
parameters[8].Value = model.FromStationName;
parameters[9].Value = model.ToStationName;
parameters[10].Value = model.FromStationDate;
parameters[11].Value = model.ToStationDate;
parameters[12].Value = model.OrderPrice;
parameters[13].Value = model.LinkMan;
parameters[14].Value = model.LinkPhone;
parameters[15].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public lgk.Model.tb_TrainTicketsOrder GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,OrderCode,ISAcceptStanding,FromStationCode,ToStationCode,CheCi,TrainDate,UserID,OrderID,State,FromStationName,ToStationName,FromStationDate,ToStationDate,OrderPrice,LinkMan,LinkPhone from tb_TrainTicketsOrder t ");
strSql.Append(" where " + where);
lgk.Model.tb_TrainTicketsOrder model = new lgk.Model.tb_TrainTicketsOrder();
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]["OrderCode"] != null && ds.Tables[0].Rows[0]["OrderCode"].ToString() != "")
{
model.OrderCode = ds.Tables[0].Rows[0]["OrderCode"].ToString();
}
if (ds.Tables[0].Rows[0]["ISAcceptStanding"] != null && ds.Tables[0].Rows[0]["ISAcceptStanding"].ToString() != "")
{
model.ISAcceptStanding = ds.Tables[0].Rows[0]["ISAcceptStanding"].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]["ToStationCode"] != null && ds.Tables[0].Rows[0]["ToStationCode"].ToString() != "")
{
model.ToStationCode = ds.Tables[0].Rows[0]["ToStationCode"].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]["TrainDate"] != null && ds.Tables[0].Rows[0]["TrainDate"].ToString() != "")
{
model.TrainDate = DateTime.Parse(ds.Tables[0].Rows[0]["TrainDate"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].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]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = Convert.ToInt32(ds.Tables[0].Rows[0]["State"].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]["ToStationName"] != null && ds.Tables[0].Rows[0]["ToStationName"].ToString() != "")
{
model.ToStationName = ds.Tables[0].Rows[0]["ToStationName"].ToString();
}
if (ds.Tables[0].Rows[0]["FromStationDate"] != null && ds.Tables[0].Rows[0]["FromStationDate"].ToString() != "")
{
model.FromStationDate = ds.Tables[0].Rows[0]["FromStationDate"].ToString();
}
if (ds.Tables[0].Rows[0]["ToStationDate"] != null && ds.Tables[0].Rows[0]["ToStationDate"].ToString() != "")
{
model.ToStationDate = ds.Tables[0].Rows[0]["ToStationDate"].ToString();
}
if (ds.Tables[0].Rows[0]["OrderPrice"] != null && ds.Tables[0].Rows[0]["OrderPrice"].ToString() != "")
{
model.OrderPrice = Convert.ToDecimal(ds.Tables[0].Rows[0]["OrderPrice"].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]["LinkPhone"] != null && ds.Tables[0].Rows[0]["LinkPhone"].ToString() != "")
{
model.LinkPhone = ds.Tables[0].Rows[0]["LinkPhone"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_TrainTicketsOrder model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_TrainTicketsOrder model)
{
return(dal.Add(model));
}
