Exemple #1
0
    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnDel_Click(object sender, EventArgs e)
    {
        ArrayList selected = GetSelectedGV();

        if (selected.Count != 1)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请选择毕业设计任务!');</script>");
            return;
        }
        else
        {
            foreach (GridViewRow row in GV.Rows)
            {
                if (((CheckBox)row.FindControl("chkSelected")).Checked)
                {
                    BYSJ.Delete(row.Cells[1].Text, row.Cells[4].Text, row.Cells[7].Text, row.Cells[8].Text);
                }
            }
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功');</script>");
            Query();
        }
    }
Exemple #2
0
    /// <summary>
    /// 保存
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_ServerClick(object sender, EventArgs e)
    {
        if (btnAdd.Disabled == true)
        {
            Hashtable hash = new Hashtable();
            if (BYSJ.HasBYSJ(txtJsbh.Value, selBysjlx.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)));
            //    }
            //}
            hash.Add("jsbh", SqlStringConstructor.GetQuotedString(txtJsbh.Value));
            hash.Add("yxbh", SqlStringConstructor.GetQuotedString(selKbyx.Value));
            hash.Add("bysjlx", SqlStringConstructor.GetQuotedString(selBysjlx.Value));
            hash.Add("bysjzs", Convert.ToDouble(txtBysjzs.Value));
            hash.Add("cjrs", Convert.ToInt32(txtCjrs.Value));
            hash.Add("kbxn", SqlStringConstructor.GetQuotedString(txtKbxn.Value));
            hash.Add("kbxq", SqlStringConstructor.GetQuotedString(selKbxq.Value));


            Gzl.BusinessLogicLayer.BYSJ.Add(hash);

            txtCjrs.Value      = "";
            txtBysjzs.Value    = "";
            txtZdjs.Value      = "";
            txtJsbh.Value      = "";
            btnJssz.Disabled   = true;
            selKbyx.Disabled   = true;
            txtCjrs.Disabled   = true;
            selBysjlx.Disabled = true;
            txtBysjzs.Disabled = true;
            selKbxq.Disabled   = true;
            btnAdd.Disabled    = false;
            btnSave.Disabled   = true;
            btnCancel.Disabled = true;
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功');</script>");
            Query();
            //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)));
            //    }
            //}
            hash.Add("jsbh", SqlStringConstructor.GetQuotedString(txtJsbh.Value));
            hash.Add("yxbh", SqlStringConstructor.GetQuotedString(selKbyx.Value));
            hash.Add("bysjlx", SqlStringConstructor.GetQuotedString(selBysjlx.Value));
            hash.Add("bysjzs", Convert.ToDouble(txtBysjzs.Value));
            hash.Add("cjrs", Convert.ToInt32(txtCjrs.Value));
            hash.Add("kbxn", SqlStringConstructor.GetQuotedString(txtKbxn.Value));
            hash.Add("kbxq", SqlStringConstructor.GetQuotedString(selKbxq.Value));
            string where = "Where jsbh = " + SqlStringConstructor.GetQuotedString(Tjsbh.Value)
                           + " And bysjlx =" + SqlStringConstructor.GetQuotedString(Tbysjlx.Value) + " And kbxn = "
                           + SqlStringConstructor.GetQuotedString(Tkbxn.Value) + " And kbxq =" + SqlStringConstructor.GetQuotedString(Tkbxq.Value);
            Gzl.BusinessLogicLayer.BYSJ.Update(hash, where);
            txtCjrs.Value      = "";
            txtBysjzs.Value    = "";
            txtZdjs.Value      = "";
            txtJsbh.Value      = "";
            btnJssz.Disabled   = true;
            selKbyx.Disabled   = true;
            txtCjrs.Disabled   = true;
            selBysjlx.Disabled = true;
            txtBysjzs.Disabled = true;
            selKbxq.Disabled   = true;
            btnSave.Disabled   = true;
            btnCancel.Disabled = true;
            btnChag.Disabled   = false;
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功');</script>");
            Query();
            //QueryJS();
        }
    }
Exemple #3
0
    /// <summary>
    /// "修改"
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnChag_ServerClick(object sender, EventArgs e)
    {
        ArrayList selected = GetSelectedGV();
        BYSJ      bysj     = new BYSJ();

        if (selected.Count != 1)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请选择一个毕业设计任务!');</script>");
            return;
        }
        string jsbh   = "";
        string bysjlx = "";
        string kbxn   = "";
        string kbxq   = "";

        foreach (GridViewRow row in GV.Rows)
        {
            if (((CheckBox)row.FindControl("chkSelected")).Checked)
            {
                jsbh   = Convert.ToString(row.Cells[1].Text);
                bysjlx = Convert.ToString(row.Cells[4].Text);
                kbxn   = Convert.ToString(row.Cells[7].Text);
                kbxq   = Convert.ToString(row.Cells[8].Text);
            }
        }


        bysj.LoadData(jsbh, bysjlx, kbxn, kbxq);
        Tjsbh.Value   = bysj.Jsbh;
        Tbysjlx.Value = bysj.Bysjlx;
        Tkbxn.Value   = bysj.Kbxn;
        Tkbxq.Value   = bysj.Kbxq;
        txtZdjs.Value = bysj.Jsxm;
        //QueryJS2(bysj.Jsbh);
        //foreach (GridViewRow row in GVJS.Rows)
        //{
        //    ((CheckBox)row.FindControl("chkSelected")).Checked = true;
        //}
        txtJsbh.Value   = bysj.Jsbh;
        txtBysjzs.Value = Convert.ToString(bysj.Bysjzs);
        txtCjrs.Value   = Convert.ToString(bysj.Cjrs);
        txtKbxn.Value   = bysj.Kbxn;

        foreach (ListItem item in selKbyx.Items)
        {
            if (item.Selected == true)
            {
                item.Selected = false;
            }
            if (item.Text == bysj.Yxmc)
            {
                item.Selected = true;
            }
        }
        foreach (ListItem item in selBysjlx.Items)
        {
            if (item.Selected == true)
            {
                item.Selected = false;
            }
            if (item.Text == bysj.Bysjlx)
            {
                item.Selected = true;
            }
        }
        foreach (ListItem item in selKbxq.Items)
        {
            if (item.Selected == true)
            {
                item.Selected = false;
            }
            if (item.Text == bysj.Kbxq)
            {
                item.Selected = true;
            }
        }
        btnJssz.Disabled   = false;
        selKbyx.Disabled   = false;
        txtCjrs.Disabled   = false;
        selBysjlx.Disabled = false;
        txtBysjzs.Disabled = false;
        selKbxq.Disabled   = false;
        btnChag.Disabled   = true;
        btnAdd.Disabled    = false;
        btnSave.Disabled   = false;
        btnCancel.Disabled = false;
    }