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