当前文件： ProjectManager/userControl/ucAddGroup.ascx.cs[5K，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_ucAddGroup : 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            dataBindDepartment();
 27            dataBind();
 28        }
 29    }
 30    protected void btnAddGroup_Click(object sender, EventArgs e)
 31    ...{
 32        string groupleaderid = ddlGroupLeader.SelectedValue;
 33        string groupname = this.tbGroupName.Text;
 34        string description = this.tbDescription.Text;
 35        string departmentid = Session["DepartmentID"].ToString();
 36
 37        string sql = "insert into [group](groupname,departmentid,description,groupleaderid)values('" + groupname +
 38                     "'," + departmentid + ",'" + description + "'," + groupleaderid + ")";
 39        if (DataAccess.ExecuteNonQuery(sql) == 1)
 40        ...{
 41            lbMsg.Text = "小组添加成功";
 42            dataBind();
 43        }
 44        else
 45        ...{
 46            lbMsg.Text = "小组添加失败";
 47        }
 48    }
 49
 50    private void dataBindDepartment()
 51    ...{
 52        string departmentid = Session["DepartmentID"].ToString();
 53        string sql = "select employeename,employeeid from employee where departmentid=" + departmentid;
 54        Utilities.BindingDropDownList(ddlGroupLeader,DataAccess.ExecuteDataTable(sql),"employeename","employeeid");
 55
 56    }
 57    private void dataBind()
 58    ...{
 59        string departmentid = Session["DepartmentID"].ToString();
 60        string sql = "select groupid,groupname,groupleaderid,description" + 
 61                     ",isnull((select employeename from employee e where e.employeeid=g.groupleaderid),null)as groupleadername" + 
 62                     ",isnull((select departmentname from department where departmentid=" + departmentid + "),null)as departmentname" + 
 63                     " from [group] g";
 64        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[]...{"groupid"});
 65    }
 66
 67    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
 68    ...{
 69        this.GridView1.PageIndex = e.NewPageIndex;
 70        dataBind();
 71    }
 72    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
 73    ...{
 74        this.GridView1.EditIndex = -1;
 75        dataBind();
 76    }
 77    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 78    ...{
 79        this.GridView1.EditIndex = -1;
 80
 81        string groupid = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
 82
 83        DropDownList ddl = (DropDownList)this.GridView1.Rows[e.RowIndex].FindControl("ddlGroupLeaderEdit");
 84        
 85        string groupleaderid = ddl.SelectedValue;
 86        string description = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbDescriptionEdit")).Text;
 87        string groupname = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbGroupNameEdit")).Text;
 88
 89        string sql = "update [group] set description='" + description + "',groupname='" + groupname + "'," +
 90                     "groupleaderid=" + groupleaderid + " where groupid=" + groupid;
 91        if (DataAccess.ExecuteNonQuery(sql) == 1)
 92        ...{
 93            lbMsg.Text = "小组编辑成功";
 94            dataBind();
 95        }
 96        else
 97        ...{
 98            lbMsg.Text = "小组编辑失败";
 99        }
100       
101    }
102    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
103    ...{
104        this.GridView1.EditIndex = e.NewEditIndex;
105        dataBind();
106        DropDownList ddl = (DropDownList)this.GridView1.Rows[e.NewEditIndex].FindControl("ddlGroupLeaderEdit");
107        string sql = "select employeename,employeeid from employee where departmentid=" + Session["DepartmentID"].ToString();
108        Utilities.BindingDropDownList(ddl,DataAccess.ExecuteDataTable(sql),"employeename","employeeid");
109       
110    }
111    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
112    ...{
113        if (e.CommandName == "delete")
114        ...{
115            string groupid = e.CommandArgument.ToString();
116            string sql = "delete from [group] where groupid=" + groupid;
117            if (DataAccess.ExecuteNonQuery(sql) == 1)
118            ...{
119                lbMsg.Text = "小组删除成功";
120                dataBind();
121            }
122            else
123            ...{
124                lbMsg.Text = "小组删除失败";
125            }
126        }
127    }
128    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
129    ...{
130        /**//*string groupid = this.GridView1.DataKeys[e.RowIndex-1].Value.ToString();
131        string sql = "delete from [group] where groupid=" + groupid;
132        if (DataAccess.ExecuteNonQuery(sql) == 1)
133        {
134            lbMsg.Text = "小组删除成功";
135            dataBind();
136        }
137        else
138        {
139            lbMsg.Text = "小组删除失败";
140        }*/
141    }
142}
143