当前文件： ProjectManager/userControl/ucAddEmployee.ascx.cs[6K，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;
 12
 13public partial class userControl_ucAddEmployee : System.Web.UI.UserControl
 14...{
 15    protected void Page_Load(object sender, EventArgs e)
 16    ...{
 17        if (!IsPostBack)
 18        ...{
 19            bool flag1 = (bool)Session["IsDepartmentManager"];
 20            bool flag2 = (bool)Session["IsAdmin"];
 21            if (flag1 == false && flag2 == false)
 22            ...{
 23                Response.Redirect("login.aspx");
 24                return;
 25            }
 26        }
 27    }
 28    protected void btnAddEmployee_Click(object sender, EventArgs e)
 29    ...{
 30        //string statusid = ddlStatusName.SelectedValue;
 31        string departmentid = Session["DepartmentID"].ToString();
 32
 33        string employeename = this.tbEmployeeName.Text.Trim();
 34        string employeeno = this.tbEmployeeNO.Text.Trim();
 35        string isadmin = "0";
 36        string isdepartmentmanager = "0";
 37        if (this.cbIsDepartmentManager.Checked)
 38        ...{
 39            isdepartmentmanager = "1";
 40        }
 41        if (this.ckIsAdmin.Checked)
 42        ...{
 43            isadmin = "1";
 44        }
 45
 46        string sql = "insert into employee(employeename,employeeno,departmentid,employeeddate,isadmin,isdepartmentmanager)" +
 47                     "values('" + employeename + "','" + employeeno + "'," + departmentid +
 48                     ",'" + DateTime.Now.ToString() + "'," + isadmin + "," +  isdepartmentmanager +  ")";
 49        if (DataAccess.ExecuteNonQuery(sql) == 1)
 50        ...{
 51            this.lbMsg.Text = "添加成功";
 52            this.tbEmployeeName.Text = "";
 53            this.tbEmployeeNO.Text = "";
 54            if (GridViewAllEmployee.Visible)
 55            ...{
 56                dataBind();
 57            }
 58        }
 59        else
 60        ...{
 61            this.lbMsg.Text = "添加失败";
 62        }
 63    }
 64
 65
 66    protected void btnShowAllEmployee_Click(object sender, EventArgs e)
 67    ...{
 68        GridViewAllEmployee.Visible = true;
 69        dataBind();
 70    }
 71
 72    private void dataBind()
 73    ...{
 74        string sql = "select *" +
 75                     ",isnull((select departmentname from department d where d.departmentid = e.departmentid),null)as departmentname" +
 76                     ",isnull(dbo.getrole(e.employeeid),null)as role" + 
 77                     ",isnull((select groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=e.employeeid)),null) as groupname" + 
 78                     " from employee e where e.departmentid = " + Session["DepartmentID"].ToString() + 
 79                     " order by employeeddate desc";
 80        Utilities.BindingDataGridView(GridViewAllEmployee, DataAccess.ExecuteDataTable(sql), new string[] ...{ "employeeid" });
 81
 82    }
 83    protected void GridViewAllEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e)
 84    ...{
 85        this.GridViewAllEmployee.PageIndex = e.NewPageIndex;
 86        dataBind();
 87    }
 88    protected void GridViewAllEmployee_RowCommand(object sender, GridViewCommandEventArgs e)
 89    ...{
 90        if (e.CommandName == "delete")
 91        ...{
 92            string employeeid = e.CommandArgument.ToString();
 93            string sql = "delete from employee where employeeid=" + employeeid;
 94            if (DataAccess.ExecuteNonQuery(sql) == 1)
 95            ...{
 96                this.lbMsg.Text = "删除成功";
 97                dataBind();
 98            }
 99            else
100            ...{
101                lbMsg.Text = "删除失败";
102            }
103        }
104    }
105    protected void GridViewAllEmployee_RowDeleting(object sender, GridViewDeleteEventArgs e)
106    ...{
107
108    }
109    protected void GridViewAllEmployee_RowUpdating(object sender, GridViewUpdateEventArgs e)
110    ...{
111        DropDownList ddl = (DropDownList)this.GridViewAllEmployee.Rows[e.RowIndex].FindControl("ddlGroup");
112        string groupid = ddl.SelectedValue;
113        this.GridViewAllEmployee.EditIndex = -1;
114        if (groupid != "-1")
115        ...{
116            string employeeid = this.GridViewAllEmployee.DataKeys[e.RowIndex].Value.ToString();
117
118            string sql = "select employeegroupid from employee_group eg where employeeid=" + employeeid;
119            if (DataAccess.ExecuteScalar(sql) == null)
120            ...{
121                sql = "insert into employee_group values(" + employeeid + "," + groupid + ")";
122                if (DataAccess.ExecuteNonQuery(sql) == 1)
123                ...{
124                    this.lbMsg.Text = "成功添加成小组成员";
125                    dataBind();
126                }
127                else
128                ...{
129                    this.lbMsg.Text = "添加成小组成员失败";
130                }
131            }
132            else
133            ...{
134                sql = "update employee_group set groupid =" + groupid + " where employeeid=" + employeeid;
135                if (DataAccess.ExecuteNonQuery(sql) == 1)
136                ...{
137                    this.lbMsg.Text = "小组更新成功";
138                    dataBind();
139                }
140                else
141                ...{
142                    this.lbMsg.Text = "小组更新失败";
143                }
144            }
145        }
146    }
147    protected void GridViewAllEmployee_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
148    ...{
149        this.GridViewAllEmployee.EditIndex = -1;
150        dataBind();
151    }
152    protected void GridViewAllEmployee_RowEditing(object sender, GridViewEditEventArgs e)
153    ...{
154        this.GridViewAllEmployee.EditIndex = e.NewEditIndex;
155        dataBind();
156
157        DropDownList ddl = (DropDownList)this.GridViewAllEmployee.Rows[e.NewEditIndex].FindControl("ddlGroup");
158        string sql = "select groupname,groupid from [group] where departmentid=" + Session["DepartmentID"].ToString();
159        Utilities.BindingDropDownList(ddl, DataAccess.ExecuteDataTable(sql), "groupname", "groupid");
160        ddl.Items.Insert(0, new ListItem("请选择项目", "-1"));
161
162    }
163}
164