/// <summary>
///添加入住信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdds_Click(object sender, EventArgs e)
{
CdHotelManage.Model.occu_infor model = new CdHotelManage.Model.occu_infor();
CdHotelManage.Model.occu_infor models = new CdHotelManage.Model.occu_infor();
model.occ_no = System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", "");
model.room_number = this.txt_roomid.Value;
model.real_type_id = Convert.ToInt32(this.ddroomtype.SelectedValue);
model.source_id = Convert.ToInt32(this.DDlkrly.SelectedValue);
model.real_scheme_id = Convert.ToInt32(this.DDLfjfa.SelectedValue);
model.real_price = Convert.ToDecimal(this.txt_fjPrice.Value);
model.occ_with = "否";
model.real_mode_id = Convert.ToInt32(this.DDlKffs.SelectedValue);
model.occ_time = Convert.ToDateTime(this.txt_rzdate.Value);
model.pre_live_day = Convert.ToInt32(this.txt_Day.Value);
model.depar_time = Convert.ToDateTime(this.txt_ylDate.Value);
model.occ_name = this.txt_name.Value;
model.sex = this.txt_Sex.Value;
model.brithday = this.txt_Date2.Value;
model.family_name = this.txt_mingzhu.Value;
model.card_id = Convert.ToInt32(this.DDlSFz.SelectedValue);;
model.card_no = (this.txt_CardId.Value);
model.mem_cardno = this.txt_hycardId.Value; //会员卡号
model.remark = this.txt_Remaker.Value;
model.meth_pay_id = Convert.ToInt32(DDlZffs.SelectedValue); //支付方式
model.deposit = Convert.ToInt32(txt_yjmoney.Value);
model.address = txt_address.Value; //地址
CdHotelManage.BLL.occu_infor bll = new CdHotelManage.BLL.occu_infor();
CdHotelManage.Model.room_number fh = new CdHotelManage.Model.room_number();
fh.Rn_state = 2;
fh.Rn_roomNum = txt_roomid.Value;
string SQl = "update room_number set Rn_state=2 where Rn_roomNum='" + txt_roomid.Value + "'";
// fh.id = fhBll.GetModel(Convert.ToInt32(txt_roomid.Value), "Rn_roomNum");
fhBll.Updates(SQl);
for (int i = 0; i < hidSchool.Value.Split('|').Length - 1; i++)
{
models.occ_name = hidSchool.Value.Split('#')[0];
models.sex = hidSchool.Value.Split('#')[1];
models.brithday = hidSchool.Value.Split('#')[2];
models.card_id = Convert.ToInt32(hidSchool.Value.Split('#')[3]);
models.card_no = hidSchool.Value.Split('#')[4];
models.address = hidSchool.Value.Split('#')[5];
models.occ_time = Convert.ToDateTime(System.DateTime.Now.ToString());
models.occ_with = "是";
bll.Add(models);
}
if (bll.Add(model) > 0)
{
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "");
}
else
{
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存失败！", "");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.room_number model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update room_number set ");
strSql.Append("Rn_flloeld=@Rn_flloeld,");
strSql.Append("Rn_floor=@Rn_floor,");
strSql.Append("Rn_roomNum=@Rn_roomNum,");
strSql.Append("Rn_state=@Rn_state,");
strSql.Append("Rn_room=@Rn_room,");
strSql.Append("Rn_Type=@Rn_Type,");
strSql.Append("Rn_price=@Rn_price,");
strSql.Append("Rn_remaker=@Rn_remaker,");
strSql.Append("Room_suod=@Room_suod,");
strSql.Append("Rn_Tobe=@Rn_Tobe,");
strSql.Append("Rn_suo=@Rn_suo");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@Rn_flloeld", SqlDbType.NVarChar, 50),
new SqlParameter("@Rn_floor", SqlDbType.NVarChar, 10),
new SqlParameter("@Rn_roomNum", SqlDbType.NVarChar, 20),
new SqlParameter("@Rn_state", SqlDbType.Int, 4),
new SqlParameter("@Rn_room", SqlDbType.NVarChar, 50),
new SqlParameter("@Rn_Type", SqlDbType.Int, 4),
new SqlParameter("@Rn_price", SqlDbType.Money, 4),
new SqlParameter("@Rn_remaker", SqlDbType.NVarChar, -1),
new SqlParameter("@Room_suod", SqlDbType.Char, 10),
new SqlParameter("@Rn_Tobe", SqlDbType.Int, 4),
new SqlParameter("@Rn_suo", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.Rn_flloeld;
parameters[1].Value = model.Rn_floor;
parameters[2].Value = model.Rn_roomNum;
parameters[3].Value = model.Rn_state;
parameters[4].Value = model.Rn_room;
parameters[5].Value = model.Rn_Type;
parameters[6].Value = model.Rn_price;
parameters[7].Value = model.Rn_remaker;
parameters[8].Value = model.Room_suod;
parameters[9].Value = model.Rn_Tobe;
parameters[10].Value = model.Rn_suo;
parameters[11].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.room_number DataRowToModel(DataRow row)
{
CdHotelManage.Model.room_number model = new CdHotelManage.Model.room_number();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["Rn_flloeld"] != null)
{
model.Rn_flloeld = row["Rn_flloeld"].ToString();
}
if (row["Rn_floor"] != null)
{
model.Rn_floor = row["Rn_floor"].ToString();
}
if (row["Rn_roomNum"] != null)
{
model.Rn_roomNum = row["Rn_roomNum"].ToString();
}
if (row["Rn_state"] != null && row["Rn_state"].ToString() != "")
{
model.Rn_state = int.Parse(row["Rn_state"].ToString());
}
if (row["Rn_room"] != null)
{
model.Rn_room = row["Rn_room"].ToString();
}
if (row["Rn_Type"] != null && row["Rn_Type"].ToString() != "")
{
model.Rn_Type = int.Parse(row["Rn_Type"].ToString());
}
if (row["Rn_price"] != null && row["Rn_price"].ToString() != "")
{
model.Rn_price = Convert.ToDecimal(decimal.Parse(row["Rn_price"].ToString()));
}
if (row["Rn_remaker"] != null)
{
model.Rn_remaker = row["Rn_remaker"].ToString();
}
if (row["Room_suod"] != null)
{
model.Room_suod = row["Room_suod"].ToString();
}
if (row["Rn_Tobe"] != null && row["Rn_Tobe"].ToString() != "")
{
model.Rn_Tobe = Convert.ToInt32(row["Rn_Tobe"]);
}
if (row["Rn_suo"] != null && row["Rn_suo"].ToString() != "")
{
model.Rn_suo = row["Rn_suo"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CdHotelManage.Model.room_number model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into room_number(");
strSql.Append("Rn_flloeld,Rn_floor,Rn_roomNum,Rn_state,Rn_room,Rn_Type,Rn_price,Rn_remaker,Room_suod,Rn_Tobe,Rn_suo)");
strSql.Append(" values (");
strSql.Append("@Rn_flloeld,@Rn_floor,@Rn_roomNum,@Rn_state,@Rn_room,@Rn_Type,@Rn_price,@Rn_remaker,@Room_suod,@Rn_Tobe,@Rn_suo)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Rn_flloeld", SqlDbType.NVarChar, 50),
new SqlParameter("@Rn_floor", SqlDbType.NVarChar, 10),
new SqlParameter("@Rn_roomNum", SqlDbType.NVarChar, 20),
new SqlParameter("@Rn_state", SqlDbType.Int, 4),
new SqlParameter("@Rn_room", SqlDbType.NVarChar, 50),
new SqlParameter("@Rn_Type", SqlDbType.Int, 4),
new SqlParameter("@Rn_price", SqlDbType.Money, 4),
new SqlParameter("@Rn_remaker", SqlDbType.NVarChar, -1),
new SqlParameter("@Room_suod", SqlDbType.Char, 10),
new SqlParameter("@Rn_Tobe", SqlDbType.Int, 4),
new SqlParameter("@Rn_suo", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Rn_flloeld;
parameters[1].Value = model.Rn_floor;
parameters[2].Value = model.Rn_roomNum;
parameters[3].Value = model.Rn_state;
parameters[4].Value = model.Rn_room;
parameters[5].Value = model.Rn_Type;
parameters[6].Value = model.Rn_price;
parameters[7].Value = model.Rn_remaker;
parameters[8].Value = model.Room_suod;
parameters[9].Value = model.Rn_Tobe;
parameters[10].Value = model.Rn_suo;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体2
/// </summary>
public CdHotelManage.Model.room_number GetModel(int id, string TabCell)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,Rn_flloeld,Rn_floor,Rn_roomNum,Rn_state,Rn_room,Rn_Type,Rn_price,Rn_remaker,Room_suod,Rn_Tobe,Rn_suo from room_number ");
strSql.Append(" where " + TabCell + "=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
CdHotelManage.Model.room_number model = new CdHotelManage.Model.room_number();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
