protected void btnDelete_Click(object sender, EventArgs e)
{
int m = 0;
Fannie.InitSystem init = new Fannie.InitSystem();
for (int i = 0; i < gvMajor.Rows.Count; i++)
{
if (((CheckBox)(gvMajor.Rows[i].FindControl("cbSelect"))).Checked)
{
int id = Convert.ToInt32(gvMajor.DataKeys[i].Value.ToString());
init.DeleteMajor(id);
}
else
{
m++;
}
}
if (m == gvMajor.Rows.Count)
{
Response.Write("<script>alert('请先选择需要删除的记录')</script>");
}
else
{
GetMajor();
}
}
protected void btnNew_Click(object sender, EventArgs e)
{
bool isnull = true;
for (int i = 0; i < gvMajor.Rows.Count; i++)
{
if (((TextBox)gvMajor.Rows[i].FindControl("tbMajor")).Text == tbNewMajor.Text)
{
isnull = false;
break;
}
}
if (isnull)
{
Fannie.InitSystem init = new Fannie.InitSystem();
init.InsetMajor(tbNewMajor.Text);
GetMajor();
tbNewMajor.Text = "";
}
else
{
tbNewMajor.Text = "";
Response.Write("<script>alert('该专业已经存在，请重新输入专业名称')</script>");
}
}
//选题结束时间
protected void btnSave3_Click(object sender, EventArgs e)
{
Fannie.InitSystem init = new Fannie.InitSystem();
DateTime end = Convert.ToDateTime(sEnd.Value);
if (init.SetTime(4, end) > 0)
{
Response.Write("<script>alert(设置成功')</script>");
}
}
//课题申报开始时间
protected void btnSave4_Click(object sender, EventArgs e)
{
Fannie.InitSystem init = new Fannie.InitSystem();
DateTime begin = Convert.ToDateTime(tBegin.Value);
if (init.SetTime(1, begin) > 0)
{
Response.Write("<script>alert(设置成功')</script>");
}
}
//毕业设计年份设置
protected void btnSave1_Click(object sender, EventArgs e)
{
string year = tYeat.Value;
Fannie.InitSystem ini = new Fannie.InitSystem();
if (ini.SetYear(year) > 0)
{
Response.Write("<script>alert(设置成功')</script>");
}
}
protected void gvMajor_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(gvMajor.DataKeys[e.RowIndex].Value.ToString());
Fannie.InitSystem init = new Fannie.InitSystem();
if (init.DeleteMajor(id) > 0)
{
GetMajor();
Response.Write("<script>alert('删除成功')</script>");
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
Fannie.InitSystem inits = new Fannie.InitSystem();
if (tbCollege.Text != "")
{
int reslut = inits.InitCollege(tbCollege.Text.Trim());
if (reslut > 0)
{
Response.Write("<script>alert('设置成功')</script>");
}
}
}
protected void gvMajor_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int id = Convert.ToInt32(gvMajor.DataKeys[e.RowIndex].Value.ToString());
string name = ((TextBox)(gvMajor.Rows[e.RowIndex].Cells[2].Controls[0])).Text;
Fannie.InitSystem init = new Fannie.InitSystem();
if (init.ModifyMajor(id, name) > 0)
{
gvMajor.EditIndex = -1;
GetMajor();
Response.Write("<script>alert('修改成功')</script>");
}
}
private void GetSys()
{
Fannie.InitSystem init = new Fannie.InitSystem();
DataSet ds = init.GetSysSet();
if (ds.Tables[0].Rows.Count != 0)
{
tYeat.Value = ds.Tables[0].Rows[0]["SubjectTime"].ToString();
tBegin.Value = ds.Tables[0].Rows[0]["SubjectBegin"].ToString();
tEnd.Value = ds.Tables[0].Rows[0]["SubjectEnd"].ToString();
sBegin.Value = ds.Tables[0].Rows[0]["ChooseBegin"].ToString();
sEnd.Value = ds.Tables[0].Rows[0]["ChooseEnd"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Fannie.InitSystem init = new Fannie.InitSystem();
name = init.GetAcademy();
if (name != null)
{
tbCollege.Text = name;
}
else
{
tbCollege.Text = "";
}
}
}
private void GetMajor()
{
Fannie.InitSystem init = new Fannie.InitSystem();
DataSet ds = init.GetMajor();
gvMajor.DataKeyNames = new string[] { "ProfessionID" };
DataColumn dc = new DataColumn();
dc.ColumnName = "AutoId";
ds.Tables[0].Columns.Add(dc);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["AutoId"] = i + 1;
}
gvMajor.DataSource = ds;
gvMajor.DataBind();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Fannie.InitSystem init = new Fannie.InitSystem();
int id;
string name;
for (int i = 0; i < gvMajor.Rows.Count; i++)
{
if (((CheckBox)(gvMajor.Rows[i].Cells[0].Controls[0])).Checked)
{
id = Convert.ToInt32(gvMajor.DataKeys[i].Value.ToString());
name = ((TextBox)gvMajor.Rows[i].FindControl("tbMajor")).Text;
init.ModifyMajor(id, name);
}
}
GetMajor();
btnDelete.Enabled = true;
btnNew.Enabled = true;
}
