protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { } { UNIROOM[] roomList = GetAllRoom(); if (roomList != null && roomList.Length > 0) { for (int i = 0; i < roomList.Length; i++) { m_szRoom += "<input class=\"enum\" type=\"checkbox\" name=\"" + "roomID" + "\" value=\"" + roomList[i].dwRoomID.ToString() + "\" /> " + roomList[i].szRoomName + ","; } } } REQUESTCODE uResponse = REQUESTCODE.EXECUTE_FAIL; DOORCARDRECREQ vrGet = new DOORCARDRECREQ(); GetPageCtrlValue(out vrGet.szReqExtInfo); GetHTTPObj(out vrGet); vrGet.dwStartDate = GetDate(Request["dwStartDate"]); vrGet.dwEndDate = GetDate(Request["dwEndDate"]); vrGet.dwCardMode = ((uint)DOORCARDREQ.DWCARDMODE.DOORCARD_IN); // ViewState["dwStartDate"] = Request["dwStartDate"].Replace(",",""); ; // ViewState["dwEndDate"] = Request["dwEndDate"].Replace(",",""); //vrGet.dwAccNo = 0; DOORCARDREC[] vtRes; uResponse = m_Request.Report.GetDoorCardRec(vrGet, out vtRes); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS && vtRes != null && vtRes.Length > 0) { for (int i = 0; i < vtRes.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=\"" + vtRes[i].dwSID.ToString() + "\">" + vtRes[i].dwSID.ToString() + "</td>"; m_szOut += "<td>" + vtRes[i].szPID.ToString() + "</td>"; m_szOut += "<td>" + vtRes[i].szTrueName.ToString() + "</td>"; m_szOut += "<td>" + Get1970Date(vtRes[i].dwCardTime) + "</td>"; m_szOut += "<td>" + vtRes[i].szRoomName.ToString() + "</td>"; m_szOut += "<td>" + vtRes[i].szMemo.ToString() + "</td>"; m_szOut += "</tr>"; } } PutBackValue(); PutJSObj(vrGet); }
protected void Page_Load(object sender, EventArgs e) { uClassKind = Parse(Request["dwClassKind"]); szDevNameURL = GetJustNameEqual(uClassKind, "DevClass_dwKind", false); DOORCARDRECREQ vrParameter = new DOORCARDRECREQ(); if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } string szPID = Request["dwPID"]; if (szPID != null && szPID != "") { UNIACCOUNT accno; if (GetAccByLogonName(szPID, out accno)) { vrParameter.dwAccNo = accno.dwAccNo; } } string szKey = Request["szGetKey"]; if (szKey != null && szKey != "") { vrParameter.dwGetType = (uint)DOORCARDRECREQ.DWGETTYPE.DOORCARDRECGET_BYROOMID; vrParameter.szGetKey = (szKey); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); DOORCARDREC[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (vrParameter.szReqExtInfo.szOrderKey == null || vrParameter.szReqExtInfo.szOrderKey == "") { vrParameter.szReqExtInfo.szOrderKey = "dwCardTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; } if (m_Request.Report.GetDoorCardRec(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-time=\"" + Get1970Date((uint)vrResult[i].dwCardTime) + "\" data-roomno=\"" + vrResult[i].szRoomNo + "\">" + vrResult[i].dwSID.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].szTrueName + "(" + vrResult[i].szPID + ")" + "</td>"; m_szOut += "<td>" + vrResult[i].szDeptName + "</td>"; m_szOut += "<td>" + vrResult[i].szRoomName + "</td>"; m_szOut += "<td>" + Get1970Date((uint)vrResult[i].dwCardTime) + "</td>"; m_szOut += "<td>" + (vrResult[i].szMemo) + "</td>"; if (((uint)vrResult[i].dwManMode & (uint)UNIROOM.DWMANMODE.ROOMMAN_CAMERA) > 0) { m_szOut += "<td><div class='OPTD'></div></td>"; } else { m_szOut += "<td></td>"; } m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { DOORCARDRECREQ vrParameter = new DOORCARDRECREQ(); string szPID = Request["dwPID"]; if (szPID != null && szPID != "") { UNIACCOUNT accno; if (GetAccByLogonName(szPID, out accno)) { vrParameter.dwAccNo = accno.dwAccNo; } } string szKey = Request["szGetKey"]; if (szKey != null && szKey != "") { vrParameter.dwGetType = (uint)DOORCARDRECREQ.DWGETTYPE.DOORCARDRECGET_BYROOMID; vrParameter.szGetKey = (szKey); } vrParameter.dwStartTime = Get1970Seconds(Server.UrlDecode(Request["startdate"])); //DateToUint(Request["startdate"]); vrParameter.dwEndTime = Get1970Seconds(Server.UrlDecode(Request["enddate"])); //DateToUint(Request["enddate"]); vrParameter.dwCardMode = ((uint)DOORCARDREQ.DWCARDMODE.DOORCARD_IN); DOORCARDREC[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); vrParameter.szReqExtInfo.dwNeedLines = 100000; vrParameter.szReqExtInfo.dwStartLine = 0; if (vrParameter.szReqExtInfo.szOrderKey == null || vrParameter.szReqExtInfo.szOrderKey == "") { vrParameter.szReqExtInfo.szOrderKey = "dwCardTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; } if (m_Request.Report.GetDoorCardRec(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { 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(); string szValue = "\"" + ((char)(9)).ToString() + vrResult[i].dwSID.ToString() + "\""; sbText = AppendCSVFields(sbText, szValue); szValue = "\"" + ((char)(9)).ToString() + vrResult[i].szTrueName + "(" + vrResult[i].szPID + ")" + "\""; sbText = AppendCSVFields(sbText, szValue); szValue = "\"" + ((char)(9)).ToString() + vrResult[i].szDeptName.ToString() + "\""; sbText = AppendCSVFields(sbText, szValue); szValue = "\"" + ((char)(9)).ToString() + vrResult[i].szRoomName.ToString() + "\""; sbText = AppendCSVFields(sbText, szValue); szValue = "\"" + ((char)(9)).ToString() + Get1970Date((uint)vrResult[i].dwCardTime) + "\""; sbText = AppendCSVFields(sbText, szValue); szValue = "\"" + ((char)(9)).ToString() + vrResult[i].szMemo + "\""; sbText = AppendCSVFields(sbText, szValue); sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "ativityplan.csv"); swCSV.Close(); Response.End(); } } }