protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { REQUESTCODE uResponse = REQUESTCODE.EXECUTE_FAIL; ATTENDRECREQ vrParameter = new ATTENDRECREQ(); GetHTTPObj(out vrParameter); if (vrParameter.dwStartDate == 0) { vrParameter.dwStartDate = null; } if (vrParameter.dwEndDate == 0) { vrParameter.dwEndDate = null; } // if(vrParameter.dwStartDate=) uint uAttend = Parse(Request["attendid"]); if (uAttend != 0) { vrParameter.dwAttendID = uAttend; } ATTENDREC[] vrResult; uResponse = m_Request.Attendance.GetAttendRec(vrParameter, out vrResult); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS && vrResult != null && vrResult.Length > 0) { System.IO.StringWriter swCSV = new System.IO.StringWriter(); swCSV.WriteLine("学工号,姓名,考勤规则,出勤日期,考勤房间,进入时间,退出时间,最近一次进入时间,停留时间(分钟),刷卡次数,状态"); for (int i = 0; i < vrResult.Length; i++) { System.Text.StringBuilder sbText = new System.Text.StringBuilder(); sbText = AppendCSVFields(sbText, vrResult[i].szPID); sbText = AppendCSVFields(sbText, vrResult[i].szTrueName); sbText = AppendCSVFields(sbText, vrResult[i].szAttendName.ToString()); sbText = AppendCSVFields(sbText, GetDateStr(vrResult[i].dwAttendDate)); sbText = AppendCSVFields(sbText, (vrResult[i].szRoomName)); sbText = AppendCSVFields(sbText, Get1970Date(vrResult[i].dwInTime)); sbText = AppendCSVFields(sbText, Get1970Date(vrResult[i].dwOutTime)); sbText = AppendCSVFields(sbText, Get1970Date(vrResult[i].dwLatestInTime)); sbText = AppendCSVFields(sbText, (vrResult[i].dwStayMin).ToString()); sbText = AppendCSVFields(sbText, (vrResult[i].dwCardTimes).ToString()); sbText = AppendCSVFields(sbText, GetJustName(vrResult[i].dwAttendStat, "attendstatus")); sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "attendrec.csv"); swCSV.Close(); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { ATTENDRECREQ vrParameter = new ATTENDRECREQ(); ATTENDREC[] vrResult; ATTENDRULEREQ attendreq = new ATTENDRULEREQ(); GetHTTPObj(out vrParameter); GetPageCtrlValue(out vrParameter.szReqExtInfo); if (vrParameter.dwStartDate == 0) { vrParameter.dwStartDate = null; } if (vrParameter.dwEndDate == 0) { vrParameter.dwEndDate = null; } // if(vrParameter.dwStartDate=) uint uAttend = Parse(Request["attendid"]); ATTENDRULE[] vtAttendRes; if (m_Request.Attendance.GetAttendRule(attendreq, out vtAttendRes) == REQUESTCODE.EXECUTE_SUCCESS && vtAttendRes != null && vtAttendRes.Length > 0) { szAttendRule += GetInputItemHtml(CONSTHTML.option, "", "全部", "0"); for (int i = 0; i < vtAttendRes.Length; i++) { szAttendRule += GetInputItemHtml(CONSTHTML.option, "", vtAttendRes[i].szAttendName, vtAttendRes[i].dwAttendID.ToString()); } if (uAttend != 0) { vrParameter.dwAttendID = vtAttendRes[0].dwAttendID; } } if (uAttend != 0) { vrParameter.dwAttendID = uAttend; } vrParameter.szReqExtInfo.dwNeedLines = 10; vrParameter.szReqExtInfo.dwStartLine = 0; if (m_Request.Attendance.GetAttendRec(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=" + vrResult[i].dwSID.ToString() + ">" + vrResult[i].szPID + "</td>"; m_szOut += "<td>" + (vrResult[i].szTrueName) + "</td>"; m_szOut += "<td >" + (vrResult[i].szAttendName) + "</td>"; m_szOut += "<td >" + GetDateStr(vrResult[i].dwAttendDate) + "</td>"; m_szOut += "<td >" + (vrResult[i].szRoomName) + "</td>"; m_szOut += "<td >" + Get1970Date(vrResult[i].dwInTime) + "</td>"; m_szOut += "<td >" + Get1970Date(vrResult[i].dwOutTime) + "</td>"; m_szOut += "<td >" + Get1970Date(vrResult[i].dwLatestInTime) + "</td>"; m_szOut += "<td >" + (vrResult[i].dwStayMin) + "</td>"; m_szOut += "<td >" + (vrResult[i].dwCardTimes) + "</td>"; m_szOut += "<td >" + GetJustName(vrResult[i].dwAttendStat, "attendstatus") + "</td>"; // m_szOut += "<td><div class='OPTD'></div></td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Attendance); } PutBackValue(); }