/// <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("图书馆修改失败！");
}
}
}
