/// <summary>
/// 根据专业ID查询对应详细信息
/// </summary>
/// <param name="zyid"></param>
private void GetSpecial(int zyid)
{
TbSpeciality special = TbSpecialityManager.GetSpecialByID(zyid);
string message = special.ZyID + "|" + special.ZyName + "|" + special.Remark;
Response.Write(message);
}
static int FirstSxNum = 0;/*声明变量，初始化为0，用于判断筛选条件是否改变*/
/// <summary>
/// 获得专业信息的条数及页面信息
/// </summary>
/// <returns></returns>
public void GetAllSpenIntoCount()
{
string specname = txtSpecName.Value.Trim() == "按专业名模糊查找" ? "" : txtSpecName.Value.Trim();
if (specname != "按专业名模糊查找" && specname != "" && FirstSxNum == 0)
{
Pages = 1;
FirstSxNum = 1;
}
specialityList = TbSpecialityManager.GetAllSpecialityinfo(len, Pages, specname);
count = TbSpecialityManager.GetAllSpecialityinfo(specname).Rows.Count;
if (count % len == 0) //当数据库数据能整除len，最大页面数取Count/len的商
{
if (count > 0)
{
maxPage = count / len;
}
else
{
maxPage = 1;
}
}
else
{
maxPage = count / len + 1;//当数据库数据不能整除len，最大页面数取Count/len的商+1.
}
}
public static int maxPage = 0; //定义显示页面的最大页数，初始化为0
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie usercookie = Request.Cookies["nowloginuser"];
string url = PublicClass.CheckLogin(usercookie, "main");
if (url != "")
{
Response.Write(url);
return;
}
if (!IsPostBack)
{
string zyid = Request["ZyID"];
if (zyid != null)
{
//判断是否存在科目信息,存在则提示不能删除专业信息，不存在则执行删除操作
if (TbSubjectManager.QuerySubjectInfo(int.Parse(zyid)) <= 0)
{
//根据专业ID删除班级、老师信息表以及专业信息表对应的信息
TbClassManager.DeleteClassByZyID(int.Parse(zyid));
TbTeacherManager.DeleteTeaByZyID(int.Parse(zyid));
TbSpecialityManager.DeleteSpecByZyID(int.Parse(zyid));
}
else
{
Page.RegisterStartupScript("", "<script>alert('存在专业对应的科目信息，如需继续执行删除操作，请先删除科目信息！')</script>");
}
}
GetAllSpenIntoCount();
}
}
public static int Record = 0; //定义当前符号查询的记录总数，初始化为0
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie usercookie = Request.Cookies["nowloginuser"];
string url = PublicClass.CheckLogin(usercookie, "main");
if (url != "")
{
Response.Write(url);
return;
}
if (!IsPostBack)
{
string bjid = Request["BjID"];
if (bjid != null)
{
TbClassManager.DeleteClassInfo(int.Parse(bjid));
}
GetPageInfo();
//绑定专业名称
DataTable dt = TbSpecialityManager.BangdingZy();
textZy.DataSource = dt;
textZy.DataTextField = "ZyName";
textZy.DataValueField = "ZyID";
textZy.DataBind();
textZy.Items.Insert(0, new ListItem("请选择..", "0"));
}
}
public void GetSubject(int KmID)
{
TbSubject subject = TbSubjectManager.GetSubjectByID(KmID);
TbSpeciality speciality = TbSpecialityManager.GetSpecialByID(subject.ZyID);
string message = subject.KmID + "," + subject.KmName + "," + speciality.ZyName + "," + subject.Remark;
Response.Write(message);
}
/// <summary>
/// 根据班级ID查询对应详细详细
/// </summary>
/// <param name="BjID">班级ID</param>
private void GetClass(int BjID)
{
TbClass Class = TbClassManager.GetClassByID(BjID);
string ZyName = TbSpecialityManager.GetSpecialityName(Class.ZyID);//获取专业ID对应的专业名称
string message = Class.BjID + "|" + Class.BjName + "|" + Class.Nj + "|" + ZyName;
Response.Write(message);
}
/// <summary>
/// 绑定专业信息
/// </summary>
public void GetSpeciality()
{
DataTable dt = TbSpecialityManager.BangdingZy();
SpecID.DataSource = dt;
SpecID.DataTextField = "ZyName";
SpecID.DataValueField = "ZyID";
SpecID.DataBind();
SpecID.Items.Insert(0, new ListItem("请选择..", "0"));
}
public static int maxPage = 0; //定义显示页面的最大页数
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlSpec.DataSource = TbSpecialityManager.GetAllSpecialityListByScore();
ddlSpec.DataValueField = "ZyID";
ddlSpec.DataTextField = "ZyName";
ddlSpec.DataBind();
ddlSpec.Items.Insert(0, new ListItem("全部", "0"));
GetScoreList();
LoadData("", 1);
}
}
/// <summary>
/// 判断专业名是否存在
/// </summary>
/// <param name="specname">专业名</param>
private void CheckSpecNameIsExist(string specname)
{
string zyid = Request["zyid"];
int seeNum = TbSpecialityManager.seeSpecialityID(specname);
if (seeNum > 0 && zyid != seeNum.ToString())
{
Response.Write("已存在");
}
else
{
Response.Write("不存在");
}
}
/// <summary>
/// 根据教师编号LsID查询对应的详细信息
/// </summary>
/// <param name="LsID"></param>
private void GetTeacher(int YhID)
{
TbTeacher teacher = TbTeacherManager.GetTeacherInfoByLsID(YhID);
TbUser user = TbUserManager.GetUserInfoByYhID(YhID);
string role = "";
if (user.Zt == 1)
{
role = "管理员";
}
else
{
role = "教师";
}
TbSpeciality speciality = TbSpecialityManager.GetSpecialByID(teacher.ZyID);
string message = teacher.YhID + "|" + teacher.LsName + "|" + user.YhName + "|" + user.YhPwd + "|" + role + "|" + speciality.ZyName + "|" + teacher.Remark;
Response.Write(message);
}
/// <summary>
/// 新增界面确定添加按钮单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnbc_Click(object sender, EventArgs e)
{
TbSpeciality special = new TbSpeciality();
special.ZyName = this.ZyName.Text;
special.Remark = this.Remark.Text;
if (hidSpecID.Value != "")
{
special.ZyID = int.Parse(this.hidSpecID.Value);
TbSpecialityManager.EditSpecByID(special);
this.hidSpecID.Value = "";
}
else
{
TbSpecialityManager.addSpeciality(special.ZyName, special.Remark);
}
this.ZyName.Text = "";
this.Remark.Text = "";
GetAllSpenIntoCount();//重新调用方法实现数据加载
}
public static DataTable subjectList = new DataTable(); //定义一个Table表格，初始化为null.
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie usercookie = Request.Cookies["nowloginuser"];
string url = PublicClass.CheckLogin(usercookie, "main");
if (url != "")
{
Response.Write(url);
return;
}
string Sub_Sc = Request["Sub_Sc"];
if (!IsPostBack)
{
ZyName.Items.Clear();
List <TbSpeciality> TbSpeciality = TbSpecialityManager.GetAllSpecialityList();
ZyName.DataSource = TbSpeciality;
ZyName.DataTextField = "ZyName";
ZyName.DataValueField = "ZyID";
ZyName.DataBind();
ZyName.Items.Insert(0, new ListItem("请选择..", "0"));
if (Sub_Sc != null)
{
int count = TbTestPaperManager.GetAllTestPaperIsExist(int.Parse(Sub_Sc));
if (count <= 0)
{
TbSubjectManager.Dele_Sub(int.Parse(Sub_Sc));
}
else
{
Page.RegisterStartupScript("", "<script>alert('请先删除试卷信息！！')</script>");
}
}
Load_Subject(); //调用方法实现数据加载。
}
}
