ucmanageproject.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;
//该源码下载自www.51aspx.com(５１aｓｐｘ．ｃｏｍ)

public partial class userControl_ucManageProject : 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;
            }
            dataBind();
        }
    }
    private void dataBind()
    {
        string departmentid = Session["DepartmentID"].ToString();
        string sql = "select *," +
                     " isnull((select employeename from [employee] e where e.employeeid=p.projectmanagerid),null)as projectmanagername" + 
                     " from project p where departmentid=" + departmentid;
        Utilities.BindingDataGridView(this.GridViewProject, DataAccess.ExecuteDataTable(sql), new string[] { "projectid" });
    }

    protected void GridViewProject_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {

    }
    protected void GridViewProject_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        this.GridViewProject.EditIndex = -1;
        DropDownList ddl = (DropDownList)this.GridViewProject.Rows[e.RowIndex].FindControl("ddlProjmanagerName");
        string projmanagerid = ddl.SelectedValue;
        string projname = ((TextBox)this.GridViewProject.Rows[e.RowIndex].FindControl("tbProjName")).Text;
        string projno = ((TextBox)this.GridViewProject.Rows[e.RowIndex].FindControl("tbProjNo")).Text;
      
        string preditFinishDate = ((TextBox)this.GridViewProject.Rows[e.RowIndex].FindControl("tbPreditFinishDate")).Text;
        string description = ((TextBox)this.GridViewProject.Rows[e.RowIndex].FindControl("tbDescription")).Text;
       
        string projectid = this.GridViewProject.DataKeys[e.RowIndex].Value.ToString();
        string sql = "update project set projectname='" + projname + "',projectno='" + projno + "'," +
                     " projectmanagerid=" + projmanagerid + ",predictfinishdate='" + preditFinishDate + "'," +
                     " description='" + description + "' where projectid=" + projectid;

        if (DataAccess.ExecuteNonQuery(sql) == 1)
        {
            this.lbMsg.Text = "项目更新成功";
            dataBind();
        }
        else
        {
            this.lbMsg.Text = "项目失败成功";
        }



    }
    protected void GridViewProject_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string projectid = this.GridViewProject.DataKeys[e.NewEditIndex].Value.ToString();

        string sql1 = "select isactive from project where projectid=" + projectid;
        bool flag = (bool)DataAccess.ExecuteScalar(sql1);
        if (flag==false)
        {
            this.lbMsg.Text = "项目处于非活动期，不能修改";
            this.GridViewProject.EditIndex = -1;
            return;
        }

        this.GridViewProject.EditIndex = e.NewEditIndex;
        dataBind();

        DropDownList ddl = (DropDownList)this.GridViewProject.Rows[e.NewEditIndex].FindControl("ddlProjmanagerName");
        string sql = "select employeename,employeeid from employee e where e.departmentid=" + Session["DepartmentID"].ToString();
       
        DataTable dt = DataAccess.ExecuteDataTable(sql);
        Utilities.BindingDropDownList(ddl, dt, "employeename", "employeeid");
    }
    protected void GridViewProject_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridViewProject.PageIndex = e.NewPageIndex;
        dataBind();
    }
    protected void GridViewProject_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridViewProject.EditIndex = -1;
        dataBind();
        
    }
    protected void GridViewProject_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "setunactive")
        {
            string projectid = e.CommandArgument.ToString();
            string sql = "update project set isactive=0 where projectid=" + projectid;
            if (DataAccess.ExecuteNonQuery(sql) == 1)
            {
                this.lbMsg.Text = "项目成功设置成非活动";
                dataBind();
            }
            else
            {
                this.lbMsg.Text = "项目设置失败";
            }
        }
        if (e.CommandName == "delete")
        {
            string projectid = e.CommandArgument.ToString();
            string sql = "delete from project where projectid=" + projectid;
            if (DataAccess.ExecuteNonQuery(sql) == 1)
            {
                this.lbMsg.Text = "项目删除成功";
                dataBind();
            }
            else
            {
                this.lbMsg.Text = "项目删除失败";
            }
        }
    }
    protected void GridViewProject_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string projectid = ((DataRowView)e.Row.DataItem).Row.ItemArray[0].ToString();
            string sql = "select isactive from project where projectid=" + projectid;
            bool flag = (bool)DataAccess.ExecuteScalar(sql);
            if (flag == false)
            {
                Button btn = (Button)e.Row.FindControl("btnSetUnActive");
                btn.Enabled = false;
                btn.Attributes.Remove("onclientclick");
            }
        }
    }
    protected void GridViewProject_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

    }
}