/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.apartment GetModel(int occ_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 occ_id,occ_no,order_id,occ_name,occ_with,real_type_id,room_number,real_scheme_id,source_id,mem_cardno,real_mode_id,real_price,occ_time,pre_live_day,stay_day,stay_deposit,depar_time,pha_sched,card_id,card_no,brithday,sex,family_name,address,meth_pay_id,state_id,deposit,pay_money,amount_money,amount_rece,return_money,sale_id,remark,sort,lordRoomid,continuelive,phonenum,tuifaId,userid,header_img from apartment ");
strSql.Append(" where occ_id=@occ_id");
SqlParameter[] parameters =
{
new SqlParameter("@occ_id", SqlDbType.Int, 4)
};
parameters[0].Value = occ_id;
CdHotelManage.Model.apartment model = new CdHotelManage.Model.apartment();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["occ_id"] != null && ds.Tables[0].Rows[0]["occ_id"].ToString() != "")
{
model.occ_id = int.Parse(ds.Tables[0].Rows[0]["occ_id"].ToString());
}
if (ds.Tables[0].Rows[0]["occ_no"] != null && ds.Tables[0].Rows[0]["occ_no"].ToString() != "")
{
model.occ_no = ds.Tables[0].Rows[0]["occ_no"].ToString();
}
if (ds.Tables[0].Rows[0]["order_id"] != null && ds.Tables[0].Rows[0]["order_id"].ToString() != "")
{
model.order_id = ds.Tables[0].Rows[0]["order_id"].ToString();
}
if (ds.Tables[0].Rows[0]["occ_name"] != null && ds.Tables[0].Rows[0]["occ_name"].ToString() != "")
{
model.occ_name = ds.Tables[0].Rows[0]["occ_name"].ToString();
}
if (ds.Tables[0].Rows[0]["occ_with"] != null && ds.Tables[0].Rows[0]["occ_with"].ToString() != "")
{
model.occ_with = ds.Tables[0].Rows[0]["occ_with"].ToString();
}
if (ds.Tables[0].Rows[0]["real_type_id"] != null && ds.Tables[0].Rows[0]["real_type_id"].ToString() != "")
{
model.real_type_id = int.Parse(ds.Tables[0].Rows[0]["real_type_id"].ToString());
}
if (ds.Tables[0].Rows[0]["room_number"] != null && ds.Tables[0].Rows[0]["room_number"].ToString() != "")
{
model.room_number = ds.Tables[0].Rows[0]["room_number"].ToString();
}
if (ds.Tables[0].Rows[0]["real_scheme_id"] != null && ds.Tables[0].Rows[0]["real_scheme_id"].ToString() != "")
{
model.real_scheme_id = int.Parse(ds.Tables[0].Rows[0]["real_scheme_id"].ToString());
}
if (ds.Tables[0].Rows[0]["source_id"] != null && ds.Tables[0].Rows[0]["source_id"].ToString() != "")
{
model.source_id = int.Parse(ds.Tables[0].Rows[0]["source_id"].ToString());
}
if (ds.Tables[0].Rows[0]["mem_cardno"] != null && ds.Tables[0].Rows[0]["mem_cardno"].ToString() != "")
{
model.mem_cardno = ds.Tables[0].Rows[0]["mem_cardno"].ToString();
}
if (ds.Tables[0].Rows[0]["real_mode_id"] != null && ds.Tables[0].Rows[0]["real_mode_id"].ToString() != "")
{
model.real_mode_id = int.Parse(ds.Tables[0].Rows[0]["real_mode_id"].ToString());
}
if (ds.Tables[0].Rows[0]["real_price"] != null && ds.Tables[0].Rows[0]["real_price"].ToString() != "")
{
model.real_price = decimal.Parse(ds.Tables[0].Rows[0]["real_price"].ToString());
}
if (ds.Tables[0].Rows[0]["occ_time"] != null && ds.Tables[0].Rows[0]["occ_time"].ToString() != "")
{
model.occ_time = DateTime.Parse(ds.Tables[0].Rows[0]["occ_time"].ToString());
}
if (ds.Tables[0].Rows[0]["pre_live_day"] != null && ds.Tables[0].Rows[0]["pre_live_day"].ToString() != "")
{
model.pre_live_day = int.Parse(ds.Tables[0].Rows[0]["pre_live_day"].ToString());
}
if (ds.Tables[0].Rows[0]["stay_day"] != null && ds.Tables[0].Rows[0]["stay_day"].ToString() != "")
{
model.stay_day = int.Parse(ds.Tables[0].Rows[0]["stay_day"].ToString());
}
if (ds.Tables[0].Rows[0]["stay_deposit"] != null && ds.Tables[0].Rows[0]["stay_deposit"].ToString() != "")
{
model.stay_deposit = decimal.Parse(ds.Tables[0].Rows[0]["stay_deposit"].ToString());
}
if (ds.Tables[0].Rows[0]["depar_time"] != null && ds.Tables[0].Rows[0]["depar_time"].ToString() != "")
{
model.depar_time = DateTime.Parse(ds.Tables[0].Rows[0]["depar_time"].ToString());
}
if (ds.Tables[0].Rows[0]["pha_sched"] != null && ds.Tables[0].Rows[0]["pha_sched"].ToString() != "")
{
model.pha_sched = DateTime.Parse(ds.Tables[0].Rows[0]["pha_sched"].ToString());
}
if (ds.Tables[0].Rows[0]["card_id"] != null && ds.Tables[0].Rows[0]["card_id"].ToString() != "")
{
model.card_id = int.Parse(ds.Tables[0].Rows[0]["card_id"].ToString());
}
if (ds.Tables[0].Rows[0]["card_no"] != null && ds.Tables[0].Rows[0]["card_no"].ToString() != "")
{
model.card_no = ds.Tables[0].Rows[0]["card_no"].ToString();
}
if (ds.Tables[0].Rows[0]["brithday"] != null && ds.Tables[0].Rows[0]["brithday"].ToString() != "")
{
model.brithday = ds.Tables[0].Rows[0]["brithday"].ToString();
}
if (ds.Tables[0].Rows[0]["sex"] != null && ds.Tables[0].Rows[0]["sex"].ToString() != "")
{
model.sex = ds.Tables[0].Rows[0]["sex"].ToString();
}
if (ds.Tables[0].Rows[0]["family_name"] != null && ds.Tables[0].Rows[0]["family_name"].ToString() != "")
{
model.family_name = ds.Tables[0].Rows[0]["family_name"].ToString();
}
if (ds.Tables[0].Rows[0]["address"] != null && ds.Tables[0].Rows[0]["address"].ToString() != "")
{
model.address = ds.Tables[0].Rows[0]["address"].ToString();
}
if (ds.Tables[0].Rows[0]["meth_pay_id"] != null && ds.Tables[0].Rows[0]["meth_pay_id"].ToString() != "")
{
model.meth_pay_id = int.Parse(ds.Tables[0].Rows[0]["meth_pay_id"].ToString());
}
if (ds.Tables[0].Rows[0]["state_id"] != null && ds.Tables[0].Rows[0]["state_id"].ToString() != "")
{
model.state_id = int.Parse(ds.Tables[0].Rows[0]["state_id"].ToString());
}
if (ds.Tables[0].Rows[0]["deposit"] != null && ds.Tables[0].Rows[0]["deposit"].ToString() != "")
{
model.deposit = decimal.Parse(ds.Tables[0].Rows[0]["deposit"].ToString());
}
if (ds.Tables[0].Rows[0]["pay_money"] != null && ds.Tables[0].Rows[0]["pay_money"].ToString() != "")
{
model.pay_money = decimal.Parse(ds.Tables[0].Rows[0]["pay_money"].ToString());
}
if (ds.Tables[0].Rows[0]["amount_money"] != null && ds.Tables[0].Rows[0]["amount_money"].ToString() != "")
{
model.amount_money = decimal.Parse(ds.Tables[0].Rows[0]["amount_money"].ToString());
}
if (ds.Tables[0].Rows[0]["amount_rece"] != null && ds.Tables[0].Rows[0]["amount_rece"].ToString() != "")
{
model.amount_rece = decimal.Parse(ds.Tables[0].Rows[0]["amount_rece"].ToString());
}
if (ds.Tables[0].Rows[0]["return_money"] != null && ds.Tables[0].Rows[0]["return_money"].ToString() != "")
{
model.return_money = decimal.Parse(ds.Tables[0].Rows[0]["return_money"].ToString());
}
if (ds.Tables[0].Rows[0]["sale_id"] != null && ds.Tables[0].Rows[0]["sale_id"].ToString() != "")
{
model.sale_id = int.Parse(ds.Tables[0].Rows[0]["sale_id"].ToString());
}
if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "")
{
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
}
if (ds.Tables[0].Rows[0]["sort"] != null && ds.Tables[0].Rows[0]["sort"].ToString() != "")
{
model.sort = ds.Tables[0].Rows[0]["sort"].ToString();
}
if (ds.Tables[0].Rows[0]["lordRoomid"] != null && ds.Tables[0].Rows[0]["lordRoomid"].ToString() != "")
{
model.lordRoomid = ds.Tables[0].Rows[0]["lordRoomid"].ToString();
}
if (ds.Tables[0].Rows[0]["continuelive"] != null && ds.Tables[0].Rows[0]["continuelive"].ToString() != "")
{
model.continuelive = int.Parse(ds.Tables[0].Rows[0]["continuelive"].ToString());
}
if (ds.Tables[0].Rows[0]["phonenum"] != null && ds.Tables[0].Rows[0]["phonenum"].ToString() != "")
{
model.phonenum = ds.Tables[0].Rows[0]["phonenum"].ToString();
}
if (ds.Tables[0].Rows[0]["tuifaId"] != null && ds.Tables[0].Rows[0]["tuifaId"].ToString() != "")
{
model.tuifaId = int.Parse(ds.Tables[0].Rows[0]["tuifaId"].ToString());
}
if (ds.Tables[0].Rows[0]["userid"] != null && ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.userid = ds.Tables[0].Rows[0]["userid"].ToString();
}
if (ds.Tables[0].Rows[0]["header_img"] != null && ds.Tables[0].Rows[0]["header_img"].ToString() != "")
{
model.header_img = ds.Tables[0].Rows[0]["header_img"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CdHotelManage.Model.apartment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into apartment(");
strSql.Append("occ_no,order_id,occ_name,occ_with,real_type_id,room_number,real_scheme_id,source_id,mem_cardno,real_mode_id,real_price,occ_time,pre_live_day,stay_day,stay_deposit,depar_time,pha_sched,card_id,card_no,brithday,sex,family_name,address,meth_pay_id,state_id,deposit,pay_money,amount_money,amount_rece,return_money,sale_id,remark,sort,lordRoomid,continuelive,phonenum,tuifaId,userid,header_img)");
strSql.Append(" values (");
strSql.Append("@occ_no,@order_id,@occ_name,@occ_with,@real_type_id,@room_number,@real_scheme_id,@source_id,@mem_cardno,@real_mode_id,@real_price,@occ_time,@pre_live_day,@stay_day,@stay_deposit,@depar_time,@pha_sched,@card_id,@card_no,@brithday,@sex,@family_name,@address,@meth_pay_id,@state_id,@deposit,@pay_money,@amount_money,@amount_rece,@return_money,@sale_id,@remark,@sort,@lordRoomid,@continuelive,@phonenum,@tuifaId,@userid,@header_img)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@occ_no", SqlDbType.NVarChar, 50),
new SqlParameter("@order_id", SqlDbType.NVarChar, 50),
new SqlParameter("@occ_name", SqlDbType.NVarChar, 20),
new SqlParameter("@occ_with", SqlDbType.NVarChar, 10),
new SqlParameter("@real_type_id", SqlDbType.Int, 4),
new SqlParameter("@room_number", SqlDbType.NVarChar, 10),
new SqlParameter("@real_scheme_id", SqlDbType.Int, 4),
new SqlParameter("@source_id", SqlDbType.Int, 4),
new SqlParameter("@mem_cardno", SqlDbType.NVarChar, 50),
new SqlParameter("@real_mode_id", SqlDbType.Int, 4),
new SqlParameter("@real_price", SqlDbType.Money, 8),
new SqlParameter("@occ_time", SqlDbType.DateTime),
new SqlParameter("@pre_live_day", SqlDbType.Int, 4),
new SqlParameter("@stay_day", SqlDbType.Int, 4),
new SqlParameter("@stay_deposit", SqlDbType.Money, 8),
new SqlParameter("@depar_time", SqlDbType.DateTime),
new SqlParameter("@pha_sched", SqlDbType.DateTime),
new SqlParameter("@card_id", SqlDbType.Int, 4),
new SqlParameter("@card_no", SqlDbType.NVarChar, 50),
new SqlParameter("@brithday", SqlDbType.NVarChar, 20),
new SqlParameter("@sex", SqlDbType.NVarChar, 1),
new SqlParameter("@family_name", SqlDbType.NVarChar, 20),
new SqlParameter("@address", SqlDbType.NVarChar, 50),
new SqlParameter("@meth_pay_id", SqlDbType.Int, 4),
new SqlParameter("@state_id", SqlDbType.Int, 4),
new SqlParameter("@deposit", SqlDbType.Money, 8),
new SqlParameter("@pay_money", SqlDbType.Money, 8),
new SqlParameter("@amount_money", SqlDbType.Money, 8),
new SqlParameter("@amount_rece", SqlDbType.Money, 8),
new SqlParameter("@return_money", SqlDbType.Money, 8),
new SqlParameter("@sale_id", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar),
new SqlParameter("@sort", SqlDbType.NVarChar, 50),
new SqlParameter("@lordRoomid", SqlDbType.NVarChar, 50),
new SqlParameter("@continuelive", SqlDbType.Int, 4),
new SqlParameter("@phonenum", SqlDbType.NVarChar, 50),
new SqlParameter("@tuifaId", SqlDbType.Int, 4),
new SqlParameter("@userid", SqlDbType.NVarChar, 50),
new SqlParameter("@header_img", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.occ_no;
parameters[1].Value = model.order_id;
parameters[2].Value = model.occ_name;
parameters[3].Value = model.occ_with;
parameters[4].Value = model.real_type_id;
parameters[5].Value = model.room_number;
parameters[6].Value = model.real_scheme_id;
parameters[7].Value = model.source_id;
parameters[8].Value = model.mem_cardno;
parameters[9].Value = model.real_mode_id;
parameters[10].Value = model.real_price;
parameters[11].Value = model.occ_time;
parameters[12].Value = model.pre_live_day;
parameters[13].Value = model.stay_day;
parameters[14].Value = model.stay_deposit;
parameters[15].Value = model.depar_time;
parameters[16].Value = model.pha_sched;
parameters[17].Value = model.card_id;
parameters[18].Value = model.card_no;
parameters[19].Value = model.brithday;
parameters[20].Value = model.sex;
parameters[21].Value = model.family_name;
parameters[22].Value = model.address;
parameters[23].Value = model.meth_pay_id;
parameters[24].Value = model.state_id;
parameters[25].Value = model.deposit;
parameters[26].Value = model.pay_money;
parameters[27].Value = model.amount_money;
parameters[28].Value = model.amount_rece;
parameters[29].Value = model.return_money;
parameters[30].Value = model.sale_id;
parameters[31].Value = model.remark;
parameters[32].Value = model.sort;
parameters[33].Value = model.lordRoomid;
parameters[34].Value = model.continuelive;
parameters[35].Value = model.phonenum;
parameters[36].Value = model.tuifaId;
parameters[37].Value = model.userid;
parameters[38].Value = model.header_img;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.apartment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update apartment set ");
strSql.Append("occ_no=@occ_no,");
strSql.Append("order_id=@order_id,");
strSql.Append("occ_name=@occ_name,");
strSql.Append("occ_with=@occ_with,");
strSql.Append("real_type_id=@real_type_id,");
strSql.Append("room_number=@room_number,");
strSql.Append("real_scheme_id=@real_scheme_id,");
strSql.Append("source_id=@source_id,");
strSql.Append("mem_cardno=@mem_cardno,");
strSql.Append("real_mode_id=@real_mode_id,");
strSql.Append("real_price=@real_price,");
strSql.Append("occ_time=@occ_time,");
strSql.Append("pre_live_day=@pre_live_day,");
strSql.Append("stay_day=@stay_day,");
strSql.Append("stay_deposit=@stay_deposit,");
strSql.Append("depar_time=@depar_time,");
strSql.Append("pha_sched=@pha_sched,");
strSql.Append("card_id=@card_id,");
strSql.Append("card_no=@card_no,");
strSql.Append("brithday=@brithday,");
strSql.Append("sex=@sex,");
strSql.Append("family_name=@family_name,");
strSql.Append("address=@address,");
strSql.Append("meth_pay_id=@meth_pay_id,");
strSql.Append("state_id=@state_id,");
strSql.Append("deposit=@deposit,");
strSql.Append("pay_money=@pay_money,");
strSql.Append("amount_money=@amount_money,");
strSql.Append("amount_rece=@amount_rece,");
strSql.Append("return_money=@return_money,");
strSql.Append("sale_id=@sale_id,");
strSql.Append("remark=@remark,");
strSql.Append("sort=@sort,");
strSql.Append("lordRoomid=@lordRoomid,");
strSql.Append("continuelive=@continuelive,");
strSql.Append("phonenum=@phonenum,");
strSql.Append("tuifaId=@tuifaId,");
strSql.Append("userid=@userid,");
strSql.Append("header_img=@header_img");
strSql.Append(" where occ_id=@occ_id");
SqlParameter[] parameters =
{
new SqlParameter("@occ_no", SqlDbType.NVarChar, 50),
new SqlParameter("@order_id", SqlDbType.NVarChar, 50),
new SqlParameter("@occ_name", SqlDbType.NVarChar, 20),
new SqlParameter("@occ_with", SqlDbType.NVarChar, 10),
new SqlParameter("@real_type_id", SqlDbType.Int, 4),
new SqlParameter("@room_number", SqlDbType.NVarChar, 10),
new SqlParameter("@real_scheme_id", SqlDbType.Int, 4),
new SqlParameter("@source_id", SqlDbType.Int, 4),
new SqlParameter("@mem_cardno", SqlDbType.NVarChar, 50),
new SqlParameter("@real_mode_id", SqlDbType.Int, 4),
new SqlParameter("@real_price", SqlDbType.Money, 8),
new SqlParameter("@occ_time", SqlDbType.DateTime),
new SqlParameter("@pre_live_day", SqlDbType.Int, 4),
new SqlParameter("@stay_day", SqlDbType.Int, 4),
new SqlParameter("@stay_deposit", SqlDbType.Money, 8),
new SqlParameter("@depar_time", SqlDbType.DateTime),
new SqlParameter("@pha_sched", SqlDbType.DateTime),
new SqlParameter("@card_id", SqlDbType.Int, 4),
new SqlParameter("@card_no", SqlDbType.NVarChar, 50),
new SqlParameter("@brithday", SqlDbType.NVarChar, 20),
new SqlParameter("@sex", SqlDbType.NVarChar, 1),
new SqlParameter("@family_name", SqlDbType.NVarChar, 20),
new SqlParameter("@address", SqlDbType.NVarChar, 50),
new SqlParameter("@meth_pay_id", SqlDbType.Int, 4),
new SqlParameter("@state_id", SqlDbType.Int, 4),
new SqlParameter("@deposit", SqlDbType.Money, 8),
new SqlParameter("@pay_money", SqlDbType.Money, 8),
new SqlParameter("@amount_money", SqlDbType.Money, 8),
new SqlParameter("@amount_rece", SqlDbType.Money, 8),
new SqlParameter("@return_money", SqlDbType.Money, 8),
new SqlParameter("@sale_id", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar),
new SqlParameter("@sort", SqlDbType.NVarChar, 50),
new SqlParameter("@lordRoomid", SqlDbType.NVarChar, 50),
new SqlParameter("@continuelive", SqlDbType.Int, 4),
new SqlParameter("@phonenum", SqlDbType.NVarChar, 50),
new SqlParameter("@tuifaId", SqlDbType.Int, 4),
new SqlParameter("@userid", SqlDbType.NVarChar, 50),
new SqlParameter("@header_img", SqlDbType.NVarChar, 50),
new SqlParameter("@occ_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.occ_no;
parameters[1].Value = model.order_id;
parameters[2].Value = model.occ_name;
parameters[3].Value = model.occ_with;
parameters[4].Value = model.real_type_id;
parameters[5].Value = model.room_number;
parameters[6].Value = model.real_scheme_id;
parameters[7].Value = model.source_id;
parameters[8].Value = model.mem_cardno;
parameters[9].Value = model.real_mode_id;
parameters[10].Value = model.real_price;
parameters[11].Value = model.occ_time;
parameters[12].Value = model.pre_live_day;
parameters[13].Value = model.stay_day;
parameters[14].Value = model.stay_deposit;
parameters[15].Value = model.depar_time;
parameters[16].Value = model.pha_sched;
parameters[17].Value = model.card_id;
parameters[18].Value = model.card_no;
parameters[19].Value = model.brithday;
parameters[20].Value = model.sex;
parameters[21].Value = model.family_name;
parameters[22].Value = model.address;
parameters[23].Value = model.meth_pay_id;
parameters[24].Value = model.state_id;
parameters[25].Value = model.deposit;
parameters[26].Value = model.pay_money;
parameters[27].Value = model.amount_money;
parameters[28].Value = model.amount_rece;
parameters[29].Value = model.return_money;
parameters[30].Value = model.sale_id;
parameters[31].Value = model.remark;
parameters[32].Value = model.sort;
parameters[33].Value = model.lordRoomid;
parameters[34].Value = model.continuelive;
parameters[35].Value = model.phonenum;
parameters[36].Value = model.tuifaId;
parameters[37].Value = model.userid;
parameters[38].Value = model.header_img;
parameters[39].Value = model.occ_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
