ucaddproject.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;
using System.Data.Common;

public partial class userControl_ucAddProject : 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;
            }
            dataBindDDL();
            dataBindGridViewProject();
        }
    }
    protected void btnNewProj_Click(object sender, EventArgs e)
    {
        string projectname = this.tbNewProj.Text.Trim();
        int Departmentid = int.Parse(this.ddlDepartment.SelectedValue);
        string descript = this.tbDescription.Text.Trim();
        string predictfinishdate = this.tbPredictFinishDate.Text.Trim();
        string strNow = DateTime.Now.Date.ToShortDateString();
        string projmanagerid = this.ddlProjManager.SelectedValue;
        string projno = this.tbProjNo.Text;
        string sql = "insert into project(projectname,projectno,startdate,isactive,departmentid,predictfinishdate,description,projectmanagerid) values('" + projectname +
                     "','"  + projno  + "','"+ strNow + "',1," + Departmentid + ",'" + predictfinishdate + "','" + descript + "'," + projmanagerid +  
                     ");select @@identity as newprojID";
        try
        {
            Session.Add("TempNewProjID", DataAccess.ExecuteScalar(sql));

            this.lbMsg.Text = "新建项目成功";
            dataBindGridViewProject();
        

        }
        catch (Exception ee)
        {
            this.lbMsg.Text = "新建项目失败!" + ee.ToString();
        }
    }

    private void dataBindGridViewProject()
    {
        string departmentid = ddlDepartment.SelectedValue;
        string sql = "select *" +
                     ",isnull((select employeename from employee e where e.employeeid = p.projectmanagerid),null)as projectmanagername" + 
                     " from project p where p.departmentid=" + departmentid;
        Utilities.BindingDataGridView(GridViewProject, DataAccess.ExecuteDataTable(sql), new string[] { "projectid" });
    }

    private void dataBindDDL()
    {
        DataTable dt = DataAccess.ExecuteDataTable("select * from department");
        Utilities.BindingDropDownList(ddlDepartment, dt, "departmentname", "departmentid");

        string departmentid = Session["DepartmentID"].ToString();
        string sql = "select employeename,employeeid from employee e where e.departmentid=" + departmentid +
                     " and isadmin=0 and isdepartmentmanager=0";
        Utilities.BindingDropDownList(ddlProjManager, DataAccess.ExecuteDataTable(sql), "employeename", "employeeid");
                    
    }

    /*
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        int employeeid = int.Parse(e.CommandArgument.ToString());
        string projectid = Session["TempNewProjID"].ToString();

        if (e.CommandName == "SetAsManager") //设为项目经理
        {
            //string sql1 = "update employee set statusid=(select statusid from status s where s.statusname ='项目经理') where employee.employeeid=" + employeeid;
            
            string sql2 = "update project set projectmanagerid=" + employeeid + " where projectid=" + projectid;
            try
            {
                //DataAccess.ExecuteNonQuery(sql1);
                DataAccess.ExecuteNonQuery(sql2);
                this.lbMsg.Text = "项目经理设置成功";

                //((LinkButton)e.CommandSource).Enabled = false;

                dataBindGridViewProject();
                
            }
            catch(Exception ee)
            {
                this.lbMsg.Text = "项目经理设置失败" + ee.ToString();
            }
        }
        
    }
     */
    protected void ddlDepartment_SelectedIndexChanged(object sender, EventArgs e)
    {
        dataBindGridViewProject();
    }
   
   
    protected void GridViewProject_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridViewProject.PageIndex = e.NewPageIndex;
        dataBindGridViewProject();
    }
}