private void StatisHoliday() { #region 假期统计 double yearDay = 0; //年假 double swoppedDay = 0; //调休天数 double workDay = 0; //加班天数 double yearLeave = 0; HolidaysTO to = new HolidaysTO(); string orderBy = " UserName "; if (!string.IsNullOrEmpty(Request.Form["slectCode"])) { userCode = to.UserCode = Request.Form["slectCode"]; } DataTable dt = new HolidaysBLL().GetHolidaysStatisInfor(to, AspNetPager1.CurrentPageIndex, pageSize, orderBy, out rowCount); StringBuilder sb = new StringBuilder(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; yearDay = Convert.ToDouble(dr["AnnualLeave"]); //1年假 2 倒休 3加班 swoppedDay = Convert.ToDouble(dr["daoxiu"]); workDay = Convert.ToDouble(dr["jiaban"]); yearLeave = Convert.ToDouble(dr["nianjia"]); sb.Append("<tr>"); sb.AppendFormat("<td align='center'>{0}</td>", i + 1 * (pageSize * (pageIndex - 1) + 1)); sb.AppendFormat("<td align='center'>{0}</td>", dr["UserName"]); sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDouble(dr["AnnualLeave"])); sb.AppendFormat("<td align='center'>{0}</td>", workDay); sb.AppendFormat("<td align='center'>{0}</td>", swoppedDay * -1); sb.AppendFormat("<td align='center'>{0}</td>", yearLeave < 0 ? yearLeave * -1 : yearLeave); sb.AppendFormat("<td align='center'>{0}</td>", (yearDay + workDay + swoppedDay + yearLeave) < 0 ? 0 : yearDay + workDay + swoppedDay + yearLeave); } } holidayList = sb.ToString(); AspNetPager1.RecordCount = rowCount; AspNetPager1.PageSize = pageSize; #endregion }
/// <summary> /// 绑定数据源 /// </summary> private void BindHolidaysList() { HolidaysBLL BLL = new HolidaysBLL(); HolidaysTO to = new HolidaysTO(); int numPerPage = 10;//每页显示数量 string orderBy = " ID desc "; int rowCount = 0; #region 择条件 if (!string.IsNullOrEmpty(txtUserName.Text)) { to.UserName = txtUserName.Text; } if (!string.IsNullOrEmpty(HolidaysType.SelectedValue) && HolidaysType.SelectedValue != "请选择") { to.HolidaysType = PublicEnum.GetEnumDescriptionvalue <PublicEnum.HolidaysType>(HolidaysType.SelectedValue); } if (!string.IsNullOrEmpty(txtStartDate.Text)) { to.StratTime = txtStartDate.Text; } if (!string.IsNullOrEmpty(txtEndDate.Text)) { to.EndTime = txtEndDate.Text; } #endregion DataTable dt = BLL.GetHolidaysTableList(to, AspNetPager1.CurrentPageIndex, numPerPage, orderBy, out rowCount); if (dt != null && dt.Rows.Count > 0) { RepeaterHoliday.DataSource = dt; } else { RepeaterHoliday.DataSource = new DataTable(); } AspNetPager1.RecordCount = rowCount; AspNetPager1.PageSize = numPerPage; RepeaterHoliday.DataBind(); }