ucaddgroup.ascx.cs

简单项目管理系统源码 该源码为某公司的项目管理系统Demo版

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using projmanager;

public partial class userControl_ucAddGroup : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bool flag1 = (bool)Session["IsDepartmentManager"];
            bool flag2 = (bool)Session["IsAdmin"];
            if (flag1 == false && flag2 == false)
            {
                Response.Redirect("login.aspx");
                return;
            }
            dataBindDepartment();
            dataBind();
        }
    }
    protected void btnAddGroup_Click(object sender, EventArgs e)
    {
        string groupleaderid = ddlGroupLeader.SelectedValue;
        string groupname = this.tbGroupName.Text;
        string description = this.tbDescription.Text;
        string departmentid = Session["DepartmentID"].ToString();

        string sql = "insert into [group](groupname,departmentid,description,groupleaderid)values('" + groupname +
                     "'," + departmentid + ",'" + description + "'," + groupleaderid + ")";
        if (DataAccess.ExecuteNonQuery(sql) == 1)
        {
            lbMsg.Text = "小组添加成功";
            dataBind();
        }
        else
        {
            lbMsg.Text = "小组添加失败";
        }
    }

    private void dataBindDepartment()
    {
        string departmentid = Session["DepartmentID"].ToString();
        string sql = "select employeename,employeeid from employee where departmentid=" + departmentid;
        Utilities.BindingDropDownList(ddlGroupLeader,DataAccess.ExecuteDataTable(sql),"employeename","employeeid");

    }
    private void dataBind()
    {
        string departmentid = Session["DepartmentID"].ToString();
        string sql = "select groupid,groupname,groupleaderid,description" + 
                     ",isnull((select employeename from employee e where e.employeeid=g.groupleaderid),null)as groupleadername" + 
                     ",isnull((select departmentname from department where departmentid=" + departmentid + "),null)as departmentname" + 
                     " from [group] g";
        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[]{"groupid"});
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        dataBind();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        dataBind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        this.GridView1.EditIndex = -1;

        string groupid = this.GridView1.DataKeys[e.RowIndex].Value.ToString();

        DropDownList ddl = (DropDownList)this.GridView1.Rows[e.RowIndex].FindControl("ddlGroupLeaderEdit");
        
        string groupleaderid = ddl.SelectedValue;
        string description = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbDescriptionEdit")).Text;
        string groupname = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbGroupNameEdit")).Text;

        string sql = "update [group] set description='" + description + "',groupname='" + groupname + "'," +
                     "groupleaderid=" + groupleaderid + " where groupid=" + groupid;
        if (DataAccess.ExecuteNonQuery(sql) == 1)
        {
            lbMsg.Text = "小组编辑成功";
            dataBind();
        }
        else
        {
            lbMsg.Text = "小组编辑失败";
        }
       
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex = e.NewEditIndex;
        dataBind();
        DropDownList ddl = (DropDownList)this.GridView1.Rows[e.NewEditIndex].FindControl("ddlGroupLeaderEdit");
        string sql = "select employeename,employeeid from employee where departmentid=" + Session["DepartmentID"].ToString();
        Utilities.BindingDropDownList(ddl,DataAccess.ExecuteDataTable(sql),"employeename","employeeid");
       
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "delete")
        {
            string groupid = e.CommandArgument.ToString();
            string sql = "delete from [group] where groupid=" + groupid;
            if (DataAccess.ExecuteNonQuery(sql) == 1)
            {
                lbMsg.Text = "小组删除成功";
                dataBind();
            }
            else
            {
                lbMsg.Text = "小组删除失败";
            }
        }
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        /*string groupid = this.GridView1.DataKeys[e.RowIndex-1].Value.ToString();
        string sql = "delete from [group] where groupid=" + groupid;
        if (DataAccess.ExecuteNonQuery(sql) == 1)
        {
            lbMsg.Text = "小组删除成功";
            dataBind();
        }
        else
        {
            lbMsg.Text = "小组删除失败";
        }*/
    }
}