protected void btnDel_Click(object sender, EventArgs e)
{
ArrayList selected = GetSelectedGV();
if (selected.Count == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请选择课程任务!');</script>");
return;
}
else
{
foreach (GridViewRow row in GV.Rows)
{
if (((CheckBox)row.FindControl("chkSelected")).Checked)
{
KCRW.Delete(row.Cells[1].Text, row.Cells[3].Text, row.Cells[6].Text, row.Cells[7].Text, row.Cells[8].Text);
}
}
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功');</script>");
Query();
}
}
protected void btnSave_ServerClick(object sender, EventArgs e)
{
if (btnAdd.Disabled == true)
{
Hashtable hash = new Hashtable();
if (KCRW.HasKCRW(txtJsbh.Value, txtKcbh.Value, txtJxbbh.Value, txtKbxn.Value, selKbxq.Value))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加失败，课程任务已存在！');</script>");
return;
}
//if (GetSelectedJS().Count != 1)
//{
// Response.Write("<Script Language=JavaScript>alert('请选择一个教师!');</Script>");
// return;
//}
//foreach (GridViewRow row in GVJS.Rows)
//{
// if (((CheckBox)row.FindControl("chkSelected")).Checked)
// {
// hash.Add("jsbh", SqlStringConstructor.GetQuotedString(Convert.ToString(row.Cells[1].Text)));
// }
//}
//if (GetSelectedKC().Count != 1)
//{
// Response.Write("<Script Language=JavaScript>alert('请选择一个课程!');</Script>");
// return;
//}
//foreach (GridViewRow row in GVKC.Rows)
//{
// if (((CheckBox)row.FindControl("chkSelected")).Checked)
// {
// hash.Add("kcbh", SqlStringConstructor.GetQuotedString(Convert.ToString(row.Cells[1].Text)));
// }
//}
hash.Add("jsbh", SqlStringConstructor.GetQuotedString(txtJsbh.Value));
hash.Add("kcbh", SqlStringConstructor.GetQuotedString(txtKcbh.Value));
hash.Add("llxs", Convert.ToInt32(txtLlxs.Value));
hash.Add("syxs", Convert.ToInt32(txtSyxs.Value));
hash.Add("sydxs", Convert.ToDouble(txtSydxs.Value));
hash.Add("kbxn", SqlStringConstructor.GetQuotedString(txtKbxn.Value));
hash.Add("kbxq", SqlStringConstructor.GetQuotedString(selKbxq.Value));
hash.Add("jxbbh", SqlStringConstructor.GetQuotedString(txtJxbbh.Value));
Gzl.BusinessLogicLayer.KCRW.Add(hash);
txtJsbh.Value = "";
txtKcbh.Value = "";
txtZdjs.Value = "";
txtKcmc.Value = "";
txtJxbbh.Value = "";
txtJxbrs.Value = "";
txtLlxs.Value = "";
txtSydxs.Value = "";
txtSyxs.Value = "";
txtLlxs.Disabled = true;
txtSyxs.Disabled = true;
txtSydxs.Disabled = true;
selKbxq.Disabled = true;
btnJssz.Disabled = true;
btnKcsz.Disabled = true;
btnJxbsz.Enabled = false;
btnAdd.Disabled = false;
btnSave.Disabled = true;
btnCancel.Disabled = true;
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功');</script>");
Query();
//QueryKC();
//QueryJS();
}
if (btnChag.Disabled == true)
{
Hashtable hash = new Hashtable();
//if (GetSelectedJS().Count != 1)
//{
// Response.Write("<Script Language=JavaScript>alert('请选择一个教师!');</Script>");
// return;
//}
//foreach (GridViewRow row in GVJS.Rows)
//{
// if (((CheckBox)row.FindControl("chkSelected")).Checked)
// {
// hash.Add("jsbh", SqlStringConstructor.GetQuotedString(Convert.ToString(row.Cells[1].Text)));
// }
//}
//if (GetSelectedKC().Count != 1)
//{
// Response.Write("<Script Language=JavaScript>alert('请选择一个课程!');</Script>");
// return;
//}
//foreach (GridViewRow row in GVKC.Rows)
//{
// if (((CheckBox)row.FindControl("chkSelected")).Checked)
// {
// hash.Add("kcbh", SqlStringConstructor.GetQuotedString(Convert.ToString(row.Cells[1].Text)));
// }
//}
hash.Add("jsbh", SqlStringConstructor.GetQuotedString(txtJsbh.Value));
hash.Add("kcbh", SqlStringConstructor.GetQuotedString(txtKcbh.Value));
hash.Add("llxs", Convert.ToInt32(txtLlxs.Value));
hash.Add("syxs", Convert.ToInt32(txtSyxs.Value));
hash.Add("sydxs", Convert.ToDouble(txtSydxs.Value));
hash.Add("kbxn", SqlStringConstructor.GetQuotedString(txtKbxn.Value));
hash.Add("kbxq", SqlStringConstructor.GetQuotedString(selKbxq.Value));
hash.Add("jxbbh", SqlStringConstructor.GetQuotedString(txtJxbbh.Value));
string where = "Where jsbh = " + SqlStringConstructor.GetQuotedString(Tjsbh.Text)
+ " And kcbh = " + SqlStringConstructor.GetQuotedString(Tkcbh.Text) + " And jxbbh ="
+ SqlStringConstructor.GetQuotedString(Tjxbbh.Text) + " And kbxn = " + SqlStringConstructor.GetQuotedString(Tkbxn.Text)
+ " And kbxq =" + SqlStringConstructor.GetQuotedString(Tkbxq.Text);
Gzl.BusinessLogicLayer.KCRW.Update(hash, where);
txtJsbh.Value = "";
txtKcbh.Value = "";
txtZdjs.Value = "";
txtKcmc.Value = "";
txtJxbbh.Value = "";
txtJxbrs.Value = "";
txtLlxs.Value = "";
txtSydxs.Value = "";
txtSyxs.Value = "";
txtLlxs.Disabled = true;
txtSyxs.Disabled = true;
txtSydxs.Disabled = true;
selKbxq.Disabled = true;
btnJssz.Disabled = true;
btnKcsz.Disabled = true;
btnJxbsz.Enabled = false;
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnChag.Disabled = false;
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功');</script>");
Query();
//QueryKC();
//QueryJS();
}
}
protected void btnChag_ServerClick(object sender, EventArgs e)
{
ArrayList selected = GetSelectedGV();
KCRW kcrw = new KCRW();
if (selected.Count != 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请选择一个课程任务!');</script>");
return;
}
string jsbh = "";
string kcmc = "";
string jxbmc = "";
string kbxn = "";
string kbxq = "";
foreach (GridViewRow row in GV.Rows)
{
if (((CheckBox)row.FindControl("chkSelected")).Checked)
{
jsbh = Convert.ToString(row.Cells[1].Text);
kcmc = Convert.ToString(row.Cells[3].Text);
jxbmc = Convert.ToString(row.Cells[6].Text);
kbxn = Convert.ToString(row.Cells[7].Text);
kbxq = Convert.ToString(row.Cells[8].Text);
}
}
kcrw.LoadData(jsbh, kcmc, jxbmc, kbxn, kbxq);
Tjsbh.Text = kcrw.Jsbh;
Tkcbh.Text = kcrw.Kcbh;
Tjxbbh.Text = kcrw.Jxbbh;
Tkbxn.Text = kcrw.Kbxn;
Tkbxq.Text = kcrw.Kbxq;
txtJsbh.Value = kcrw.Jsbh;
txtZdjs.Value = kcrw.Jsxm;
//QueryJS2(kcrw.Jsbh);
//foreach (GridViewRow row in GVJS.Rows)
//{
// ((CheckBox)row.FindControl("chkSelected")).Checked = true;
//}
txtKcbh.Value = kcrw.Kcbh;
txtKcmc.Value = kcrw.Kcmc;
//QueryKC2();
//foreach (GridViewRow row in GVKC.Rows)
//{
// ((CheckBox)row.FindControl("chkSelected")).Checked = true;
//}
txtKbxn.Value = kcrw.Kbxn;
foreach (ListItem item in selKbxq.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
if (item.Text == kcrw.Kbxq)
{
item.Selected = true;
}
}
txtLlxs.Value = Convert.ToString(kcrw.Llxs);
txtSyxs.Value = Convert.ToString(kcrw.Syxs);
txtSydxs.Value = Convert.ToString(kcrw.Sydxs);
txtJxbbh.Value = kcrw.Jxbbh;
JXB jxb = new JXB();
//if (kcrw.Jxbbh.Substring(0, 2) == "bx")
//{
jxb.LoadDataJXB(kcrw.Jxbbh);
txtJxbrs.Value = jxb.Jxbzrs;
//foreach (ListItem item in selJxblx.Items)
//{
// if (item.Selected == true)
// {
// item.Selected = false;
// }
// if (item.Value == kcrw.Jxbbh.Substring(0, 2))
// {
// item.Selected = true;
// }
//}
//DataTable dt = JXB.LoadDataGX(kcrw.Jxbbh);
//listRight.Items.Clear();
//foreach (DataRow dr in dt.Rows)
//{
// listRight.Items.Add(new ListItem(dr["bjmc"].ToString(), dr["bjbh"].ToString()));
//}
//leftTree.Enabled = true;
//listRight.Enabled = true;
//btnLeftToRight.Disabled = false;
//btnRightToLeft.Disabled = false;
// txtJxbrs.Disabled = true;
//}
//else
//{
// jxb.LoadDataJXB(kcrw.Jxbbh);
// txtJxbrs.Value = jxb.Jxbzrs;
//foreach (ListItem item in selJxblx.Items)
//{
// if (item.Selected == true)
// {
// item.Selected = false;
// }
// if (item.Value == kcrw.Jxbbh.Substring(0, 2))
// {
// item.Selected = true;
// }
//}
//leftTree.Enabled = false;
//listRight.Enabled = false;
//btnLeftToRight.Disabled = false;
//btnRightToLeft.Disabled = false;
//txtJxbrs.Disabled = false;
//}
txtLlxs.Disabled = false;
txtSyxs.Disabled = false;
txtSydxs.Disabled = false;
selKbxq.Disabled = false;
btnJssz.Disabled = false;
btnJxbsz.Enabled = true;
btnKcsz.Disabled = false;
btnAdd.Disabled = false;
btnChag.Disabled = true;
btnDel.Enabled = true;
btnSave.Disabled = false;
btnCancel.Disabled = false;
//selJxblx.Enabled = false;
}
