/// <summary> /// 增加一条数据 /// </summary> public bool Add(SeatManage.ClassModel.School model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_SM_School("); strSql.Append("SchoolNo,SchoolName)"); strSql.Append(" values ("); strSql.Append("@SchoolNo,@SchoolName)"); SqlParameter[] parameters = { new SqlParameter("@SchoolNo", SqlDbType.NVarChar, 50), new SqlParameter("@SchoolName", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.No; parameters[1].Value = model.Name; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SeatManage.ClassModel.School model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_SM_School set "); strSql.Append("SchoolName=@SchoolName"); strSql.Append(" where SchoolNo=@SchoolNo "); SqlParameter[] parameters = { new SqlParameter("@SchoolName", SqlDbType.NVarChar, 100), new SqlParameter("@SchoolNo", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Name; parameters[1].Value = model.No; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 提交设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { SeatManage.ClassModel.School newschool = new SeatManage.ClassModel.School(); newschool.No = txtSchoolNo.Text.Trim(); newschool.Name = txtSchoolName.Text.Trim(); List <SeatManage.ClassModel.School> schoollist = SeatManage.Bll.T_SM_School.GetSchoolInfoList(null, null); if (Request.QueryString["flag"] == "add") { foreach (SeatManage.ClassModel.School school in schoollist) { if (school.No == newschool.No || school.Name == newschool.Name) { FineUI.Alert.ShowInTop("校区编号或学校名称已存在,请重新输入!"); return; } } if (SeatManage.Bll.T_SM_School.AddNewSchool(newschool)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("校区添加成功!"); } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("校区添加失败!"); } } else if (Request.QueryString["flag"] == "edit") { foreach (SeatManage.ClassModel.School school in schoollist) { if (school.No != newschool.No && school.Name == newschool.Name) { FineUI.Alert.ShowInTop("学区名称已存在,请重新输入!"); return; } } if (SeatManage.Bll.T_SM_School.UpdataSchoolInfo(newschool)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("校区修改成功!"); } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("校区修改失败!"); } } }
/// <summary> /// 提交设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { if (Request.QueryString["Type"] != null && Request.QueryString["id"] != null) { if (!string.IsNullOrEmpty(txtpw1.Text) && !string.IsNullOrEmpty(txtpw2.Text)) { //密码是Juneberry_NJZBWX if (txtpw1.Text == txtpw2.Text && SeatManage.SeatManageComm.MD5Algorithm.GetMD5Str32(txtpw2.Text) == "88C5884397D51468FA04ACFA46483AE4") { FineUI.Alert.Show("验证成功!"); PageContext.RegisterStartupScript(ActiveWindow.GetConfirmHidePostBackReference()); switch (Request.QueryString["Type"]) { case "School": SeatManage.ClassModel.School school = new SeatManage.ClassModel.School(); school.No = Request.QueryString["id"]; if (!SeatManage.Bll.T_SM_School.DeleteSchool(school)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("删除失败!"); } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("删除完成!"); } break; case "Library": SeatManage.ClassModel.LibraryInfo library = new SeatManage.ClassModel.LibraryInfo(); library.No = Request.QueryString["id"]; if (!SeatManage.Bll.T_SM_Library.DeleteLibrary(library)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("删除失败!"); } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("删除完成!"); } break; case "ReadingRoom": SeatManage.ClassModel.ReadingRoomInfo room = new SeatManage.ClassModel.ReadingRoomInfo(); room.No = Request.QueryString["id"]; if (!SeatManage.Bll.T_SM_ReadingRoom.DeleteReadingRoom(room)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("删除失败!"); } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("删除完成!"); } break; } } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("密码错误!"); } } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("密码不能为空!"); return; } } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("加载页面失败,请重新打开"); } }