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