protected void Page_Load(object sender, EventArgs e)
{
CODINGTABLE[] vtCode = getCodeTableByType((uint)CODINGTABLE.DWCODETYPE.CODE_ACTIVITYKIND);
RESVKINDSTATREQ vrParameter = new RESVKINDSTATREQ();
vrParameter.dwPurpose = (uint)UNIRESERVE.DWPURPOSE.USEFOR_ACTIVITY;
RESVKINDSTAT[] vrResult;
GetPageCtrlValue(out vrParameter.szReqExtInfo);
if (!IsPostBack)
{
dwStartDate.Value = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
}
UNIDEPT[] alldept = GetAllDept();
szDept += GetInputItemHtml(CONSTHTML.option, "", "全部", "0");
if (alldept != null && alldept.Length > 0)
{
for (int i = 0; i < alldept.Length; i++)
{
szDept += GetInputItemHtml(CONSTHTML.option, "", alldept[i].szName, alldept[i].dwID.ToString());
}
}
UNITERM[] termList = GetAllTerm();
string szYearTerm = Request["dwYearTerm"];
uint uYeartermNow = Parse(szYearTerm);
if (termList != null)
{
m_TermList += GetInputItemHtml(CONSTHTML.option, "", "选择学期", "0");
for (int i = 0; i < termList.Length; i++)
{
m_TermList += GetInputItemHtml(CONSTHTML.option, "", termList[i].szMemo.ToString(), termList[i].dwYearTerm.ToString());
uint uYearTermState = (uint)termList[i].dwStatus;
if (szYearTerm == null && (uYearTermState & (uint)UNITERM.DWSTATUS.TERMSTAT_FORCE) > 0)
{
uYeartermNow = (uint)termList[i].dwYearTerm;
}
}
}
vrParameter.dwStartDate = DateToUint(dwStartDate.Value);
vrParameter.dwEndDate = DateToUint(dwEndDate.Value);
if (m_Request.Report.GetResvKindStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
{
UpdatePageCtrl(m_Request.Report);
for (int i = 0; i < vrResult.Length; i++)
{
m_szOut += "<tr>";
m_szOut += "<td data-id=" + vrResult[i].dwKind.ToString() + ">" + GetCode(vtCode, (uint)vrResult[i].dwKind) + "</td>";
m_szOut += "<td>" + vrResult[i].dwResvTimes.ToString() + "</td>"; //学院人数
m_szOut += "<td>" + vrResult[i].dwResvMinutes.ToString() + "</td>"; /*使用人数*/
m_szOut += "</tr>";
}
}
PutBackValue();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
{
RESVKINDSTATREQ vrParameter = new RESVKINDSTATREQ();
uint uKind = Parse(Request["Kind"]);
CODINGTABLE[] vtCode = null;
if (uKind == 1)
{
vtCode = getCodeTableByType((uint)CODINGTABLE.DWCODETYPE.CODE_RESVKIND);
vrParameter.dwPurpose = (uint)UNIRESERVE.DWPURPOSE.USEFOR_PERSONNAL + (uint)UNIRESERVE.DWPURPOSE.USEFOR_STUDYROOM;
}
else if (uKind == 2)
{
vtCode = getCodeTableByType((uint)CODINGTABLE.DWCODETYPE.CODE_ACTIVITYKIND);
vrParameter.dwPurpose = (uint)UNIRESERVE.DWPURPOSE.USEFOR_ACTIVITY;
}
vrParameter.szReqExtInfo.dwNeedLines = 1000000;
vrParameter.szReqExtInfo.dwStartLine = 0;
RESVKINDSTAT[] vrResult;
vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]);
vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]);
if (m_Request.Report.GetResvKindStat(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();
sbText = AppendCSVFields(sbText, GetCode(vtCode, (uint)vrResult[i].dwKind));
sbText = AppendCSVFields(sbText, vrResult[i].dwResvTimes.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].dwResvMinutes.ToString());
//去掉尾部的逗号
sbText.Remove(sbText.Length - 1, 1);
//写datatable的一行
swCSV.WriteLine(sbText.ToString());
}
DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv");
swCSV.Close();
Response.End();
}
}
}
}