/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_Insurance model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Insurance(");
strSql.Append("Name,Mobile,Gender,Birth,City,Idcard)");
strSql.Append(" values (");
strSql.Append("@Name,@Mobile,@Gender,@Birth,@City,@Idcard)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 100),
new SqlParameter("@Mobile", SqlDbType.VarChar, 100),
new SqlParameter("@Gender", SqlDbType.VarChar, 100),
new SqlParameter("@Birth", SqlDbType.Date),
new SqlParameter("@City", SqlDbType.VarChar, 100),
new SqlParameter("@Idcard", SqlDbType.VarChar)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Mobile;
parameters[2].Value = model.Gender;
parameters[3].Value = model.Birth;
parameters[4].Value = model.City;
parameters[5].Value = model.Idcard;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public lgk.Model.tb_Insurance GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,Mobile,Gender,Birth,City,Idcard from tb_Insurance ");
strSql.Append(" where " + where);
lgk.Model.tb_Insurance model = new lgk.Model.tb_Insurance();
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]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Mobile"] != null && ds.Tables[0].Rows[0]["Mobile"].ToString() != "")
{
model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString();
}
if (ds.Tables[0].Rows[0]["Gender"] != null && ds.Tables[0].Rows[0]["Gender"].ToString() != "")
{
model.Gender = ds.Tables[0].Rows[0]["Gender"].ToString();
}
if (ds.Tables[0].Rows[0]["Birth"] != null && ds.Tables[0].Rows[0]["Birth"].ToString() != "")
{
model.Birth = Convert.ToDateTime(ds.Tables[0].Rows[0]["Birth"].ToString());
}
if (ds.Tables[0].Rows[0]["City"] != null && ds.Tables[0].Rows[0]["City"].ToString() != "")
{
model.City = ds.Tables[0].Rows[0]["City"].ToString();
}
if (ds.Tables[0].Rows[0]["Idcard"] != null && ds.Tables[0].Rows[0]["Idcard"].ToString() != "")
{
model.Idcard = ds.Tables[0].Rows[0]["Idcard"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_Insurance model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_TrainTicketsOrder set ");
strSql.Append("Name=@Name,");
strSql.Append("Mobile=@Mobile,");
strSql.Append("Gender=@Gender,");
strSql.Append("Birth=@Birth,");
strSql.Append("City=@City,");
strSql.Append("Idcard=@Idcard");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 100),
new SqlParameter("@Mobile", SqlDbType.VarChar, 100),
new SqlParameter("@Gender", SqlDbType.VarChar, 100),
new SqlParameter("@Birth", SqlDbType.Date),
new SqlParameter("@City", SqlDbType.VarChar, 100),
new SqlParameter("@Idcard", SqlDbType.VarChar),
new SqlParameter("@ID", SqlDbType.Int),
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Mobile;
parameters[2].Value = model.Gender;
parameters[3].Value = model.Birth;
parameters[4].Value = model.City;
parameters[5].Value = model.Idcard;
parameters[6].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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_Insurance model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_Insurance model)
{
return(dal.Add(model));
}
