/// <summary> /// 增加一条数据 /// </summary> public bool Add(SeatManage.ClassModel.LibraryInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_SM_Library("); strSql.Append("LibraryNo,LibraryName,SchoolNo,AreaInfo)"); strSql.Append(" values ("); strSql.Append("@LibraryNo,@LibraryName,@SchoolNo,@AreaInfo)"); SqlParameter[] parameters = { new SqlParameter("@LibraryNo", SqlDbType.NVarChar, 50), new SqlParameter("@LibraryName", SqlDbType.NVarChar, 100), new SqlParameter("@SchoolNo", SqlDbType.Int, 4), new SqlParameter("@AreaInfo", SqlDbType.Text) }; parameters[0].Value = model.No; parameters[1].Value = model.Name; parameters[2].Value = model.School.No; parameters[3].Value = model.AreaToXml(); int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SeatManage.ClassModel.LibraryInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_SM_Library set "); strSql.Append("LibraryName=@LibraryName,"); strSql.Append("SchoolNo=@SchoolNo,"); strSql.Append("AreaInfo=@AreaInfo"); strSql.Append(" where LibraryNo=@LibraryNo "); SqlParameter[] parameters = { new SqlParameter("@LibraryName", SqlDbType.NVarChar, 100), new SqlParameter("@SchoolNo", SqlDbType.Int, 4), new SqlParameter("@AreaInfo", SqlDbType.Text), new SqlParameter("@LibraryNo", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Name; parameters[1].Value = model.School.No; parameters[2].Value = model.AreaToXml(); parameters[3].Value = model.No; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(SeatManage.ClassModel.LibraryInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from T_SM_Library "); strSql.Append(" where LibraryNo=@LibraryNo "); SqlParameter[] parameters = { new SqlParameter("@LibraryNo", SqlDbType.NVarChar, 50) }; parameters[0].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) { 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("加载页面失败,请重新打开"); } }
/// <summary> /// 提交设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { SeatManage.ClassModel.LibraryInfo newlibrary = new SeatManage.ClassModel.LibraryInfo(); newlibrary.No = txtLibraryNo.Text.Trim(); newlibrary.Name = txtLibraryName.Text.Trim(); newlibrary.School.No = ddlschool.SelectedValue; if (txtArea.Text.Trim() != "") { string[] areaList = txtArea.Text.Split(';'); for (int i = 0; i < areaList.Length; i++) { if (areaList[i].Trim() != "") { SeatManage.ClassModel.AreaInfo Area = new SeatManage.ClassModel.AreaInfo(); Area.AreaName = areaList[i]; Area.AreaNo = i; newlibrary.AreaList.Add(Area); } } } List <SeatManage.ClassModel.LibraryInfo> librarylist = SeatManage.Bll.T_SM_Library.GetLibraryInfoList(null, null, null); if (Request.QueryString["flag"] == "add") { foreach (SeatManage.ClassModel.LibraryInfo library in librarylist) { if (library.No == newlibrary.No || library.Name == newlibrary.Name) { FineUI.Alert.ShowInTop("图书馆编号或图书馆名称已存在,请重新输入!"); return; } } if (SeatManage.Bll.T_SM_Library.AddNewLibrary(newlibrary)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("图书馆添加成功!"); } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("图书馆添加失败!"); } } else if (Request.QueryString["flag"] == "edit") { foreach (SeatManage.ClassModel.LibraryInfo library in librarylist) { if (library.No != newlibrary.No && library.Name == newlibrary.Name) { FineUI.Alert.ShowInTop("图书馆名称已存在,请重新输入!"); return; } } if (SeatManage.Bll.T_SM_Library.UpdataLibraryInfo(newlibrary)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("图书馆修改成功!"); } else { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("图书馆修改失败!"); } } }