protected void btnCancel_ServerClick(object sender, EventArgs e)
{
int count = 0;
int total = 0;
BJ bj = new BJ();
foreach (ListItem li in listRight.Items)
{
if (li.Selected == true)
{
count++;
for (int j = 0; j < leftTree.CheckedNodes.Count; j++)
{
if (li.Value == leftTree.CheckedNodes[j].Value)
{
leftTree.CheckedNodes[j].Checked = false;
}
}
}
}
for (int i = 0; i <= count; i++)
{
listRight.Items.Remove(listRight.SelectedItem);
}
foreach (ListItem li in listRight.Items)
{
bj.LoadData(li.Value);
total = total + bj.Bjrs;
}
txtJxbrs.Value = Convert.ToString(total);
}
private void InitData()
{
leftTree.Nodes.Clear();
Hashtable htYx = new Hashtable();
htYx.Add("yxbz", 1);
DataTable dtYx = YX.QueryYX(htYx);
foreach (DataRow drYx in dtYx.Rows)
{
TreeNode RootNode = new TreeNode();
RootNode.Text = drYx["Yxmc"].ToString();
RootNode.Value = drYx["Yxbh"].ToString();
leftTree.Nodes.Add(RootNode);
Hashtable ht = new Hashtable();
ht.Add("Zybh", drYx["Yxbh"].ToString());
ht.Add("yxbz", 1);
DataTable dtZy = ZY.QueryZY(ht);
foreach (DataRow drZy in dtZy.Rows)
{
TreeNode ParentNode = new TreeNode();
AddNodes(RootNode, ParentNode, drZy["Zymc"].ToString(), drZy["Zybh"].ToString());
Hashtable ht1 = new Hashtable();
ht1.Add("bjbh", drZy["Zybh"].ToString());
ht1.Add("yxbz", 1);
DataTable dtBj = BJ.QueryBJ(ht1);
foreach (DataRow drBj in dtBj.Rows)
{
TreeNode LeafNode = new TreeNode();
AddNodes(ParentNode, LeafNode, drBj["Bjmc"].ToString(), drBj["Bjbh"].ToString());
LeafNode.ShowCheckBox = true;
}
}
}
}
//“<<删除”按钮
protected void btnRightToLeft_ServerClick(object sender, EventArgs e)
{
int count = 0; //初始化统计标志
int total = 0; //初始化教学班人数
BJ bj = new BJ(); //实例化班级
foreach (ListItem li in listRight.Items)
{
if(li.Selected == true) //当列表框数据项被选中
{
count++; //统计被选中的数据项
for (int j = 0; j < leftTree.CheckedNodes.Count; j++)
{
if (li.Value == leftTree.CheckedNodes[j].Value) //找出与列表框被选中的数据项的值相同的树节点,并去除其被勾选状态
{
leftTree.CheckedNodes[j].Checked = false;
}
}
}
}
for (int i = 0; i<=count;i++) //逐项移除列表框被选中的数据项
{
listRight.Items.Remove(listRight.SelectedItem);
}
foreach (ListItem li in listRight.Items) //统计教学班总人数
{
bj.LoadData(li.Value);
total = total + bj.Bjrs;
}
txtJxbrs.Value = Convert.ToString(total); //把统计出来的教学班人数写入到教学班总人数文本框中
}
//“增加>>”按钮
protected void btnLeftToRight_ServerClick(object sender, EventArgs e)
{
BJ bj = new BJ(); //实例化班级
int total = 0; //初始化人数
SortedList sl = new SortedList(); //实例化排序集合
listRight.Items.Clear(); //清空列表框的选项
foreach (TreeNode tn in leftTree.CheckedNodes) //把树形图被勾选的叶子结点添加到排序集合中
{
sl.Add(tn.Text, tn.Value);
}
foreach (DictionaryEntry item in sl) //把排序集合中的数据项添加到列表框中，并统计教学班总人数
{
listRight.Items.Add(new ListItem(item.Key.ToString(),item.Value.ToString()));
bj.LoadData(item.Value.ToString());
total = total + bj.Bjrs;
}
txtJxbrs.Value = Convert.ToString(total); //把统计出来的教学班人数写入到教学班总人数文本框中
}
protected void btnSave_ServerClick(object sender, EventArgs e)
{
BJ bj = new BJ();
int total = 0;
SortedList sl = new SortedList();
listRight.Items.Clear();
foreach (TreeNode tn in leftTree.CheckedNodes)
{
sl.Add(tn.Text, tn.Value);
}
foreach (DictionaryEntry item in sl)
{
listRight.Items.Add(new ListItem(item.Key.ToString(), item.Value.ToString()));
bj.LoadData(item.Value.ToString());
total = total + bj.Bjrs;
}
txtJxbrs.Value = Convert.ToString(total);
}
/// <summary>
/// 初始化页面数据
/// </summary>
private void InitData()
{
string loginName = Session["login_name"].ToString();
userMessage01.InnerText = "你好！" + loginName;
labelXnd.Text = Session["xnd"].ToString() + "学年度";
leftTree.Nodes.Clear();
Hashtable htYx = new Hashtable();
htYx.Add("yxbz", 1);
DataTable dtYx = YX.QueryYX(htYx);
foreach (DataRow drYx in dtYx.Rows)
{
TreeNode RootNode = new TreeNode();
RootNode.Text = drYx["Yxmc"].ToString();
RootNode.Value = drYx["Yxbh"].ToString();
leftTree.Nodes.Add(RootNode);
Hashtable ht = new Hashtable();
ht.Add("Zybh", drYx["Yxbh"].ToString());
ht.Add("yxbz", 1);
DataTable dtZy = ZY.QueryZY(ht);
foreach (DataRow drZy in dtZy.Rows)
{
TreeNode ParentNode = new TreeNode();
AddNodes(RootNode, ParentNode, drZy["Zymc"].ToString(), drZy["Zybh"].ToString());
Hashtable ht1 = new Hashtable();
ht1.Add("bjbh", drZy["Zybh"].ToString());
ht1.Add("yxbz", 1);
DataTable dtBj = BJ.QueryBJ(ht1);
foreach (DataRow drBj in dtBj.Rows)
{
TreeNode LeafNode = new TreeNode();
AddNodes(ParentNode,LeafNode,drBj["Bjmc"].ToString(),drBj["Bjbh"].ToString());
LeafNode.ShowCheckBox = true;
}
}
}
}
protected void btnSave_ServerClick(object sender, EventArgs e)
{
if (btnAdd.Disabled == true)
{
string bjmc = selNj.Value + selSszy.SelectedItem.Text + selBh.Value + "班";
if (BJ.HasBJ(bjmc))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('已经存在该班级!');</script>");
}
else
{
string bjbh = selNj.Value + selSszy.SelectedValue + "0" + selBh.Value; //构造user信息哈希表
Hashtable hash = new Hashtable();
hash.Add("bjbh", SqlStringConstructor.GetQuotedString(bjbh));
hash.Add("bjmc", SqlStringConstructor.GetQuotedString(bjmc));
hash.Add("bjrs", Convert.ToInt32(txtBjrs.Value));
hash.Add("yxbz", Convert.ToInt32(Convert.ToString(selYxbz.Value)));
Gzl.BusinessLogicLayer.BJ.Add(hash);
txtBjmc.Value = "";
txtBjrs.Value = "";
txtBjrs.Disabled = true;
selBh.Disabled = true;
selNj.Disabled = true;
selYxbz.Disabled = true;
selSsyx.Enabled = false;
selSszy.Enabled = false;
btnAdd.Disabled = false;
btnCancel.Disabled = true;
btnSave.Disabled = true;
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + bjbh + " " + bjmc + "添加成功');</script>");
Query();
}
}
if (btnChag.Disabled == true)
{
Hashtable ht = new Hashtable();
string bjbh = txtBjbh.Text;
string bjmc = selNj.Value + selSszy.SelectedItem.Text + selBh.Value + "班";
int bjrs = Convert.ToInt32(txtBjrs.Value);
ht.Add("bjmc", SqlStringConstructor.GetQuotedString(bjmc));
ht.Add("bjrs", bjrs);
ht.Add("yxbz", Convert.ToInt32(Convert.ToString(selYxbz.Value)));
string where = "Where bjbh = " + SqlStringConstructor.GetQuotedString(bjbh);
Gzl.BusinessLogicLayer.BJ.Update(ht, where);
txtBjmc.Value = "";
txtBjrs.Value = "";
txtBjrs.Disabled = true;
selBh.Disabled = true;
selNj.Disabled = true;
selYxbz.Disabled = true;
selSsyx.Enabled = false;
selSszy.Enabled = false;
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnChag.Disabled = false;
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功');</script>");
Query();
}
}
protected void btnChag_ServerClick(object sender, EventArgs e)
{
ArrayList selectedBJ = GetSelected();
BJ bj = new BJ();
if (selectedBJ.Count != 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请选择一个班级!');</script>");
return;
}
string bjbh = selectedBJ[0].ToString();
bj.LoadData(bjbh);
txtBjbh.Text = bj.Bjbh;
txtBjmc.Value = bj.Bjmc;
txtBjrs.Value = bj.Bjrs.ToString();
foreach (ListItem item in selSsyx.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
if (item.Value == bj.Bjbh.Substring(4, 2))
{
item.Selected = true;
}
}
Hashtable ht = new Hashtable();
ht.Add("zybh", selSsyx.SelectedValue);
DataTable dt = ZY.QueryZY(ht);
selSszy.Items.Clear();
foreach (DataRow dr in dt.Rows)
{
selSszy.Items.Add(new ListItem(dr["zymc"].ToString(), dr["zybh"].ToString()));
}
foreach (ListItem item in selSszy.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
if (item.Value == bj.Bjbh.Substring(4, 6))
{
item.Selected = true;
}
}
foreach (ListItem item in selNj.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
if (item.Value == bj.Bjbh.Substring(0, 4))
{
item.Selected = true;
}
}
foreach (ListItem item in selBh.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
if (item.Value == bj.Bjbh.Substring(11, 1))
{
item.Selected = true;
}
}
foreach (ListItem item in selYxbz.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
Boolean text = Convert.ToBoolean(item.Text);
if (text == bj.Yxbz)
{
item.Selected = true;
}
}
txtBjrs.Disabled = false;
selBh.Disabled = false;
selNj.Disabled = false;
selYxbz.Disabled = false;
selSsyx.Enabled = true;
selSszy.Enabled = true;
btnAdd.Disabled = false;
btnChag.Disabled = true;
btnSave.Disabled = false;
btnCancel.Disabled = false;
}
