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();
}
