ucaddemployee.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_ucAddEmployee : 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;
            }
        }
    }
    protected void btnAddEmployee_Click(object sender, EventArgs e)
    {
        //string statusid = ddlStatusName.SelectedValue;
        string departmentid = Session["DepartmentID"].ToString();

        string employeename = this.tbEmployeeName.Text.Trim();
        string employeeno = this.tbEmployeeNO.Text.Trim();
        string isadmin = "0";
        string isdepartmentmanager = "0";
        if (this.cbIsDepartmentManager.Checked)
        {
            isdepartmentmanager = "1";
        }
        if (this.ckIsAdmin.Checked)
        {
            isadmin = "1";
        }

        string sql = "insert into employee(employeename,employeeno,departmentid,employeeddate,isadmin,isdepartmentmanager)" +
                     "values('" + employeename + "','" + employeeno + "'," + departmentid +
                     ",'" + DateTime.Now.ToString() + "'," + isadmin + "," +  isdepartmentmanager +  ")";
        if (DataAccess.ExecuteNonQuery(sql) == 1)
        {
            this.lbMsg.Text = "添加成功";
            this.tbEmployeeName.Text = "";
            this.tbEmployeeNO.Text = "";
            if (GridViewAllEmployee.Visible)
            {
                dataBind();
            }
        }
        else
        {
            this.lbMsg.Text = "添加失败";
        }
    }


    protected void btnShowAllEmployee_Click(object sender, EventArgs e)
    {
        GridViewAllEmployee.Visible = true;
        dataBind();
    }

    private void dataBind()
    {
        string sql = "select *" +
                     ",isnull((select departmentname from department d where d.departmentid = e.departmentid),null)as departmentname" +
                     ",isnull(dbo.getrole(e.employeeid),null)as role" + 
                     ",isnull((select groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=e.employeeid)),null) as groupname" + 
                     " from employee e where e.departmentid = " + Session["DepartmentID"].ToString() + 
                     " order by employeeddate desc";
        Utilities.BindingDataGridView(GridViewAllEmployee, DataAccess.ExecuteDataTable(sql), new string[] { "employeeid" });

    }
    protected void GridViewAllEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridViewAllEmployee.PageIndex = e.NewPageIndex;
        dataBind();
    }
    protected void GridViewAllEmployee_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "delete")
        {
            string employeeid = e.CommandArgument.ToString();
            string sql = "delete from employee where employeeid=" + employeeid;
            if (DataAccess.ExecuteNonQuery(sql) == 1)
            {
                this.lbMsg.Text = "删除成功";
                dataBind();
            }
            else
            {
                lbMsg.Text = "删除失败";
            }
        }
    }
    protected void GridViewAllEmployee_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

    }
    protected void GridViewAllEmployee_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        DropDownList ddl = (DropDownList)this.GridViewAllEmployee.Rows[e.RowIndex].FindControl("ddlGroup");
        string groupid = ddl.SelectedValue;
        this.GridViewAllEmployee.EditIndex = -1;
        if (groupid != "-1")
        {
            string employeeid = this.GridViewAllEmployee.DataKeys[e.RowIndex].Value.ToString();

            string sql = "select employeegroupid from employee_group eg where employeeid=" + employeeid;
            if (DataAccess.ExecuteScalar(sql) == null)
            {
                sql = "insert into employee_group values(" + employeeid + "," + groupid + ")";
                if (DataAccess.ExecuteNonQuery(sql) == 1)
                {
                    this.lbMsg.Text = "成功添加成小组成员";
                    dataBind();
                }
                else
                {
                    this.lbMsg.Text = "添加成小组成员失败";
                }
            }
            else
            {
                sql = "update employee_group set groupid =" + groupid + " where employeeid=" + employeeid;
                if (DataAccess.ExecuteNonQuery(sql) == 1)
                {
                    this.lbMsg.Text = "小组更新成功";
                    dataBind();
                }
                else
                {
                    this.lbMsg.Text = "小组更新失败";
                }
            }
        }
    }
    protected void GridViewAllEmployee_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridViewAllEmployee.EditIndex = -1;
        dataBind();
    }
    protected void GridViewAllEmployee_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridViewAllEmployee.EditIndex = e.NewEditIndex;
        dataBind();

        DropDownList ddl = (DropDownList)this.GridViewAllEmployee.Rows[e.NewEditIndex].FindControl("ddlGroup");
        string sql = "select groupname,groupid from [group] where departmentid=" + Session["DepartmentID"].ToString();
        Utilities.BindingDropDownList(ddl, DataAccess.ExecuteDataTable(sql), "groupname", "groupid");
        ddl.Items.Insert(0, new ListItem("请选择项目", "-1"));

    }
}