/// <summary>
/// 页面初始化
/// </summary>
/// <param name="id">操作ID</param>
protected void PageInit()
{
string txtNum = Utils.GetQueryStringValue("txtNum");
string txtName = Utils.GetQueryStringValue("txtName");
string sectionID = Utils.GetQueryStringValue(this.SelectSection1.SelectIDClient);
string sectionName = Utils.GetQueryStringValue(this.SelectSection1.SelectNameClient);
this.SelectSection1.SectionName = sectionName;
this.SelectSection1.SectionID = sectionID;
BAttendance BLL = new BAttendance();
MSearchInfo Model = new MSearchInfo();
if (!string.IsNullOrEmpty(sectionID))
{
Model.DepartIds = sectionID;
}
Model.DepartName = sectionName;
Model.FileNumber = txtNum;
Model.Month = month;
Model.StaffName = txtName;
Model.Year = year;
IList <MGovAttendanceList> lst = BLL.GetList(this.SiteUserInfo.CompanyId, Model);
if (null != lst && lst.Count > 0)
{
this.RepList.DataSource = lst;
this.RepList.DataBind();
this.ExporPageInfoSelect2.intRecordCount = lst.Count;
}
}
/// <summary>
/// 导出
/// </summary>
void ToXls()
{
int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount();
if (toXlsRecordCount < 1)
{
ResponseToXls(string.Empty);
}
StringBuilder str = new StringBuilder();
string txtNum = Utils.GetQueryStringValue("txtNum");
string txtName = Utils.GetQueryStringValue("txtName");
string sectionID = Utils.GetQueryStringValue(this.SelectSection1.SelectIDClient);
string sectionName = Utils.GetQueryStringValue(this.SelectSection1.SelectNameClient);
BAttendance BLL = new BAttendance();
MSearchInfo Model = new MSearchInfo();
if (!string.IsNullOrEmpty(sectionID))
{
Model.DepartIds = sectionID;
}
Model.DepartName = sectionName;
Model.FileNumber = txtNum;
Model.Month = month;
Model.StaffName = txtName;
Model.Year = year;
IList <MGovAttendanceList> data = BLL.GetList(this.SiteUserInfo.CompanyId, Model);
//加载表头
str.AppendFormat("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/><table border='1' style='border-collapse:collapse;'><tr><th width='105'>员工编号" +
"</th><th width='105'>部门</th><th width='107'>姓名</th>");
//循环读取当前月的天数
int days = DateTime.DaysInMonth(year, month);
for (int i = 0; i < days; i++)
{
str.AppendFormat("<th>{0}</th>", i + 1);
}
str.AppendFormat("</tr>");
//查询出来的数据读取
if (data != null && data.Count > 0)
{
Dictionary <EyouSoft.Model.EnumType.GovStructure.AttendanceType, string> dic = new Dictionary <EyouSoft.Model.EnumType.GovStructure.AttendanceType, string>();
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.迟到, "<font color='#FF0000'><strong>迟</strong></font>");
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.出差, "<font color='#800080'><strong>差</strong></font>");
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.加班, "<font color='#0000FF'><strong>加</strong></font>");
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.旷工, "<font color='#6600CC'><strong>旷</strong></font>");
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.请假, "<font color='#FFA500'><strong>请</strong></font>");
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.全勤, "<font color='#A9A9A9'>准</font>");
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.停职, "<font color='#00BFFF'><strong>停</strong></font>");
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.休假, "<font color='#00FF00'><strong>休</strong></font>");
dic.Add(EyouSoft.Model.EnumType.GovStructure.AttendanceType.早退, "<font color='#008000'><strong>退</strong></font>");
for (int i = 0; i < data.Count; i++)
{
str.AppendFormat("<tr><td align='center' style='vnd.ms-excel.numberformat:@'>{0}</td><td align='center'>{1}</td><td align='center'>{2}</td>",
data[i].FileNumber, data[i].DepartName, data[i].Name);
for (int j = 0; j < days; j++)
{
DateTime dtCurrent = Convert.ToDateTime(String.Format("{0}-{1}-{2}", year, month, j + 1));
if (data[i].AttendanceList != null && data[i].AttendanceList.Count > 0)
{
IList <MGovAttendance> list = data[i].AttendanceList.Where(a => (a.AttendanceTime.Value.Date == dtCurrent)).ToList();
if (list != null && list.Count > 0)
{
str.AppendFormat("<td>{0}</td>", dic[list.First().AttendanceType]);
}
else
{
str.Append("<td></td>");
}
}
else
{
str.Append("<td></td>");
}
}
str.Append("</tr>");
}
}
str.AppendFormat("</table>");
string browser = this.Context.Request.UserAgent.ToUpper();
String fileName = "考勤汇总信息.xls";
if (browser.Contains("MS") && browser.Contains("IE"))
{
fileName = System.Web.HttpUtility.UrlEncode(fileName, Encoding.UTF8);
}
ResponseToXls(str.ToString(), Encoding.UTF8, fileName);
}