/// <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("加载页面失败，请重新打开");
}
}
