protected void Page_Load( object sender , EventArgs e )
{
Security s = Session["sec"] as Security;
if (s == null)
{
Response.Redirect("error.aspx");
}
if (!IsPostBack)
{
SYSDS.SelectCommand = "SELECT [ID], [SYMC] FROM [V_SYJBXXB] where kcid in (select kcid from v_gly_sys_kc where glyid='" + s.getUserCode() + "') ORDER BY [SYMC]";
sysSDS.SelectCommand = "SELECT [ID], [SYSDD] FROM [T_SYSXXB] WHERE id in (select sysid from v_gly_sys_kc where glyid='" + s.getUserCode() + "') and ([ID] <> @ID) ORDER BY [SYSDD]";
for (int i = 1; i <= 7; i++)
{
for (int j = 1; j <= 7; j++)
{
Table1.Rows[i].Cells[j].Text = " ";
}
}
string ap = Request["ap"];
if (ap == null || ap == "") ap = "0";
if (ap.Equals("1"))
{//安排实验
dbModule dm = new dbModule();
int sysid = Convert.ToInt32(Session["sysid"]);
int syid = Convert.ToInt32(Session["syid"]);
string syjsid = Session["syjsid"] as string;
int syrs = Convert.ToInt32(Session["syrs"]);
string sybh = Session["sybh"] as string;
string syxn = Session["syxn"] as string;
int syxq = Convert.ToInt32(Session["syxq"]);
int syz = Convert.ToInt32(Session["syz"]);
int syxingq = Convert.ToInt32(Request["syxingq"]);
int syks = Convert.ToInt32(Request["syks"]);
int i = dm.addSyjh(syid, sybh, syjsid, sysid, syrs, syxn, syxq, syz, syxingq, syks);
syrsTxt.Text = syrs.ToString();
sybhTXT.Text = sybh;
xnDDL.DataBind();
ListItem li1 = xnDDL.Items.FindByValue(syxn);
if (li1 != null)
{
li1.Selected = true;
}
xqDDL.DataBind();
ListItem li2 = xqDDL.Items.FindByValue(syxq.ToString());
if (li2 != null)
{
li2.Selected = true;
}
zDDL.DataBind();
ListItem li3 = zDDL.Items.FindByValue(syz.ToString());
if (li3 != null)
{
li3.Selected = true;
}
sysDDL.DataBind();
ListItem li4 = sysDDL.Items.FindByValue(sysid.ToString());
if (li4 != null)
{
li4.Selected = true;
}
syjsDDL.DataBind();
ListItem li5 = syjsDDL.Items.FindByValue(syjsid);
if (li5 != null)
{
li5.Selected = true;
}
syDDL.DataBind();
ListItem li6 = syDDL.Items.FindByValue(syid.ToString());
if (li6 != null)
{
li6.Selected = true;
}
Button1_Click(this, new EventArgs());
}
else if (ap.Equals("2"))
{
string syjhid = Request["syjhid"];
int sysid = Convert.ToInt32(Session["sysid"]);
string syxn = Session["syxn"] as string;
int syxq = Convert.ToInt32(Session["syxq"]);
int syz = Convert.ToInt32(Session["syz"]);
dbModule dm = new dbModule();
int i = dm.delSyjh(Convert.ToInt32(syjhid));
if (i == 0)
{
Response.Write("");
Button1_Click(this, new EventArgs());
}
else
{
xnDDL.DataBind();
ListItem li1 = xnDDL.Items.FindByValue(syxn);
if (li1 != null)
{
li1.Selected = true;
}
xqDDL.DataBind();
ListItem li2 = xqDDL.Items.FindByValue(syxq.ToString());
if (li2 != null)
{
li2.Selected = true;
}
zDDL.DataBind();
ListItem li3 = zDDL.Items.FindByValue(syz.ToString());
if (li3 != null)
{
li3.Selected = true;
}
sysDDL.DataBind();
ListItem li4 = sysDDL.Items.FindByValue(sysid.ToString());
if (li4 != null)
{
li4.Selected = true;
}
Button1_Click(this, new EventArgs());
}
}
}
}