protected void Page_Load(object sender, EventArgs e) { TEACHINGRESVRECREQ vrParameter = new TEACHINGRESVRECREQ(); GetHTTPObj(out vrParameter); 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())); } } if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); TEACHINGRESVREC[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (m_Request.Report.GetTeachingResvRec(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td>" + vrResult[i].szCourseName + "</td>"; m_szOut += "<td>" + vrResult[i].szTeacherName + "</td>"; m_szOut += "<td>" + vrResult[i].szLabName + "</td>"; m_szOut += "<td>" + vrResult[i].szGroupName + "</td>"; m_szOut += "<td>" + vrResult[i].dwGroupUsers + "</td>"; m_szOut += "<td>" + vrResult[i].dwAttendUsers + "</td>"; m_szOut += "<td>" + GetTeachingTime((uint)vrResult[i].dwTeachingTime) + "</td>"; // m_szOut += "<td>" + vrResult[i].szTestName + "</td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { TEACHINGRESVRECREQ vrParameter = new TEACHINGRESVRECREQ(); GetHTTPObj(out vrParameter); vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]); vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]); TEACHINGRESVREC[] vrResult; // GetPageCtrlValue(out vrParameter.szReqExtInfo); System.IO.StringWriter swCSV = new System.IO.StringWriter(); swCSV.WriteLine("课程名,教师,房间,班级,应到人数,实到人数,上课时间"); if (m_Request.Report.GetTeachingResvRec(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { System.Text.StringBuilder sbText = new System.Text.StringBuilder(); sbText = AppendCSVFields(sbText, vrResult[i].szCourseName); sbText = AppendCSVFields(sbText, vrResult[i].szTeacherName); sbText = AppendCSVFields(sbText, vrResult[i].szLabName); sbText = AppendCSVFields(sbText, vrResult[i].szGroupName); sbText = AppendCSVFields(sbText, vrResult[i].dwGroupUsers.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwAttendUsers.ToString()); sbText = AppendCSVFields(sbText, GetTeachingTime((uint)vrResult[i].dwTeachingTime)); sbText = AppendCSVFields(sbText, GetTeachingTime((uint)vrResult[i].dwTeachingTime)); //去掉尾部的逗号 sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "teachplan.csv"); swCSV.Close(); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { TEACHINGRESVRECREQ vrParameter = new TEACHINGRESVRECREQ(); GetHTTPObj(out vrParameter); 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())); } } if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); TEACHINGRESVREC[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (m_Request.Report.GetTeachingResvRec(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; //href="javascript:ShowWin('chart.aspx?poist='+ID('dwTimePointRate').value+'&time={dwBeginTime}&dwResvID={dwResvID}&dwTestPlanID={dwTestPlanID}&dwCourseID={dwCourseID}&dwTeacherID={dwTeacherID}',660,550)">到课率</th> m_szOut += "<td dwResvID='" + vrResult[i].dwResvID + "' time='" + vrResult[i].dwBeginTime + "' dwTestPlanID='" + vrResult[i].dwTestPlanID + "' dwCourseID='" + vrResult[i].dwCourseID + "' dwTeacherID='" + vrResult[i].dwTeacherID + "' >" + vrResult[i].szCourseName + "</td>"; // m_szOut += "<td>" + vrResult[i].szTestName + "</td>"; m_szOut += "<td>" + vrResult[i].szTeacherName + "</td>"; m_szOut += "<td>" + vrResult[i].szLabName + "</td>"; m_szOut += "<td>" + vrResult[i].szGroupName + "</td>"; m_szOut += "<td>" + vrResult[i].dwGroupUsers + "</td>"; USERSPERMINUTE[] vtUserPerMinte = vrResult[i].UsersPerMinute; uint uTotal = (uint)vrResult[i].dwGroupUsers; bool bIs = false; string szFloatRate = ""; string szFTemMin = ""; string szLessTemPeople = ""; double fTotalHalf = uTotal * 0.5; if (vtUserPerMinte.Length > 10) { uint u = 0; uint.TryParse(vtUserPerMinte[9].dwUsers.ToString(), out u); vrResult[i].dwAttendUsers = u; if (uTotal == 0) { uTotal = 1; } if (u > uTotal) { szFTemMin = "100.0"; } else { szFTemMin = (((uint)(u) / (uTotal * 1.0)) * 100).ToString(".0"); } } bool bBigHalf = false; int nBigHalfMin = 0; for (int m = 0; m < vtUserPerMinte.Length; m++) { uint uTemp = 0; if ((vtUserPerMinte[m].dwUsers) != null) { uTemp = ((uint)vtUserPerMinte[m].dwUsers); } if (uTemp > fTotalHalf) { bBigHalf = true; } if (bBigHalf == true && ((uTemp) < fTotalHalf)) { nBigHalfMin = m; break; } } nBigHalfMin = vtUserPerMinte.Length - nBigHalfMin + 1;//计算结尾时间 int k = 0; bool bIsEnd = true; for (k = (vtUserPerMinte.Length - 1); k > 0; k--) { if (bIsEnd && vtUserPerMinte[k].dwUsers != null && ((uint)vtUserPerMinte[k].dwUsers < 10)) { } else { k = k + 1; bIsEnd = false; break; } } if (k == 0) { szLessTemPeople = "0"; } else { szLessTemPeople = (vtUserPerMinte.Length - k).ToString(); } vrResult[i].szCourseCode = ""; string szInfo = ""; if (!bIs) { szInfo = ("上课后10分钟到课率" + szFTemMin + "%;<br />下课前" + szLessTemPeople + "分钟人数少于10"); } m_szOut += "<td>下课前" + nBigHalfMin + "分钟</td>"; m_szOut += "<td>" + GetTeachingTime((uint)vrResult[i].dwTeachingTime) + "</td>"; m_szOut += "<td class='useRate'>" + (szFTemMin + "%") + "</td>";//daokelv // m_szOut += "<td>" + szInfo + "</td>"; // m_szOut += "<td>" + szLessTemPeople + "</td>";//zaotuiqingkuang m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { TEACHINGRESVRECREQ vrParameter = new TEACHINGRESVRECREQ(); GetHTTPObj(out vrParameter); vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]); vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]); TEACHINGRESVREC[] vrResult; // GetPageCtrlValue(out vrParameter.szReqExtInfo); System.IO.StringWriter swCSV = new System.IO.StringWriter(); swCSV.WriteLine("课程名,教师,房间,班级,应到人数,实到人数,上课时间"); if (m_Request.Report.GetTeachingResvRec(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { System.Text.StringBuilder sbText = new System.Text.StringBuilder(); sbText = AppendCSVFields(sbText, vrResult[i].szCourseName); sbText = AppendCSVFields(sbText, vrResult[i].szTeacherName); sbText = AppendCSVFields(sbText, vrResult[i].szLabName); sbText = AppendCSVFields(sbText, vrResult[i].szGroupName); sbText = AppendCSVFields(sbText, vrResult[i].dwGroupUsers.ToString()); USERSPERMINUTE[] vtUserPerMinte = vrResult[i].UsersPerMinute; uint uTotal = (uint)vrResult[i].dwGroupUsers; bool bIs = false; string szFloatRate = ""; string szFTemMin = ""; string szLessTemPeople = ""; if (vtUserPerMinte.Length > 10) { uint u = 0; uint.TryParse(vtUserPerMinte[9].dwUsers.ToString(), out u); vrResult[i].dwAttendUsers = u; if (uTotal == 0) { uTotal = 1; } szFTemMin = (((uint)(u) / (uTotal * 1.0)) * 100).ToString(".0"); } int k = 0; bool bIsEnd = true; for (k = (vtUserPerMinte.Length - 1); k > 0; k--) { if (bIsEnd && vtUserPerMinte[k].dwUsers != null && ((uint)vtUserPerMinte[k].dwUsers < 10)) { } else { k = k + 1; bIsEnd = false; break; } } if (k == 0) { szLessTemPeople = "0"; } else { szLessTemPeople = (vtUserPerMinte.Length - k).ToString(); } vrResult[i].szCourseCode = ""; string szInfo = ""; if (!bIs) { szInfo = ("上课后10分钟到课率" + szFTemMin + "%;<br />下课前" + szLessTemPeople + "分钟人数少于10"); } sbText = AppendCSVFields(sbText, vrResult[i].dwAttendUsers.ToString()); sbText = AppendCSVFields(sbText, GetTeachingTime((uint)vrResult[i].dwTeachingTime)); sbText = AppendCSVFields(sbText, GetTeachingTime((uint)vrResult[i].dwTeachingTime)); sbText = AppendCSVFields(sbText, (szFTemMin + "%")); //去掉尾部的逗号 sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "teachplan.csv"); swCSV.Close(); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { REQUESTCODE uResponse = REQUESTCODE.EXECUTE_FAIL; TEACHINGRESVRECREQ vrGet = new TEACHINGRESVRECREQ(); vrGet.dwCourseID = (uint.Parse(Request["dwCourseID"])); vrGet.dwTeacherID = (uint.Parse(Request["dwTeacherID"])); vrGet.dwTestPlanID = (uint.Parse(Request["dwTestPlanID"])); vrGet.dwStartDate = (uint.Parse(Get1970Date(int.Parse(Request["time"])))); vrGet.dwEndDate = (uint.Parse(Get1970Date(int.Parse(Request["time"])))); TEACHINGRESVREC[] vtRes; float fpoist = 0;// float.Parse(Request["poist"]); uResponse = m_Request.Report.GetTeachingResvRec(vrGet, out vtRes); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS && vtRes != null && vtRes.Length > 0) { for (int i = 0; i < vtRes.Length; i++) { if (vtRes[i].dwResvID.ToString() == Request["dwResvID"]) { USERSPERMINUTE[] vtUserPerMinte = vtRes[i].UsersPerMinute; uint uTotal = (uint)vtRes[i].dwGroupUsers; bool bIs = true; string szFloatRate = ""; int k = 0; for (k = 0; k < vtUserPerMinte.Length; k = k + 15) { uint uUser = 0; uint.TryParse(vtUserPerMinte[k].dwUsers.ToString(), out uUser); float fTemp = (((uint)uUser * (float)1.0) / uTotal) * 100; if (fTemp > 100) { fTemp = (float)100.0; } if (bIs && k > 10) { string szTemp = fTemp.ToString(".0"); uUser = 0; uint.TryParse(vtUserPerMinte[9].dwUsers.ToString(), out uUser); fTemp = (((uint)uUser * (float)1.0) / uTotal) * 100; szRate += "{ y:" + fTemp.ToString(".0") + ",marker:{symbol: 'url(sun.png)'}" + "},"; bIs = false; szRate += szTemp + ","; } else { szRate += fTemp.ToString(".0") + ","; } } int m = 0; bIs = true; for (m = 0; m < vtUserPerMinte.Length; m = m + 15) { if (bIs && m > 10) { szRateMin += "10,"; bIs = false; } szRateMin += (m).ToString() + ","; } break; } } } if (szRateMin.EndsWith(",")) { szRateMin = szRateMin.Substring(0, szRateMin.Length - 1); } if (szRate.EndsWith(",")) { szRate = szRate.Substring(0, szRate.Length - 1); } }