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_ucViewProjectWeekly : 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
 23            bool flag1 = Utilities.CheckEmpIsProjectManager(employeeid, departmentid);
 24
 25            bool flag2 = (bool)Session["IsAdmin"];
 26            if (flag1 == false && flag2)
 27            ...{
 28                Response.Redirect("login.aspx");
 29                return;
 30            }
 31            bindThisWeek();
 32            bindDDL();
 33        }
 34    }
 35    private void bindDDL()
 36    ...{
 37        string sql = "select groupname,groupid from [group] where departmentid=" + Session["DepartmentID"].ToString();
 38        Utilities.BindingDropDownList(ddlGroup,DataAccess.ExecuteDataTable(sql), "groupname", "groupid");
 39        ddlGroup.Items.Insert(0, new ListItem("请选择小组", "-1"));
 40    }
 41
 42    private void bindData()
 43    ...{
 44        switch (bindstatus)
 45        ...{
 46            case "thisweek": bindThisWeek(); break;
 47            case "priorweek": bindPriorWeek(); break;
 48            case "search": bindSearch(); break;
 49            case "all": bindAll(); break;
 50            
 51        }
 52        
 53    }
 54
 55    private void bindThisWeek()
 56    ...{
 57        string departmentid = Session["DepartmentID"].ToString();
 58        //最初显示本周周报
 59        int week = (int)DateTime.Now.DayOfWeek;
 60        int addeddays = 1 - week;
 61
 62        DateTime dt = DateTime.Now.AddDays(addeddays);
 63
 64        DateTime startDate = new DateTime(dt.Year, dt.Month, dt.Day);
 65        string employeeid = Session["LoginEmployeeID"].ToString();
 66        string sql = "select *" +
 67            ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
 68                     ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
 69                     ",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" +
 70                     ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
 71                     ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
 72                     " from weekly w" +
 73                     " where  (submitdate between '" + startDate + "' and  '" + DateTime.Now.ToString() + "')" +
 74                     " and (w.projectid in(select projectid from project where projectmanagerid= " + employeeid + "))";
 75
 76        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[] ...{ "weeklyid" });
 77
 78    }
 79   
 80    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 81    ...{
 82        this.GridView1.EditIndex = -1;
 83        string scoreProjectManager = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbScoreProjectManager")).Text;
 84        string scoreGroupLeader = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbScoreGroupLeader")).Text;
 85
 86        string remarkProjectManager = ((TextBox)this.GridView1.Rows[e.RowIndex].FindControl("tbRemarkProjectManager")).Text;
 87
 88        string weeklyid = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
 89
 90        string sql = "update weekly set costtime_effect=costtime*" + scoreProjectManager + "*" + scoreGroupLeader +
 91                     //",remark_groupleader='" + remarkGroupLeader + "'" +
 92                     ",remark_projectmanager='" + remarkProjectManager + "'" +
 93                     ",score_groupleader='" + scoreGroupLeader + "'" +
 94                     ",score_projectmanager='" + scoreProjectManager + "'" +
 95                     ",remarkdate_projectmanager='" + DateTime.Now.ToString() + "'" + 
 96                     " where weeklyid=" + weeklyid;
 97                    
 98
 99        if (DataAccess.ExecuteNonQuery(sql) == 1)
100        ...{
101            this.lbMsg.Text = "项目更新成功";
102            bindData();
103        }
104        else
105        ...{
106            this.lbMsg.Text = "项目失败成功";
107        }
108    }
109    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
110    ...{
111        string weeklyid = this.GridView1.DataKeys[e.NewEditIndex].Value.ToString();
112        string employeeid = Session["LoginEmployeeID"].ToString();
113        if (Utilities.IsMyWeekly(weeklyid, employeeid) == true)//自己不能编辑自己的
114        ...{
115            this.lbMsg.Text = "不能自己给自己打分";
116            this.GridView1.EditIndex = -1;
117            return;
118        }
119
120        this.GridView1.EditIndex = e.NewEditIndex;
121        bindData();
122        
123
124        TextBox tb = (TextBox)this.GridView1.Rows[e.NewEditIndex].FindControl("tbScoreProjectManager");
125        if (tb.Text == "")
126        ...{
127            tb.Text = "1";
128        }
129        TextBox tb1 = (TextBox)this.GridView1.Rows[e.NewEditIndex].FindControl("tbScoreGroupLeader");
130        if (tb1.Text == "")
131        ...{
132            tb1.Text = "1";
133        }
134    }
135    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
136    ...{
137        this.GridView1.EditIndex = -1;
138        bindData();
139    }
140    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
141    ...{
142        this.GridView1.PageIndex = e.NewPageIndex;
143        bindData();
144    }
145    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
146    ...{
147        
148    }
149    protected void btnViewPriorWeek_Click(object sender, EventArgs e)
150    ...{
151        bindstatus = "priorweek";
152        bindPriorWeek();
153    }
154
155    private void bindPriorWeek()
156    ...{
157        //最初显示上周周报
158        int week = (int)DateTime.Now.DayOfWeek;
159
160        DateTime dt1 = DateTime.Now.AddDays(-week - 6);
161        DateTime dt2 = DateTime.Now.AddDays(-week - 1);
162        string employeeid = Session["LoginEmployeeID"].ToString();
163        DateTime startDate = new DateTime(dt1.Year, dt1.Month, dt1.Day);
164        DateTime endDate = new DateTime(dt2.Year, dt2.Month, dt2.Day);
165        string sql = "select *" +
166            ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
167                      ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
168                      ",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" +
169                      ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
170                      ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
171                      " from weekly w" +
172                      " where(submitdate between '" + startDate.ToString() + "' and  '" + endDate.ToString() + "')" +
173                      " and (w.projectid in(select projectid from project where projectmanagerid= " + employeeid + "))";
174        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[] ...{ "weeklyid" });
175    }
176    protected void btnViewAll_Click(object sender, EventArgs e)
177    ...{
178        bindstatus = "all";
179        bindAll();
180    }
181
182    private void bindAll()
183    ...{
184        string employeeid = Session["LoginEmployeeID"].ToString();
185        string sql = "select *" +
186            ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
187                     ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
188                     ",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" +
189                     ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
190                     ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
191                     " from weekly w" +
192                     " where (w.projectid in(select projectid from project where projectmanagerid= " + employeeid + "))";
193
194        Utilities.BindingDataGridView(this.GridView1, DataAccess.ExecuteDataTable(sql), new string[] ...{ "weeklyid" });
195    }
196    protected void btnViewThisWeek_Click(object sender, EventArgs e)
197    ...{
198        bindstatus = "priorweek";
199        bindThisWeek();
200    }
201    protected void btnSearch_Click(object sender, EventArgs e)
202    ...{
203        bindstatus = "search";
204        bindSearch();
205        
206    }
207
208    private void bindSearch()
209    ...{
210        string groupid = ddlGroup.SelectedValue;
211        DateTime startDate = new DateTime(1900, 1, 1);
212        DateTime endDate = new DateTime(1900, 1, 1);
213        int week = (int)DateTime.Now.DayOfWeek;
214        string sql = "";
215        string employeeid = Session["LoginEmployeeID"].ToString();
216        if (this.rrblWeek.SelectedValue == "-1")//上周
217        ...{
218            DateTime dt1 = DateTime.Now.AddDays(-week - 6);
219            DateTime dt2 = DateTime.Now.AddDays(-week - 1);
220            startDate = new DateTime(dt1.Year, dt1.Month, dt1.Day);
221            endDate = new DateTime(dt2.Year, dt2.Month, dt2.Day);
222            sql = "select *" +
223                ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
224                      ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
225                      ",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" +
226                      ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
227                      ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
228                      " from weekly w" +
229                      " where(submitdate between '" + startDate.ToString() + "' and  '" + endDate.ToString() + "')" +
230                      " and (w.projectid in(select projectid from project where projectmanagerid= " + employeeid + "))";
231        }
232        else if (this.rrblWeek.SelectedValue == "0")
233        ...{
234            //显示本周周报
235
236            int addeddays = 1 - week;
237            DateTime dt = DateTime.Now.AddDays(addeddays);
238            startDate = new DateTime(dt.Year, dt.Month, dt.Day);
239            endDate = DateTime.Now;
240            sql = "select *" +
241                ",isnull((select employeename from employee e where e.employeeid=w.employeeid),null)as employeename" +
242                      ",isnull((select employeename from employee e where e.employeeid=(select projectmanagerid from project p where p.projectid=w.projectid)),null)as projectmanagername" +
243                      ",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" +
244                      ",isnull((select g.groupname from [group] g where g.groupid=(select groupid from employee_group eg where eg.employeeid=w.employeeid)),null)as groupname" +
245                      ",isnull((select projectname from project p where p.projectid=w.projectid),null)as projectname" +
246                      " from weekly w" +
247                      " where(submitdate between '" + startDate.ToString() + "' and  '" + endDate.ToString() + "')" +
248                      " and (w.projectid in(select projectid from project where projectmanagerid= " + employeeid + "))";
249        }
250        else//show all
251        ...{
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                     "