当前文件： ProjectManager/userControl/ucViewGroupWeekly.ascx.cs[14K，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_ucViewGroupWeekly : System.Web.UI.UserControl
 14...{
 15    private static string bindstatus = "thisweek";
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (!IsPostBack)
 19        ...{
 20            string employeeid = Session["LoginEmployeeID"].ToString();
 21            string departmentid = Session["DepartmentID"].ToString();
 22            int groupid = Utilities.GetEmpGroupIDByGroupLeaderID(employeeid,departmentid);
 23            if (groupid == -1)
 24            ...{
 25                Response.Redirect("login.aspx");
 26                return;
 27            }
 28            bindThisWeek();
 29            bindDDL();
 30        }
 31    }
 32    private void bindDDL()
 33    ...{
 34        string sql = "select projectname,projectid from project where departmentid=" + Session["DepartmentID"].ToString();
 35        Utilities.BindingDropDownList(ddlProj, DataAccess.ExecuteDataTable(sql), "projectname", "projectid");
 36        ddlProj.Items.Insert(0, new ListItem("请选择项目", "-1"));
 37    }
 38
 39    private void bindData()
 40    ...{
 41        switch (bindstatus)
 42        ...{
 43            case "thisweek": bindThisWeek(); break;
 44            case "priorweek": bindPriorWeek(); break;
 45            case "search": bindSearch(); break;
 46            case "all": bindAll(); break;
 47        }
 48
 49    }
 50
 51    private void bindThisWeek()
 52    ...{
 53        string departmentid = Session["DepartmentID"].ToString();
 54        //最初显示本周周报
 55        int week = (int)DateTime.Now.DayOfWeek;
 56        int addeddays = 1 - week;
 57
 58        DateTime dt = DateTime.Now.AddDays(addeddays);
 59
 60        DateTime startDate = new DateTime(dt.Year, dt.Month, dt.Day);
 61        string employeeid = Session["LoginEmployeeID"].ToString();
 62        
 63        string groupid = Utilities.GetEmpGroupIDByGroupLeaderID(employeeid,departmentid).ToString();
 64        string sql = "select *" +
 65            ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
 66                     ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
 67                     ",isnull((select e.employeename  from employee e  where e.employeeid=(select groupleaderid from [group] g where g.groupid =(select groupid from employee_group eg where eg.employeeid=w.employeeid))),null)as groupleadername" +
 68                     ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
 69                     ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
 70                     " from weekly w" +
 71                     " where  (submitdate between '" + startDate + "' and  '" + DateTime.Now.ToString() + "')" +
 72                     " and (w.employeeid in(select employeeid from employee_group eg where eg.groupid=" + groupid + "))";
 73        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[] ...{ "weeklyid" });
 74
 75    }
 76
 77    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 78    ...{
 79        this.GridView1.EditIndex = -1;
 80       
 81        string weeklyid = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
 82        string remark_groupleader = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbRemark_GroupLeader")).Text;
 83        string score_groupleader = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbScore_GroupLeader")).Text;
 84
 85        
 86
 87        string sql = "update weekly set " +
 88                     " costtime_effect=costtime_effect*" + score_groupleader +
 89                     ",score_groupleader='" + score_groupleader + "'" +
 90                     ",remark_groupleader='" + remark_groupleader + "'" +
 91                     ",remarkdate_groupleader='" + DateTime.Now.ToString() + "'" + 
 92                     " where weeklyid=" + weeklyid;
 93
 94        if (DataAccess.ExecuteNonQuery(sql) == 1)
 95        ...{
 96            this.lbMsg.Text = "项目更新成功";
 97            bindData();
 98        }
 99        else
100        ...{
101            this.lbMsg.Text = "项目失败成功";
102        }
103    }
104    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
105    ...{
106        DateTime priorweek1;
107        DateTime p1 = DateTime.Now;
108
109        //检查时间，若不是上周或本周，则不可以修改。
110        int week = (int)DateTime.Now.DayOfWeek;
111        string employeeid = Session["LoginEmployeeID"].ToString();
112        priorweek1 = DateTime.Now.AddDays(-6 - week);
113        p1 = new DateTime(priorweek1.Year, priorweek1.Month, priorweek1.Day);
114        string weeklyid = this.GridView1.DataKeys[e.NewEditIndex].Value.ToString();
115        string sql1 = "select weeklyid from weekly where (weeklyid=" + weeklyid +
116                      ") and (submitdate between'" + p1.ToString() + "' and '" + DateTime.Now.ToString() +
117                      "')";
118
119        //没有找到上面的记录，则不是本周或上周的
120        if (DataAccess.ExecuteScalar(sql1)==null)
121        ...{
122            this.lbMsg.Text = "你只能修改本周和上周的周报";
123            this.GridView1.EditIndex = -1;
124            return;
125        }
126
127
128        this.GridView1.EditIndex = e.NewEditIndex;
129        bindData();
130
131        TextBox tb = (TextBox)this.GridView1.Rows[e.NewEditIndex].FindControl("tbScore_GroupLeader");
132        if (tb.Text == "")
133        ...{
134            tb.Text = "1";
135        }
136    }
137    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
138    ...{
139        this.GridView1.EditIndex = -1;
140        bindData();
141    }
142    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
143    ...{
144        this.GridView1.PageIndex = e.NewPageIndex;
145        bindData();
146    }
147    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
148    ...{
149
150    }
151    protected void btnViewPriorWeek_Click(object sender, EventArgs e)
152    ...{
153        bindstatus = "priorweek";
154        bindPriorWeek();
155    }
156
157    private void bindPriorWeek()
158    ...{
159        //最初显示上周周报
160        int week = (int)DateTime.Now.DayOfWeek;
161
162        DateTime dt1 = DateTime.Now.AddDays(-week - 6);
163        DateTime dt2 = DateTime.Now.AddDays(-week - 1);
164        string employeeid = Session["LoginEmployeeID"].ToString();
165        DateTime startDate = new DateTime(dt1.Year, dt1.Month, dt1.Day);
166        DateTime endDate = new DateTime(dt2.Year, dt2.Month, dt2.Day);
167        string departmentid = Session["DepartmentID"].ToString();
168        string groupid = Utilities.GetEmpGroupIDByGroupLeaderID(employeeid, departmentid).ToString();
169        string sql = "select *" +
170            ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
171                      ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
172                      ",isnull((select e.employeename  from employee e  where e.employeeid=(select groupleaderid from [group] g where g.groupid =(select groupid from employee_group eg where eg.employeeid=w.employeeid))),null)as groupleadername" +
173                      ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
174                      ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
175                      " from weekly w" +
176                      " where(submitdate between '" + startDate.ToString() + "' and  '" + endDate.ToString() + "')" +
177                      " and (w.employeeid in(select employeeid from employee_group eg where eg.groupid=" + groupid + "))";
178        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[] ...{ "weeklyid" });
179    }
180    protected void btnViewAll_Click(object sender, EventArgs e)
181    ...{
182        bindstatus = "all";
183        bindAll();
184    }
185
186    private void bindAll()
187    ...{
188        string departmentid = Session["DepartmentID"].ToString();
189        string employeeid = Session["LoginEmployeeID"].ToString();
190
191        string groupid = Utilities.GetEmpGroupIDByGroupLeaderID(employeeid, departmentid).ToString();
192        
193        string sql = "select *" +
194            ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
195                     ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
196                     ",isnull((select e.employeename  from employee e  where e.employeeid=(select groupleaderid from [group] g where g.groupid =(select groupid from employee_group eg where eg.employeeid=w.employeeid))),null)as groupleadername" +
197                     ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
198                     ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
199                     " from weekly w" +
200                     " where (w.employeeid in(select employeeid from employee_group eg where eg.groupid=" + groupid + "))";
201
202        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[] ...{ "weeklyid" });
203    }
204    protected void btnViewThisWeek_Click(object sender, EventArgs e)
205    ...{
206        bindstatus = "priorweek";
207        bindThisWeek();
208    }
209    protected void btnSearch_Click(object sender, EventArgs e)
210    ...{
211        bindstatus = "search";
212        bindSearch();
213
214    }
215
216    private void bindSearch()
217    ...{
218        string projectid = ddlProj.SelectedValue;
219        DateTime startDate = new DateTime(1900, 1, 1);
220        DateTime endDate = new DateTime(1900, 1, 1);
221        int week = (int)DateTime.Now.DayOfWeek;
222        string sql = "";
223        string employeeid = Session["LoginEmployeeID"].ToString();
224        string departmentid = Session["DepartmentID"].ToString();
225
226        string groupid = Utilities.GetEmpGroupIDByGroupLeaderID(employeeid, departmentid).ToString();
227        if (this.rrblWeek.SelectedValue == "-1")//上周
228        ...{
229            DateTime dt1 = DateTime.Now.AddDays(-week - 6);
230            DateTime dt2 = DateTime.Now.AddDays(-week - 1);
231            startDate = new DateTime(dt1.Year, dt1.Month, dt1.Day);
232            endDate = new DateTime(dt2.Year, dt2.Month, dt2.Day);
233
234            sql = "select *" +
235                ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
236                      ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
237                      ",isnull((select e.employeename  from employee e  where e.employeeid=(select groupleaderid from [group] g where g.groupid =(select groupid from employee_group eg where eg.employeeid=w.employeeid))),null)as groupleadername" +
238                      ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
239                      ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
240                      " from weekly w" +
241                      " where(submitdate between '" + startDate.ToString() + "' and  '" + endDate.ToString() + "')" +
242                      " and (w.employeeid in(select employeeid from employee_group eg where eg.groupid=" + groupid + "))";
243        }
244        else if (this.rrblWeek.SelectedValue == "0")
245        ...{
246            //显示本周周报
247
248            int addeddays = 1 - week;
249            DateTime dt = DateTime.Now.AddDays(addeddays);
250            startDate = new DateTime(dt.Year, dt.Month, dt.Day);
251            endDate = DateTime.Now;
252            sql = "select *" +
253                ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
254                      ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
255                      ",isnull((select e.employeename  from employee e  where e.employeeid=(select groupleaderid from [group] g where g.groupid =(select groupid from employee_group eg where eg.employeeid=w.employeeid))),null)as groupleadername" +
256                      ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
257                      ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
258                      " from weekly w" +
259                      " where(submitdate between '" + startDate.ToString() + "' and  '" + endDate.ToString() + "')" +
260                      " and (w.employeeid in(select employeeid from employee_group eg where eg.groupid=" + groupid + "))";
261        }
262        else//show all
263        ...{
264            sql = "select *" +
265                ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
266                     ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
267                     ",isnull((select e.employeename  from employee e  where e.employeeid=(select groupleaderid from [group] g where g.groupid =(select groupid from employee_group eg where eg.employeeid=w.employeeid))),null)as groupleadername" +
268                     ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
269                     ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
270                     " from weekly w" +
271                     " where (w.employeeid in(select employeeid from employee_group eg where eg.groupid=" + groupid + "))";
272
273        }
274        if (projectid != "-1")//查看组的
275        ...{
276            sql += " and (w.projectid =" + projectid + ")";
277        }
278
279        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[] ...{ "weeklyid" });
280    }
281}
282