//保存按钮
protected void BookAddButton_Click(object sender, EventArgs e)
{
CdHotelManage.Model.book_room model = new CdHotelManage.Model.book_room();
model.book_no = "Y" + System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", "");
model.book_Name = this.book_name.Value;
model.tele_no = this.tele_no.Value;
model.onli_no = this.onli_no.Value;
model.guar_way = this.GuarWayDll.SelectedValue;
model.mem_cardno = this.mem_cardNo.Value;
model.time_to = Convert.ToDateTime(this.time_to.Value);
model.time_from = Convert.ToDateTime(this.time_from.Value);
model.real_time = Convert.ToDateTime(this.real_time.Value);
model.source_id = Convert.ToInt16(this.GuestSourceDdl.SelectedValue);
model.meth_pay_id = Convert.ToInt16(this.MethPayDdl.SelectedValue);
model.deposit = Convert.ToDecimal(deposit.Value);
model.real_type_id = Convert.ToInt16(this.RoomTypeDdl.SelectedValue);
model.real_scheme_id = Convert.ToInt16(this.HouseShameDdl.SelectedValue);
model.real_price = Convert.ToDecimal(this.real_price.Value);;
model.state_id = 1;
model.real_num = Convert.ToInt16(this.real_num.Value);
model.remark = this.textRemaker.Value;
CdHotelManage.BLL.book_room bll = new CdHotelManage.BLL.book_room();
int Result = bll.Add(model);
if (Result > 0)
{
Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>(\"保存成功\", \"info\",'../','');</script>");
Response.Redirect("BookList.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>(\"系统繁忙，请稍后再试！\", \"info\",'../','');</script>");
Response.Redirect("BookList.aspx");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.book_room GetModel(int book_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 book_id,book_no,book_Name,tele_no,onli_no,guar_way,mem_cardno,time_to,time_from,real_time,source_id,meth_pay_id,deposit,real_type_id,real_scheme_id,real_price,state_id,real_num,remark,userid,room_number,back_deposit,Accounts,CpID from book_room ");
strSql.Append(" where book_id=@book_id");
SqlParameter[] parameters =
{
new SqlParameter("@book_id", SqlDbType.Int, 4)
};
parameters[0].Value = book_id;
CdHotelManage.Model.book_room model = new CdHotelManage.Model.book_room();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CdHotelManage.Model.book_room model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into book_room(");
strSql.Append("book_no,book_Name,tele_no,onli_no,guar_way,mem_cardno,time_to,time_from,real_time,source_id,meth_pay_id,deposit,real_type_id,real_scheme_id,real_price,state_id,real_num,remark,userid,room_number,Accounts,CpID)");
strSql.Append(" values (");
strSql.Append("@book_no,@book_Name,@tele_no,@onli_no,@guar_way,@mem_cardno,@time_to,@time_from,@real_time,@source_id,@meth_pay_id,@deposit,@real_type_id,@real_scheme_id,@real_price,@state_id,@real_num,@remark,@userid,@room_number,@Accounts,@CpID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@book_no", SqlDbType.NVarChar, 20),
new SqlParameter("@book_Name", SqlDbType.NVarChar, 20),
new SqlParameter("@tele_no", SqlDbType.NVarChar, 20),
new SqlParameter("@onli_no", SqlDbType.NVarChar, 20),
new SqlParameter("@guar_way", SqlDbType.NVarChar, 20),
new SqlParameter("@mem_cardno", SqlDbType.NVarChar, 50),
new SqlParameter("@time_to", SqlDbType.DateTime),
new SqlParameter("@time_from", SqlDbType.DateTime),
new SqlParameter("@real_time", SqlDbType.DateTime),
new SqlParameter("@source_id", SqlDbType.Int, 4),
new SqlParameter("@meth_pay_id", SqlDbType.Int, 4),
new SqlParameter("@deposit", SqlDbType.Money, 8),
new SqlParameter("@real_type_id", SqlDbType.Int, 4),
new SqlParameter("@real_scheme_id", SqlDbType.Int, 4),
new SqlParameter("@real_price", SqlDbType.Money, 8),
new SqlParameter("@state_id", SqlDbType.Int, 4),
new SqlParameter("@real_num", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar, -1),
new SqlParameter("@userid", SqlDbType.NVarChar, 50),
new SqlParameter("@room_number", SqlDbType.NVarChar, 20),
new SqlParameter("@Accounts", SqlDbType.NVarChar, 50),
new SqlParameter("@CpID", SqlDbType.Int, 4)
};
parameters[0].Value = model.book_no;
parameters[1].Value = model.book_Name;
parameters[2].Value = model.tele_no;
parameters[3].Value = model.onli_no;
parameters[4].Value = model.guar_way;
parameters[5].Value = model.mem_cardno;
parameters[6].Value = model.time_to;
parameters[7].Value = model.time_from;
parameters[8].Value = model.real_time;
parameters[9].Value = model.source_id;
parameters[10].Value = model.meth_pay_id;
parameters[11].Value = model.deposit;
parameters[12].Value = model.real_type_id;
parameters[13].Value = model.real_scheme_id;
parameters[14].Value = model.real_price;
parameters[15].Value = model.state_id;
parameters[16].Value = model.real_num;
parameters[17].Value = model.remark;
parameters[18].Value = model.Userid;
parameters[19].Value = model.room_number;
parameters[20].Value = model.Accounts;
parameters[21].Value = model.CpID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.book_room DataRowToModel(DataRow row)
{
CdHotelManage.Model.book_room model = new CdHotelManage.Model.book_room();
if (row != null)
{
if (row["book_id"] != null && row["book_id"].ToString() != "")
{
model.book_id = int.Parse(row["book_id"].ToString());
}
if (row["book_no"] != null && row["book_no"].ToString() != "")
{
model.book_no = row["book_no"].ToString();
}
if (row["book_Name"] != null)
{
model.book_Name = row["book_Name"].ToString();
}
if (row["tele_no"] != null)
{
model.tele_no = row["tele_no"].ToString();
}
if (row["onli_no"] != null)
{
model.onli_no = row["onli_no"].ToString();
}
if (row["guar_way"] != null)
{
model.guar_way = row["guar_way"].ToString();
}
if (row["mem_cardno"] != null)
{
model.mem_cardno = row["mem_cardno"].ToString();
}
if (row["time_to"] != null && row["time_to"].ToString() != "")
{
model.time_to = DateTime.Parse(row["time_to"].ToString());
}
if (row["time_from"] != null && row["time_from"].ToString() != "")
{
model.time_from = DateTime.Parse(row["time_from"].ToString());
}
if (row["real_time"] != null && row["real_time"].ToString() != "")
{
model.real_time = DateTime.Parse(row["real_time"].ToString());
}
if (row["source_id"] != null && row["source_id"].ToString() != "")
{
model.source_id = int.Parse(row["source_id"].ToString());
}
if (row["meth_pay_id"] != null && row["meth_pay_id"].ToString() != "")
{
model.meth_pay_id = int.Parse(row["meth_pay_id"].ToString());
}
if (row["deposit"] != null && row["deposit"].ToString() != "")
{
model.deposit = decimal.Parse(row["deposit"].ToString());
}
if (row["real_type_id"] != null && row["real_type_id"].ToString() != "")
{
model.real_type_id = int.Parse(row["real_type_id"].ToString());
}
if (row["real_scheme_id"] != null && row["real_scheme_id"].ToString() != "")
{
model.real_scheme_id = int.Parse(row["real_scheme_id"].ToString());
}
if (row["real_price"] != null && row["real_price"].ToString() != "")
{
model.real_price = decimal.Parse(row["real_price"].ToString());
}
if (row["state_id"] != null && row["state_id"].ToString() != "")
{
model.state_id = int.Parse(row["state_id"].ToString());
}
if (row["real_num"] != null && row["real_num"].ToString() != "")
{
model.real_num = int.Parse(row["real_num"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["userid"] != null)
{
model.Userid = row["userid"].ToString();
}
if (row["room_number"] != null)
{
model.room_number = row["room_number"].ToString();
}
if (row["back_deposit"] != null && row["back_deposit"].ToString() != "")
{
model.back_deposit = decimal.Parse(row["back_deposit"].ToString());
}
if (row["Accounts"] != null && row["Accounts"].ToString() != "")
{
model.Accounts = row["Accounts"].ToString();
}
if (row["CpID"] != null && row["CpID"].ToString() != "")
{
model.CpID = Convert.ToInt32(row["CpID"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.book_room model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update book_room set ");
strSql.Append("book_no=@book_no,");
strSql.Append("book_Name=@book_Name,");
strSql.Append("tele_no=@tele_no,");
strSql.Append("onli_no=@onli_no,");
strSql.Append("guar_way=@guar_way,");
strSql.Append("mem_cardno=@mem_cardno,");
strSql.Append("time_to=@time_to,");
strSql.Append("time_from=@time_from,");
strSql.Append("real_time=@real_time,");
strSql.Append("source_id=@source_id,");
strSql.Append("meth_pay_id=@meth_pay_id,");
strSql.Append("deposit=@deposit,");
strSql.Append("real_type_id=@real_type_id,");
strSql.Append("real_scheme_id=@real_scheme_id,");
strSql.Append("real_price=@real_price,");
strSql.Append("state_id=@state_id,");
strSql.Append("real_num=@real_num,");
strSql.Append("remark=@remark,");
strSql.Append("userid=@userid,");
strSql.Append("room_number=@room_number,");
strSql.Append("back_deposit=@back_deposit,");
strSql.Append("Accounts=@Accounts,");
strSql.Append("CpID=@CpID");
strSql.Append(" where book_id=@book_id");
SqlParameter[] parameters =
{
new SqlParameter("@book_no", SqlDbType.NVarChar, 20),
new SqlParameter("@book_Name", SqlDbType.NVarChar, 20),
new SqlParameter("@tele_no", SqlDbType.NVarChar, 20),
new SqlParameter("@onli_no", SqlDbType.NVarChar, 20),
new SqlParameter("@guar_way", SqlDbType.NVarChar, 20),
new SqlParameter("@mem_cardno", SqlDbType.NVarChar, 50),
new SqlParameter("@time_to", SqlDbType.DateTime),
new SqlParameter("@time_from", SqlDbType.DateTime),
new SqlParameter("@real_time", SqlDbType.DateTime),
new SqlParameter("@source_id", SqlDbType.Int, 4),
new SqlParameter("@meth_pay_id", SqlDbType.Int, 4),
new SqlParameter("@deposit", SqlDbType.Money, 8),
new SqlParameter("@real_type_id", SqlDbType.Int, 4),
new SqlParameter("@real_scheme_id", SqlDbType.Int, 4),
new SqlParameter("@real_price", SqlDbType.Money, 8),
new SqlParameter("@state_id", SqlDbType.Int, 4),
new SqlParameter("@real_num", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar, -1),
new SqlParameter("@userid", SqlDbType.NVarChar, 50),
new SqlParameter("@room_number", SqlDbType.NVarChar, 20),
new SqlParameter("@back_deposit", SqlDbType.Money, 8),
new SqlParameter("@book_id", SqlDbType.Int, 4),
new SqlParameter("@Accounts", SqlDbType.NVarChar, 50),
new SqlParameter("@CpID", SqlDbType.Int, 4)
};
parameters[0].Value = model.book_no;
parameters[1].Value = model.book_Name;
parameters[2].Value = model.tele_no;
parameters[3].Value = model.onli_no;
parameters[4].Value = model.guar_way;
parameters[5].Value = model.mem_cardno;
parameters[6].Value = model.time_to;
parameters[7].Value = model.time_from;
parameters[8].Value = model.real_time;
parameters[9].Value = model.source_id;
parameters[10].Value = model.meth_pay_id;
parameters[11].Value = model.deposit;
parameters[12].Value = model.real_type_id;
parameters[13].Value = model.real_scheme_id;
parameters[14].Value = model.real_price;
parameters[15].Value = model.state_id;
parameters[16].Value = model.real_num;
parameters[17].Value = model.remark;
parameters[18].Value = model.Userid;
parameters[19].Value = model.room_number;
parameters[20].Value = model.back_deposit;
parameters[21].Value = model.book_id;
parameters[22].Value = model.Accounts;
parameters[23].Value = model.CpID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.book_room model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CdHotelManage.Model.book_room model)
{
return(dal.Add(model));
}