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