static int FirstSxNum = 0;/*声明变量，初始化为0，用于判断筛选条件是否改变*/
/// <summary>
/// 加载科目列表信息
/// </summary>
/// <param name="apge">当前页面</param>
public void Load_Subject()
{
string Txt_ZyName = txtSpecName.Value.Trim() == "按专业名模糊查找" ? "" : txtSpecName.Value.Trim();
if (Txt_ZyName != "按专业名模糊查找" && Txt_ZyName != "" && FirstSxNum == 0)
{
apge = 1;
FirstSxNum = 1;
}
subjectList = TbSubjectManager.GetSubject(len, apge, Txt_ZyName);
Count = TbSubjectManager.GetSubject(Txt_ZyName).Rows.Count;
if (Count != 0)
{
if (Count % len == 0) //当数据库数据能整除10，最大页面数取Count/len的商
{
Maxapge = Count / len;
}
else
{
Maxapge = Count / len + 1;//当数据库数据不能整除10，最大页面数取Count/len的商+1.
}
}
else
{
Maxapge = 1;
}
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
TbSubject subject = new TbSubject();
subject.KmName = this.KmName.Text;
subject.Remark = this.Remark.Text;
subject.ZyID = int.Parse(this.ZyName.SelectedValue);
if (this.HiddenKmID.Value == "")
{
subject.ZyID = int.Parse(this.ZyName.SelectedValue);
TbSubjectManager.addSubject(subject);
if (apge <= Maxapge)
{
Load_Subject();
}
else
{
apge--;//到达最后一页，apge已经加一，所以需要减一
}
}
else
{
subject.KmID = int.Parse(this.HiddenKmID.Value);
TbSubjectManager.Get_SubjectBy(subject);
this.HiddenKmID.Value = "";
}
this.KmName.Text = "";
this.Remark.Text = "";
Load_Subject();
}
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 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="specid">专业ID</param>
public void GetSubjectBySpecid(int specid)
{
DataTable table = TbSubjectManager.GetSubjectListByZyid(specid);
string message = "";
foreach (DataRow row in table.Rows)
{
message += row["KmName"].ToString() + "*";
}
Response.Write(message);
}
/// <summary>
/// 判断科目名是否存在
/// </summary>
/// <param name="KmName"></param>
public void CheckSunjectNameIsExist(string KmName, int ZyID)
{
string KmID = Request["KmID"];
int KmNum = TbSubjectManager.GetSubjectByKmName(KmName, ZyID);
if (KmNum > 0 && KmID != KmNum.ToString())
{
Response.Write("已存在");
}
else
{
Response.Write("不存在");
}
}
protected void ddlSpec_SelectedIndexChanged(object sender, EventArgs e)
{
if (SpecID.SelectedValue.ToString() != "0")
{
int zyid = int.Parse(SpecID.SelectedValue.ToString());
List <TbSubject> list = TbSubjectManager.GetSubjectListByZyId(zyid);
ddlSubject.DataSource = list;
ddlSubject.DataValueField = "KmID";
ddlSubject.DataTextField = "KmName";
ddlSubject.DataBind();
ddlSubject.Items.Insert(0, new ListItem("请选择.."));
}
else
{
ddlSubject.Items.Clear();
ddlSubject.Text = "请选择..";
}
}
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(); //调用方法实现数据加载。
}
}
