protected void Page_Load(object sender, EventArgs e)
{
TESTITEMSTATREQ vrParameter = new TESTITEMSTATREQ();
TESTITEMSTAT[] vrResult;
UNITERM[] termList = GetAllTerm();
if (termList != null && termList.Length > 0)
{
szTerm += GetInputItemHtml(CONSTHTML.option, "", "未选择", "0");
for (int i = 0; i < termList.Length; i++)
{
szTerm += GetInputItemHtml(CONSTHTML.option, "", termList[i].szMemo, (termList[i].dwBeginDate.ToString() + termList[i].dwEndDate.ToString()));
}
}
GetHTTPObj(out vrParameter);
GetPageCtrlValue(out vrParameter.szReqExtInfo);
if (!IsPostBack)
{
dwStartDate.Value = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
}
vrParameter.dwStartDate = DateToUint(dwStartDate.Value);
vrParameter.dwEndDate = DateToUint(dwEndDate.Value);
if (vrParameter.szReqExtInfo.szOrderKey == null)
{
vrParameter.szReqExtInfo.szOrderKey = "dwTestItemID";
vrParameter.szReqExtInfo.szOrderMode = "desc";
}
if (m_Request.Report.GetTestItemStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
{
for (int i = 0; i < vrResult.Length; i++)
{
m_szOut += "<tr>";
m_szOut += "<td>" + vrResult[i].szCourseCode.ToString() + "</td>";
m_szOut += "<td>" + vrResult[i].szCourseName.ToString() + "</td>";
m_szOut += "<td>" + GetJustName(vrResult[i].dwCourseProperty, "Course_Property", false) + "</td>";
m_szOut += "<td data-id=" + vrResult[i].dwTestItemID.ToString() + ">" + vrResult[i].szTestName + "</td>";
m_szOut += "<td>" + vrResult[i].dwGroupPeopleNum.ToString() + "</td>";
m_szOut += "<td>" + vrResult[i].dwTestHour.ToString() + "</td>";
m_szOut += "<td>" + vrResult[i].szTeacherName.ToString() + "</td>";
m_szOut += "<td>" + vrResult[i].szGroupName.ToString() + "</td>";
m_szOut += "<td>" + vrResult[i].dwGroupUsers.ToString() + "</td>";
m_szOut += "<td>" + vrResult[i].szLabName.ToString() + "</td>";
m_szOut += "<td>" + vrResult[i].dwDevNum.ToString() + "</td>";
m_szOut += "</tr>";
}
UpdatePageCtrl(m_Request.Report);
}
PutBackValue();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
TESTITEMSTATREQ vrParameter = new TESTITEMSTATREQ();
TESTITEMSTAT[] vrResult;
GetPageCtrlValue(out vrParameter.szReqExtInfo);
GetHTTPObj(out vrParameter);
vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]);
vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]);
if (m_Request.Report.GetTestItemStat(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, vrResult[i].szCourseCode.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szCourseName.ToString());
sbText = AppendCSVFields(sbText, GetJustName(vrResult[i].dwCourseProperty, "Course_Property", false));
sbText = AppendCSVFields(sbText, vrResult[i].szTestName);
sbText = AppendCSVFields(sbText, vrResult[i].dwGroupPeopleNum.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].dwTestHour.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szTeacherName.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szGroupName.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].dwGroupUsers.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szLabName.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].dwDevNum.ToString());
sbText.Remove(sbText.Length - 1, 1);
//写datatable的一行
swCSV.WriteLine(sbText.ToString());
}
DownloadFile(Response, swCSV.GetStringBuilder(), "teachplan.csv");
swCSV.Close();
Response.End();
}
}
}
