/// <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 + "')")); }