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