当前文件： ProjectManager/userControl/ucAddProject.ascx.cs[4K，2009-6-12 11:52:29]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using projmanager;
 12using System.Data.Common;
 13
 14public partial class userControl_ucAddProject : System.Web.UI.UserControl
 15...{
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (!IsPostBack)
 19        ...{
 20            bool flag1 = (bool)Session["IsDepartmentManager"];
 21            bool flag2 = (bool)Session["IsAdmin"];
 22            if (flag1 == false && flag2 == false)
 23            ...{
 24                Response.Redirect("login.aspx");
 25                return;
 26            }
 27            dataBindDDL();
 28            dataBindGridViewProject();
 29        }
 30    }
 31    protected void btnNewProj_Click(object sender, EventArgs e)
 32    ...{
 33        string projectname = this.tbNewProj.Text.Trim();
 34        int Departmentid = int.Parse(this.ddlDepartment.SelectedValue);
 35        string descript = this.tbDescription.Text.Trim();
 36        string predictfinishdate = this.tbPredictFinishDate.Text.Trim();
 37        string strNow = DateTime.Now.Date.ToShortDateString();
 38        string projmanagerid = this.ddlProjManager.SelectedValue;
 39        string projno = this.tbProjNo.Text;
 40        string sql = "insert into project(projectname,projectno,startdate,isactive,departmentid,predictfinishdate,description,projectmanagerid) values('" + projectname +
 41                     "','"  + projno  + "','"+ strNow + "',1," + Departmentid + ",'" + predictfinishdate + "','" + descript + "'," + projmanagerid +  
 42                     ");select @@identity as newprojID";
 43        try
 44        ...{
 45            Session.Add("TempNewProjID", DataAccess.ExecuteScalar(sql));
 46
 47            this.lbMsg.Text = "新建项目成功";
 48            dataBindGridViewProject();
 49        
 50
 51        }
 52        catch (Exception ee)
 53        ...{
 54            this.lbMsg.Text = "新建项目失败!" + ee.ToString();
 55        }
 56    }
 57
 58    private void dataBindGridViewProject()
 59    ...{
 60        string departmentid = ddlDepartment.SelectedValue;
 61        string sql = "select *" +
 62                     ",isnull((select employeename from employee e where e.employeeid = p.projectmanagerid),null)as projectmanagername" + 
 63                     " from project p where p.departmentid=" + departmentid;
 64        Utilities.BindingDataGridView(GridViewProject, DataAccess.ExecuteDataTable(sql), new string[] ...{ "projectid" });
 65    }
 66
 67    private void dataBindDDL()
 68    ...{
 69        DataTable dt = DataAccess.ExecuteDataTable("select * from department");
 70        Utilities.BindingDropDownList(ddlDepartment, dt, "departmentname", "departmentid");
 71
 72        string departmentid = Session["DepartmentID"].ToString();
 73        string sql = "select employeename,employeeid from employee e where e.departmentid=" + departmentid +
 74                     " and isadmin=0 and isdepartmentmanager=0";
 75        Utilities.BindingDropDownList(ddlProjManager, DataAccess.ExecuteDataTable(sql), "employeename", "employeeid");
 76                    
 77    }
 78
 79    /**//*
 80    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
 81    {
 82        int employeeid = int.Parse(e.CommandArgument.ToString());
 83        string projectid = Session["TempNewProjID"].ToString();
 84
 85        if (e.CommandName == "SetAsManager") //设为项目经理
 86        {
 87            //string sql1 = "update employee set statusid=(select statusid from status s where s.statusname ='项目经理') where employee.employeeid=" + employeeid;
 88            
 89            string sql2 = "update project set projectmanagerid=" + employeeid + " where projectid=" + projectid;
 90            try
 91            {
 92                //DataAccess.ExecuteNonQuery(sql1);
 93                DataAccess.ExecuteNonQuery(sql2);
 94                this.lbMsg.Text = "项目经理设置成功";
 95
 96                //((LinkButton)e.CommandSource).Enabled = false;
 97
 98                dataBindGridViewProject();
 99                
100            }
101            catch(Exception ee)
102            {
103                this.lbMsg.Text = "项目经理设置失败" + ee.ToString();
104            }
105        }
106        
107    }
108     */
109    protected void ddlDepartment_SelectedIndexChanged(object sender, EventArgs e)
110    ...{
111        dataBindGridViewProject();
112    }
113   
114   
115    protected void GridViewProject_PageIndexChanging(object sender, GridViewPageEventArgs e)
116    ...{
117        this.GridViewProject.PageIndex = e.NewPageIndex;
118        dataBindGridViewProject();
119    }
120}
121