/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_TrainTicketsOrderDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_TrainTicketsOrderDetail set "); strSql.Append("OrderID=@OrderID,"); strSql.Append("PassengerseName=@PassengerseName,"); strSql.Append("PiaoType=@PiaoType,"); strSql.Append("PiaotypeName=@PiaotypeName,"); strSql.Append("Passporttypeseid=@Passporttypeseid,"); strSql.Append("PassporttypeseidName=@PassporttypeseidName,"); strSql.Append("PassportseNO=@PassportseNO,"); strSql.Append("Price=@Price,"); strSql.Append("ZWCode=@ZWCode,"); strSql.Append("ZWName=@ZWName,"); strSql.Append("InsuranceID=@InsuranceID"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.Int), new SqlParameter("@PassengerseName", SqlDbType.VarChar, 100), new SqlParameter("@PiaoType", SqlDbType.Int), new SqlParameter("@PiaotypeName", SqlDbType.VarChar, 100), new SqlParameter("@Passporttypeseid", SqlDbType.Int), new SqlParameter("@PassporttypeseidName", SqlDbType.VarChar, 100), new SqlParameter("@PassportseNO", SqlDbType.VarChar, 100), new SqlParameter("@Price", SqlDbType.Decimal), new SqlParameter("@ZWCode", SqlDbType.VarChar, 100), new SqlParameter("@ZWName", SqlDbType.VarChar, 100), new SqlParameter("@InsuranceID", SqlDbType.Int), new SqlParameter("@Cxin", SqlDbType.VarChar, 100), new SqlParameter("@State", SqlDbType.Int), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.OrderID; parameters[1].Value = model.PassengerseName; parameters[2].Value = model.PiaoType; parameters[3].Value = model.PiaotypeName; parameters[4].Value = model.Passporttypeseid; parameters[5].Value = model.PassporttypeseidName; parameters[6].Value = model.PassportseNO; parameters[7].Value = model.Price; parameters[8].Value = model.ZWCode; parameters[9].Value = model.ZWName; parameters[10].Value = model.InsuranceID; parameters[11].Value = model.Cxin; parameters[12].Value = model.State; parameters[13].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_TrainTicketsOrderDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_TrainTicketsOrderDetail("); strSql.Append("OrderID,PassengerseName,PiaoType,PiaotypeName,Passporttypeseid,PassporttypeseidName,PassportseNO,Price,ZWCode,ZWName,InsuranceID,Cxin,State,PassengerId,Disacount)"); strSql.Append(" values ("); strSql.Append("@OrderID,@PassengerseName,@PiaoType,@PiaotypeName,@Passporttypeseid,@PassporttypeseidName,@PassportseNO,@Price,@ZWCode,@ZWName,@InsuranceID,@Cxin,@State,@PassengerId,@Disacount)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.Int), new SqlParameter("@PassengerseName", SqlDbType.VarChar, 100), new SqlParameter("@PiaoType", SqlDbType.Int), new SqlParameter("@PiaotypeName", SqlDbType.VarChar, 100), new SqlParameter("@Passporttypeseid", SqlDbType.Int), new SqlParameter("@PassporttypeseidName", SqlDbType.VarChar, 100), new SqlParameter("@PassportseNO", SqlDbType.VarChar, 100), new SqlParameter("@Price", SqlDbType.Decimal), new SqlParameter("@ZWCode", SqlDbType.VarChar, 100), new SqlParameter("@ZWName", SqlDbType.VarChar, 100), new SqlParameter("@InsuranceID", SqlDbType.Int), new SqlParameter("@Cxin", SqlDbType.VarChar, 100), new SqlParameter("@State", SqlDbType.Int), new SqlParameter("@PassengerId", SqlDbType.Int), new SqlParameter("@Disacount", SqlDbType.Decimal) }; parameters[0].Value = model.OrderID; parameters[1].Value = model.PassengerseName; parameters[2].Value = model.PiaoType; parameters[3].Value = model.PiaotypeName; parameters[4].Value = model.Passporttypeseid; parameters[5].Value = model.PassporttypeseidName; parameters[6].Value = model.PassportseNO; parameters[7].Value = model.Price; parameters[8].Value = model.ZWCode; parameters[9].Value = model.ZWName; parameters[10].Value = model.InsuranceID; parameters[11].Value = model.Cxin; parameters[12].Value = model.State; parameters[13].Value = model.PassengerId; parameters[14].Value = model.Disacount; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <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); }
public lgk.Model.tb_TrainTicketsOrderDetail GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,OrderID,PassengerseName,PiaoType,PiaotypeName,Passporttypeseid,PassporttypeseidName,PassportseNO,Price,ZWCode,ZWName,InsuranceID,Cxin,State,PassengerId,Disacount from tb_TrainTicketsOrderDetail "); strSql.Append(" where " + where); lgk.Model.tb_TrainTicketsOrderDetail model = new lgk.Model.tb_TrainTicketsOrderDetail(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["OrderID"] != null && ds.Tables[0].Rows[0]["OrderID"].ToString() != "") { model.OrderID = Convert.ToInt32(ds.Tables[0].Rows[0]["OrderID"].ToString()); } if (ds.Tables[0].Rows[0]["PassengerseName"] != null && ds.Tables[0].Rows[0]["PassengerseName"].ToString() != "") { model.PassengerseName = ds.Tables[0].Rows[0]["PassengerseName"].ToString(); } if (ds.Tables[0].Rows[0]["PiaoType"] != null && ds.Tables[0].Rows[0]["PiaoType"].ToString() != "") { model.PiaoType = Convert.ToInt32(ds.Tables[0].Rows[0]["PiaoType"].ToString()); } if (ds.Tables[0].Rows[0]["PiaotypeName"] != null && ds.Tables[0].Rows[0]["PiaotypeName"].ToString() != "") { model.PiaotypeName = ds.Tables[0].Rows[0]["PiaotypeName"].ToString(); } if (ds.Tables[0].Rows[0]["Passporttypeseid"] != null && ds.Tables[0].Rows[0]["Passporttypeseid"].ToString() != "") { model.Passporttypeseid = Convert.ToInt32(ds.Tables[0].Rows[0]["Passporttypeseid"].ToString()); } if (ds.Tables[0].Rows[0]["PassporttypeseidName"] != null && ds.Tables[0].Rows[0]["PassporttypeseidName"].ToString() != "") { model.PassporttypeseidName = ds.Tables[0].Rows[0]["PassporttypeseidName"].ToString(); } if (ds.Tables[0].Rows[0]["PassportseNO"] != null && ds.Tables[0].Rows[0]["PassportseNO"].ToString() != "") { model.PassportseNO = ds.Tables[0].Rows[0]["PassportseNO"].ToString(); } if (ds.Tables[0].Rows[0]["Price"] != null && ds.Tables[0].Rows[0]["Price"].ToString() != "") { model.Price = Convert.ToDecimal(ds.Tables[0].Rows[0]["Price"].ToString()); } if (ds.Tables[0].Rows[0]["ZWCode"] != null && ds.Tables[0].Rows[0]["ZWCode"].ToString() != "") { model.ZWCode = ds.Tables[0].Rows[0]["ZWCode"].ToString(); } if (ds.Tables[0].Rows[0]["ZWName"] != null && ds.Tables[0].Rows[0]["ZWName"].ToString() != "") { model.ZWName = ds.Tables[0].Rows[0]["ZWName"].ToString(); } if (ds.Tables[0].Rows[0]["InsuranceID"] != null && ds.Tables[0].Rows[0]["InsuranceID"].ToString() != "") { model.InsuranceID = Convert.ToInt32(ds.Tables[0].Rows[0]["InsuranceID"].ToString()); } if (ds.Tables[0].Rows[0]["Cxin"] != null && ds.Tables[0].Rows[0]["Cxin"].ToString() != "") { model.Cxin = ds.Tables[0].Rows[0]["Cxin"].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]["PassengerId"] != null && ds.Tables[0].Rows[0]["PassengerId"].ToString() != "") { model.PassengerId = Convert.ToInt32(ds.Tables[0].Rows[0]["PassengerId"].ToString()); } if (ds.Tables[0].Rows[0]["Disacount"] != null && ds.Tables[0].Rows[0]["Disacount"].ToString() != "") { model.Disacount = Convert.ToDecimal(ds.Tables[0].Rows[0]["Disacount"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public List <lgk.Model.tb_TrainTicketsOrderDetail> DataTableToList(DataTable dt) { List <lgk.Model.tb_TrainTicketsOrderDetail> modelList = new List <lgk.Model.tb_TrainTicketsOrderDetail>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { lgk.Model.tb_TrainTicketsOrderDetail model; for (int n = 0; n < rowsCount; n++) { model = new lgk.Model.tb_TrainTicketsOrderDetail(); if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["OrderID"] != null && dt.Rows[n]["OrderID"].ToString() != "") { model.OrderID = Convert.ToInt32(dt.Rows[n]["OrderID"].ToString()); } if (dt.Rows[n]["PassengerseName"] != null && dt.Rows[n]["PassengerseName"].ToString() != "") { model.PassengerseName = dt.Rows[n]["PassengerseName"].ToString(); } if (dt.Rows[n]["PiaoType"] != null && dt.Rows[n]["PiaoType"].ToString() != "") { model.PiaoType = int.Parse(dt.Rows[n]["PiaoType"].ToString()); } if (dt.Rows[n]["PiaotypeName"] != null && dt.Rows[n]["PiaotypeName"].ToString() != "") { model.PiaotypeName = dt.Rows[n]["PiaotypeName"].ToString(); } if (dt.Rows[n]["Passporttypeseid"] != null && dt.Rows[n]["Passporttypeseid"].ToString() != "") { model.Passporttypeseid = Convert.ToInt32(dt.Rows[n]["Passporttypeseid"].ToString()); } if (dt.Rows[n]["PassporttypeseidName"] != null && dt.Rows[n]["PassporttypeseidName"].ToString() != "") { model.PassporttypeseidName = dt.Rows[n]["PassporttypeseidName"].ToString(); } if (dt.Rows[n]["PassportseNO"] != null && dt.Rows[n]["PassportseNO"].ToString() != "") { model.PassportseNO = dt.Rows[n]["PassportseNO"].ToString(); } if (dt.Rows[n]["Price"] != null && dt.Rows[n]["Price"].ToString() != "") { model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString()); } if (dt.Rows[n]["ZWCode"] != null && dt.Rows[n]["ZWCode"].ToString() != "") { model.ZWCode = dt.Rows[n]["ZWCode"].ToString(); } if (dt.Rows[n]["ZWName"] != null && dt.Rows[n]["ZWName"].ToString() != "") { model.ZWName = dt.Rows[n]["ZWName"].ToString(); } if (dt.Rows[n]["InsuranceID"] != null && dt.Rows[n]["InsuranceID"].ToString() != "") { model.InsuranceID = Convert.ToInt32(dt.Rows[n]["InsuranceID"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_TrainTicketsOrderDetail model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_TrainTicketsOrderDetail model) { return(dal.Add(model)); }