/// <summary>
/// 确定添加宿舍
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
Model.Dormitory dor = new Model.Dormitory();
// dor.dormitoryID = int.Parse(txtdormitoryID.Text.Trim());
dor.DormitoryBoos = txtBossName.Text.Trim();
dor.beds = txtbeds.Text.Trim();
dor.ISBN = txtISBN.Text.Trim();
dor.dormitoryPrice = int.Parse(txtPrice.Text.Trim());
dor.dormitoryGrade = txtdormitoryGrade.Text.Trim();
dor.dormitoryPerso = int.Parse(txtPerso.Text.Trim());
dor.Explain = txtExplains.Text.Trim();
if (new DormitoryBLL().InsertDormitoryBLL(dor) == 1)
{
CommonFuncs.ShowMsg(this.Page, "添加宿舍信息成功");
}
else
{
CommonFuncs.ShowMsg(this.Page, "添加宿舍信息失败！\\n\\n请检查各个输入是否合法，\\n学生ID是否已经存在，\\n或者请管理员查看系统日志。 ");
}
}
//更新宿舍信息
public int UpdateDormitoryDAL(Model.Dormitory dor)
{
string sql = "update [Dormitory] set [State]=0";
if (!string.IsNullOrEmpty(dor.dormitoryGrade))
{
sql += ",[dormitoryGrade]='" + dor.dormitoryGrade + "'";
}
if (!string.IsNullOrEmpty(dor.dormitoryPerso.ToString()))
{
sql += ",[dormitoryPerso]='" + dor.dormitoryPerso + "'";
}
if (!string.IsNullOrEmpty(dor.dormitoryPrice.ToString()))
{
sql += ",[dormitoryPrice]='" + dor.dormitoryPrice + "'";
}
if (!string.IsNullOrEmpty(dor.beds))
{
sql += ",[beds]='" + dor.beds + "'";
}
if (!string.IsNullOrEmpty(dor.DormitoryBoos))
{
sql += ",[DormitoryBoos]='" + dor.DormitoryBoos + "'";
}
if (!string.IsNullOrEmpty(dor.Explain))
{
sql += ",[Explain]='" + dor.Explain + "'";
}
sql += " where [dormitoryID]=" + dor.dormitoryID;
return(DBHelper.ExecQuery(sql));
}
//更新宿舍信息
public string UpdateDormitoryBLL(Model.Dormitory dor)
{
return(Option(new DAL.DormitoryDAL().UpdateDormitoryDAL(dor), "更新"));
}
//添加宿舍信息
public int InsertDormitoryDAL(Model.Dormitory dor)
{
return(DBHelper.ExecQuery("insert into [Dormitory] ([dormitoryGrade],[dormitoryPerso],[dormitoryPrice],[beds],[DormitoryBoos],[Explain],[State],[ISBN]) values('" + dor.dormitoryGrade + "','" + dor.dormitoryPerso + "','" + dor.dormitoryPrice + "','" + dor.beds + "','" + dor.DormitoryBoos + "','" + dor.Explain + "','" + 0 + "','" + dor.ISBN + "')"));
}
