protected void Page_Load(object sender, EventArgs e) { REPORTREQ vrParameter = new REPORTREQ(); LABSTAT[] 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"); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); vrParameter.dwPurpose = ((uint)UNIRESERVE.DWPURPOSE.USEFOR_PERSONNAL + (uint)UNIRESERVE.DWPURPOSE.USEFOR_RESEACH + (uint)UNIRESERVE.DWPURPOSE.USEFOR_TEACHING); if (m_Request.Report.GetLabStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=" + vrResult[i].dwLabID.ToString() + ">" + vrResult[i].szLabSN + "</td>"; m_szOut += "<td>" + vrResult[i].szLabName + "</td>"; m_szOut += "<td>" + vrResult[i].dwPIDNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwTotalNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; uint uUseTime = (uint)vrResult[i].dwTotalUseTime; m_szOut += "<td>" + uUseTime / 60 + "小时" + uUseTime % 60 + "分钟" + "</td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { { REPORTREQ vrParameter = new REPORTREQ(); USERSTAT[] 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"); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); if (m_Request.Report.GetUserStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=" + vrResult[i].dwAccNo.ToString() + ">" + vrResult[i].szPID + "</td>"; m_szOut += "<td>" + vrResult[i].szTrueName + "</td>"; m_szOut += "<td>" + vrResult[i].szDeptName.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; uint uUseTime = (uint)vrResult[i].dwUseTime; m_szOut += "<td>" + uUseTime / 60 + "小时" + uUseTime % 60 + "分钟" + "</td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { REPORTREQ vrParameter = new REPORTREQ(); DEVCLASSSTAT[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } vrParameter.dwStartDate = GetDate(dwStartDate.Value); vrParameter.dwEndDate = GetDate(dwStartDate.Value); if (m_Request.Report.GetDevClassStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=" + vrResult[i].dwClassID.ToString() + ">" + vrResult[i].szClassName + "</td>"; m_szOut += "<td>" + vrResult[i].dwTotalNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwPIDNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwTotalUseTime.ToString() + "</td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { REPORTREQ vrParameter = new REPORTREQ(); DEVKINDSTAT[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (!IsPostBack) { dwStartDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } vrParameter.dwStartDate = GetDate(dwStartDate.Value); vrParameter.dwEndDate = GetDate(dwEndDate.Value); vrParameter.dwPurpose = ((uint)UNIRESERVE.DWPURPOSE.USEFOR_PERSONNAL + (uint)UNIRESERVE.DWPURPOSE.USEFOR_RESEACH + (uint)UNIRESERVE.DWPURPOSE.USEFOR_TEACHING); if (m_Request.Report.GetDevKindStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=" + vrResult[i].dwKindID.ToString() + ">" + vrResult[i].szKindName + "</td>"; m_szOut += "<td>" + vrResult[i].szModel + "/" + vrResult[i].szSpecification + "</td>"; m_szOut += "<td>" + vrResult[i].dwTotalNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwPIDNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; m_szOut += "<td>" + (vrResult[i].dwTotalUseTime / 60) + "小时</td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { { REPORTREQ vrParameter = new REPORTREQ(); USERSTAT[] vrResult; vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]); vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]); string szKey = Request["orderkey"]; if (szKey == null) { vrParameter.szReqExtInfo.szOrderKey = "dwUseTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; } else { vrParameter.szReqExtInfo.szOrderKey = szKey; vrParameter.szReqExtInfo.szOrderMode = "desc"; } if (m_Request.Report.GetUserStat(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 szClassName = ""; sbText = AppendCSVFields(sbText, vrResult[i].szPID.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].szTrueName.ToString()); UNIACCOUNT accinfo; if (GetAccByAccno(vrResult[i].dwAccNo.ToString(), out accinfo)) { szClassName = accinfo.szClassName.ToString(); } sbText = AppendCSVFields(sbText, szClassName.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].szDeptName.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwUseTimes.ToString()); uint uUseTime = (uint)vrResult[i].dwUseTime; sbText = AppendCSVFields(sbText, uUseTime / 60 + "小时" + uUseTime % 60 + "分钟"); //去掉尾部的逗号 sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv"); swCSV.Close(); Response.End(); } } } }
protected void Page_Load(object sender, EventArgs e) { UNILAB[] lab = GetAllLab(); szLab = GetInputItemHtml(CONSTHTML.option, "", "全部", "0"); for (int i = 0; i < lab.Length; i++) { szLab = szLab + GetInputItemHtml(CONSTHTML.option, "", lab[i].szLabName, lab[i].dwLabID.ToString()); } REPORTREQ vrParameter = new REPORTREQ(); ROOMSTAT[] 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"); } uint uLabid = Parse(Request["dwLabID"]); if (uLabid != 0) { vrParameter.dwGetType = (uint)REPORTREQ.DWGETTYPE.USERECGET_BYLABID; vrParameter.szGetKey = uLabid.ToString(); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); vrParameter.dwPurpose = ((uint)UNIRESERVE.DWPURPOSE.USEFOR_PERSONNAL + (uint)UNIRESERVE.DWPURPOSE.USEFOR_RESEACH + (uint)UNIRESERVE.DWPURPOSE.USEFOR_TEACHING); if (vrParameter.szReqExtInfo.szOrderKey == null) { vrParameter.szReqExtInfo.szOrderKey = "dwTotalUseTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; } if (m_Request.Report.GetRoomStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=" + vrResult[i].dwRoomID.ToString() + ">" + vrResult[i].szLabSN + "</td>"; m_szOut += "<td>" + vrResult[i].szLabName + "</td>"; m_szOut += "<td>" + vrResult[i].szRoomNo + "</td>"; m_szOut += "<td>" + vrResult[i].szRoomName + "</td>"; m_szOut += "<td>" + vrResult[i].dwTestUseTimes + "</td>"; m_szOut += "<td>" + vrResult[i].dwTotalNum.ToString() + "</td>"; m_szOut += "<td>" + (vrResult[i].dwTestUseTimes * vrResult[i].dwTotalTestHour).ToString() + "</td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
private void InitRank() { REQUESTCODE uResponse = REQUESTCODE.DBERR_FAILED; REPORTREQ vrGet = new REPORTREQ(); vrGet.dwGetType = (int)REPORTREQ.DWGETTYPE.USERECGET_BYALL; DateTime now = DateTime.Now; DateTime m1 = new DateTime(now.Year, now.Month, 1); DateTime m2 = m1.AddMonths(1).AddDays(-1); vrGet.dwStartDate = Convert.ToUInt32(m1.ToString("yyyyMMdd")); vrGet.dwEndDate = Convert.ToUInt32(m2.ToString("yyyyMMdd")); //vrGet.szReqExtInfo.dwNeedLines = needLines; //vrGet.szReqExtInfo.dwStartLine = 0; vrGet.szReqExtInfo.szOrderKey = "dwTotalUseTime"; vrGet.szReqExtInfo.szOrderMode = "DESC"; DEVSTAT[] vtResult; //获取月统计 uResponse = m_Request.Report.GetDevStat(vrGet, out vtResult); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS) { string list = ""; for (int i = 0; i < vtResult.Length && i < needLines; i++) { DEVSTAT item = vtResult[i]; list += i % 2 == 0 ? "<tr class='odd'>" : "<tr>"; list += "<td>" + CutStrT(item.szDevName, 10) + "</td><td>" + item.dwUseTimes + "</td><td>" + item.dwTotalUseTime + " 分钟</td></tr>"; } moonRank.InnerHtml = list; } //获取年统计 int y = (now.Year) * 10000 + 101; vrGet.dwStartDate = (uint)y; vrGet.dwEndDate = (uint)(y + 10000); uResponse = m_Request.Report.GetDevStat(vrGet, out vtResult); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS) { useList = vtResult; string list = ""; for (int i = 0; i < vtResult.Length && i < needLines; i++) { DEVSTAT item = vtResult[i]; list += i % 2 == 0 ? "<tr class='odd'>" : "<tr>"; list += "<td>" + CutStrT(item.szDevName, 10) + "</td><td>" + item.dwUseTimes + "</td><td>" + item.dwTotalUseTime + " 分钟</td></tr>"; } yearRank.InnerHtml = list; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { REPORTREQ vrParameter = new REPORTREQ(); DEVSTAT[] vrResult; string dwStartDate = Request["dwStartDate"]; string dwEndDate = Request["dwEndDate"]; vrParameter.dwStartDate = DateToUint(dwStartDate); vrParameter.dwEndDate = DateToUint(dwEndDate); if (m_Request.Report.GetDevStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { System.IO.StringWriter swCSV = new System.IO.StringWriter(); swCSV.WriteLine("名称," + ConfigConst.GCClassName + ",所属" + ConfigConst.GCLabName + ",使用总时间,使用人数,使用人次数"); for (int i = 0; i < vrResult.Length; i++) { System.Text.StringBuilder sbText = new System.Text.StringBuilder(); sbText = AppendCSVFields(sbText, vrResult[i].szDevName.ToString()); string szClsName = vrResult[i].szClassName; if (szClsName == null) { szClsName = ""; } sbText = AppendCSVFields(sbText, szClsName); sbText = AppendCSVFields(sbText, vrResult[i].szLabName.ToString()); uint uUseTime = (uint)vrResult[i].dwTotalUseTime; sbText = AppendCSVFields(sbText, uUseTime / 60 + "小时" + uUseTime % 60 + "分钟"); sbText = AppendCSVFields(sbText, vrResult[i].dwPIDNum.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwUseTimes.ToString()); sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv"); swCSV.Close(); Response.End(); } } }
private void InitRank() { REQUESTCODE uResponse = REQUESTCODE.DBERR_FAILED; REPORTREQ vrGet = new REPORTREQ(); vrGet.dwGetType = (int)REPORTREQ.DWGETTYPE.USERECGET_BYALL; //vrGet.dwPurpose = (int)UNIRESERVE.DWPURPOSE.USEFOR_RESEACH; DateTime now = DateTime.Now; DateTime m1 = new DateTime(now.Year, now.Month, 1); DateTime m2 = m1.AddMonths(1).AddDays(-1); vrGet.dwStartDate = Convert.ToUInt32(m1.ToString("yyyyMMdd")); vrGet.dwEndDate = Convert.ToUInt32(m2.ToString("yyyyMMdd")); vrGet.szReqExtInfo.dwNeedLines = 10; vrGet.szReqExtInfo.dwStartLine = 0; vrGet.szReqExtInfo.szOrderKey = "dwTotalUseTime"; vrGet.szReqExtInfo.szOrderMode = "DESC"; DEVSTAT[] vtResult; //获取月统计 uResponse = m_Request.Report.GetDevStat(vrGet, out vtResult); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS) { string list = ""; for (int i = 0; i < vtResult.Length; i++) { DEVSTAT item = vtResult[i]; list += "<tr class='" + (i % 2 == 0?"even":"odd") + "'><td style='text-align:left;padding-left:2px;'>" + ToNavDev(CutStrT(item.szDevName, 8), item.dwDevID) + "</td><td style='text-align:left;padding-left:2px;'>" + CutStrT(item.szDeptName, 8) + "</td><td>" + item.dwUseTimes + "</td><td>" + MinToHour(item.dwTotalUseTime) + "</td></tr>"; } moonRank.InnerHtml = list; } //获取年统计 int y = (now.Year) * 10000 + 101; vrGet.dwStartDate = (uint)y; vrGet.dwEndDate = (uint)(y + 10000); uResponse = m_Request.Report.GetDevStat(vrGet, out vtResult); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS) { string list = ""; for (int i = 0; i < vtResult.Length; i++) { DEVSTAT item = vtResult[i]; list += "<tr class='" + (i % 2 == 0 ? "even" : "odd") + "'><td style='text-align:left;padding-left:2px;'>" + ToNavDev(CutStrT(item.szDevName, 8), item.dwDevID) + "</td><td style='text-align:left;padding-left:2px;'>" + CutStrT(item.szDeptName, 8) + "</td><td>" + item.dwUseTimes + "</td><td>" + MinToHour(item.dwTotalUseTime) + "</td></tr>"; } yearRank.InnerHtml = list; } }
protected void Page_Load(object sender, EventArgs e) { REPORTREQ vrParameter = new REPORTREQ(); DEVSTAT[] 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"); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); if (vrParameter.szReqExtInfo.szOrderKey == null) { vrParameter.szReqExtInfo.szOrderKey = "dwTotalUseTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; } if (m_Request.Report.GetDevStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=" + vrResult[i].dwDevID.ToString() + ">" + vrResult[i].szDevName + "</td>"; string szClsName = vrResult[i].szClassName; if (szClsName == null) { szClsName = ""; } m_szOut += "<td>" + szClsName.ToString() + "</td>"; // m_szOut += "<td class='lnkTeacher' data-id='" + vrResult[i].dwAttendantID + "'>" + vrResult[i].szAttendantName + "</td>"; uint uUseTime = (uint)vrResult[i].dwTotalUseTime; m_szOut += "<td class='lnkLab' data-id='" + vrResult[i].dwLabID + "' title='查看实验室信息'>" + vrResult[i].szLabName + "</td>"; m_szOut += "<td>" + vrResult[i].szModel + "/" + vrResult[i].szSpecification + "</td>"; m_szOut += "<td>" + uUseTime / 60 + "小时" + uUseTime % 60 + "分钟" + "</td>"; m_szOut += "<td>" + vrResult[i].dwPIDNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { { REPORTREQ vrParameter = new REPORTREQ(); vrParameter.szReqExtInfo.dwNeedLines = 1000000; vrParameter.szReqExtInfo.dwStartLine = 0; DEPTSTAT[] vrResult; vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]); vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]); if (m_Request.Report.GetDeptStat(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].szDeptName.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwTotalUsers.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwPIDNum.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwUseTimes.ToString()); uint uUseTime = (uint)vrResult[i].dwTotalUseTime; sbText = AppendCSVFields(sbText, (uUseTime / 60 + "小时" + uUseTime % 60 + "分钟")); sbText = AppendCSVFields(sbText, ((uUseTime / ((uint)vrResult[i].dwTotalUsers + 1.0)).ToString(".00"))); //去掉尾部的逗号 sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv"); swCSV.Close(); Response.End(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { REPORTREQ vrParameter = new REPORTREQ(); DEVKINDSTAT[] vrResult; string dwStartDate = Request["dwStartDate"]; string dwEndDate = Request["dwEndDate"]; vrParameter.dwStartDate = DateToUint(dwStartDate); vrParameter.dwEndDate = DateToUint(dwEndDate); vrParameter.dwPurpose = ((uint)UNIRESERVE.DWPURPOSE.USEFOR_PERSONNAL + (uint)UNIRESERVE.DWPURPOSE.USEFOR_RESEACH + (uint)UNIRESERVE.DWPURPOSE.USEFOR_TEACHING); if (m_Request.Report.GetDevKindStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { System.IO.StringWriter swCSV = new System.IO.StringWriter(); swCSV.WriteLine(ConfigConst.GCKindName + "名称," + "个数,使用人数,使用人次数,使用总时间"); for (int i = 0; i < vrResult.Length; i++) { System.Text.StringBuilder sbText = new System.Text.StringBuilder(); sbText = AppendCSVFields(sbText, vrResult[i].szKindName.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwTotalNum.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwPIDNum.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwUseTimes.ToString()); sbText = AppendCSVFields(sbText, GetMinToStr(vrResult[i].dwTotalUseTime)); sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv"); swCSV.Close(); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // if (Request["type"] != null && Request["type"] == "export") { REPORTREQ vrParameter = new REPORTREQ(); USERSTAT[] vrResult; vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]); vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]); vrParameter.dwPurpose = (uint)UNIRESERVE.DWPURPOSE.USEFOR_RESEACH; if (m_Request.Report.GetUserStat(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].szPID.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].szTrueName.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].szDeptName.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].szDeptName.ToString()); uint uUseTime = (uint)vrResult[i].dwUseTime; sbText = AppendCSVFields(sbText, uUseTime / 60 + "小时" + uUseTime % 60 + "分钟"); //去掉尾部的逗号 sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv"); swCSV.Close(); Response.End(); } } } }
private List <unidev> GetRank(uint start, uint end, uint need) { REQUESTCODE uResponse = REQUESTCODE.DBERR_FAILED; REPORTREQ req = new REPORTREQ(); req.dwGetType = (int)REPORTREQ.DWGETTYPE.USERECGET_BYALL; req.szReqExtInfo.szOrderKey = "dwTotalUseTime"; req.szReqExtInfo.szOrderMode = "DESC"; req.dwStartDate = start; req.dwEndDate = end; if (need != 0) { req.szReqExtInfo.dwNeedLines = need; req.szReqExtInfo.dwStartLine = 0; } DEVSTAT[] rlt; uResponse = m_Request.Report.GetDevStat(req, out rlt); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS) { return(ToRankDev(rlt)); } return(null); }
protected void Page_Load(object sender, EventArgs e) { { REPORTREQ vrParameter = new REPORTREQ(); USERSTAT[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddDays(-5).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } 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 (ConfigConst.GCICTypeMode == 1) { UNITERM[] termnow = GetTermByID(Parse(Request["dwYearTerm"])); if (termnow != null && termnow.Length > 0) { vrParameter.dwStartDate = termnow[0].dwBeginDate; vrParameter.dwEndDate = termnow[0].dwEndDate; } else { vrParameter.dwStartDate = null; vrParameter.dwEndDate = null; } } string szKey = Request["orderkey"]; if (szKey == null) { vrParameter.szReqExtInfo.szOrderKey = "dwUseTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; } else { vrParameter.szReqExtInfo.szOrderKey = szKey; vrParameter.szReqExtInfo.szOrderMode = "desc"; } uint dwClassKind = Parse(Request["dwClassKind"]); if (dwClassKind != 0) { vrParameter.dwClassKind = dwClassKind; } if (m_Request.Report.GetUserStat(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].dwAccNo.ToString() + ">" + vrResult[i].szPID + "</td>"; m_szOut += "<td>" + vrResult[i].szTrueName + "</td>"; UNIACCOUNT accinfo; if (GetAccByAccno(vrResult[i].dwAccNo.ToString(), out accinfo)) { m_szOut += "<td>" + accinfo.szClassName.ToString() + "</td>"; } else { m_szOut += "<td></td>"; } m_szOut += "<td>" + vrResult[i].szDeptName.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; uint uUseTime = (uint)vrResult[i].dwUseTime; m_szOut += "<td>" + uUseTime / 60 + "小时" + uUseTime % 60 + "分钟" + "</td>"; m_szOut += "</tr>"; } } } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { { string szDevID = Request["devID"]; REPORTREQ vrParameter = new REPORTREQ(); DEPTSTAT[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } 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; } } } UNIDEVKIND[] devList = GetDevKindByKind((uint)UNIDEVCLS.DWKIND.CLSKIND_COMMONS); szDevList += GetInputItemHtml(CONSTHTML.option, "", "全部", "0"); for (int i = 0; i < devList.Length; i++) { szDevList += GetInputItemHtml(CONSTHTML.option, "", devList[i].szKindName, devList[i].dwKindID.ToString()); } if (szDevID != null && szDevID != "0") { //vrParameter.dwGetType = (uint)REPORTREQ.DWGETTYPE.USERECGET_BYDEVID; vrParameter.dwDevKind = Parse(szDevID); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); if (ConfigConst.GCICTypeMode == 1) { UNITERM[] termnow = GetTermByID(Parse(Request["dwYearTerm"])); if (termnow != null && termnow.Length > 0) { vrParameter.dwStartDate = termnow[0].dwBeginDate; vrParameter.dwEndDate = termnow[0].dwEndDate; } else { vrParameter.dwStartDate = null; vrParameter.dwEndDate = null; } } //vrParameter.dwDevKind = 1; if (m_Request.Report.GetDeptStat(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].dwDeptID.ToString() + ">" + vrResult[i].szDeptName + "</td>"; m_szOut += "<td>" + vrResult[i].dwTotalUsers.ToString() + "</td>"; //学院人数 m_szOut += "<td>" + vrResult[i].dwPIDNum.ToString() + "</td>"; /*使用人数*/ m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; /*使用人次*/ uint uUseTime = (uint)vrResult[i].dwTotalUseTime; m_szOut += "<td>" + uUseTime / 60 + "小时" + uUseTime % 60 + "分钟" + "</td>"; m_szOut += "<td>" + (uUseTime / ((uint)vrResult[i].dwTotalUsers + 1.0)).ToString(".00") + "</td>";/*使用人次*/ m_szOut += "</tr>"; } } } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { REPORTREQ vrParameter = new REPORTREQ(); DEVKINDSTAT[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } 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 (ConfigConst.GCICTypeMode == 1) { UNITERM[] termnow = GetTermByID(Parse(Request["dwYearTerm"])); if (termnow != null && termnow.Length > 0) { vrParameter.dwStartDate = termnow[0].dwBeginDate; vrParameter.dwEndDate = termnow[0].dwEndDate; } else { vrParameter.dwStartDate = null; vrParameter.dwEndDate = null; } } vrParameter.dwPurpose = ((uint)UNIRESERVE.DWPURPOSE.USEFOR_PERSONNAL + (uint)UNIRESERVE.DWPURPOSE.USEFOR_RESEACH + (uint)UNIRESERVE.DWPURPOSE.USEFOR_TEACHING); if (vrParameter.szReqExtInfo.szOrderKey == null || vrParameter.szReqExtInfo.szOrderKey == "") { vrParameter.szReqExtInfo.szOrderKey = "dwTotalUseTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; } if (m_Request.Report.GetDevKindStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td data-id=" + vrResult[i].dwKindID.ToString() + ">" + vrResult[i].szKindName + "</td>"; //m_szOut += "<td>" + vrResult[i].szModel + vrResult[i].szSpecification + "</td>"; m_szOut += "<td>" + vrResult[i].dwTotalNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwPIDNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; m_szOut += "<td>" + GetMinToStr1(vrResult[i].dwTotalUseTime) + "</td>"; double dPJ = (double)(vrResult[i].dwTotalUseTime / (vrResult[i].dwTotalNum * 1.0)); m_szOut += "<td>" + (dPJ).ToString(".00") + "</td>"; m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { YARDACTIVITYREQ activityReq = new YARDACTIVITYREQ(); YARDACTIVITY[] YardActivity; if (m_Request.Reserve.GetYardActivity(activityReq, out YardActivity) == REQUESTCODE.EXECUTE_SUCCESS && YardActivity != null & YardActivity.Length > 0) { m_YardActivity += GetInputItemHtml(CONSTHTML.option, "", "全部", "0"); for (int i = 0; i < YardActivity.Length; i++) { m_YardActivity += GetInputItemHtml(CONSTHTML.option, "", YardActivity[i].szActivityName, YardActivity[i].dwActivitySN.ToString()); } } REPORTREQ vrParameter = new REPORTREQ(); DEPTSTAT[] 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"); } 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 (ConfigConst.GCICTypeMode == 1) { UNITERM[] termnow = GetTermByID(Parse(Request["dwYearTerm"])); if (termnow != null && termnow.Length > 0) { vrParameter.dwStartDate = termnow[0].dwBeginDate; vrParameter.dwEndDate = termnow[0].dwEndDate; } else { vrParameter.dwStartDate = null; vrParameter.dwEndDate = null; } } uint uActibitySN = Parse(Request["dwActivitySN"]); if (uActibitySN != 0) { vrParameter.dwActivitySN = uActibitySN; } if (m_Request.Report.GetDeptStat(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].dwDeptID.ToString() + ">" + vrResult[i].szDeptName + "</td>"; // m_szOut += "<td>" + vrResult[i].dwTotalUsers.ToString() + "</td>";//学院人数 m_szOut += "<td>" + vrResult[i].dwPIDNum.ToString() + "</td>"; /*使用人数*/ m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; /*使用人次*/ uint uUseTime = (uint)vrResult[i].dwTotalUseTime; m_szOut += "<td>" + uUseTime / 60 + "小时" + uUseTime % 60 + "分钟" + "</td>"; m_szOut += "<td>" + (uUseTime / ((uint)vrResult[i].dwUseTimes + 0.1)).ToString(".00") + "</td>";/*使用人次*/ m_szOut += "</tr>"; } } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { UNIBUILDING[] vtBuilding = getAllBuilding(); szBuilding = GetInputItemHtml(CONSTHTML.option, "", "全部", "0"); if (vtBuilding != null) { for (int i = 0; i < vtBuilding.Length; i++) { szBuilding += GetInputItemHtml(CONSTHTML.option, "", vtBuilding[i].szBuildingName, vtBuilding[i].dwBuildingID.ToString()); } } UNICAMPUS[] vtCamp = GetAllCampus(); szCamp += GetInputItemHtml(CONSTHTML.option, "", "全部", "0"); for (int i = 0; i < vtCamp.Length; i++) { szCamp += GetInputItemHtml(CONSTHTML.option, "", vtCamp[i].szCampusName, vtCamp[i].dwCampusID.ToString()); } UNIROOM[] allRoom = GetRoomByClassKind((uint)UNIDEVCLS.DWKIND.CLSKIND_SEAT + (uint)UNIDEVCLS.DWKIND.CLSKIND_COMPUTER); if (allRoom != null) { sz_Room += GetInputItemHtml(CONSTHTML.option, "", "全部", "0"); for (int i = 0; i < allRoom.Length; i++) { if (i == 0) { sz_Room += GetInputItemHtml(CONSTHTML.option, "", allRoom[i].szRoomName, allRoom[i].dwRoomID.ToString(), true); } else { sz_Room += GetInputItemHtml(CONSTHTML.option, "", allRoom[i].szRoomName, allRoom[i].dwRoomID.ToString()); } } } UNIDEVKIND[] vtDevKind = GetAllDevKind(); if (vtDevKind != null && vtDevKind.Length > 0) { for (int i = 0; i < vtDevKind.Length; i++) { sz_Kind += GetInputItemHtml(CONSTHTML.option, "", vtDevKind[i].szKindName.ToString(), vtDevKind[i].dwKindID.ToString()); } } REPORTREQ vrParameter = new REPORTREQ(); GetHTTPObj(out vrParameter); DEVSTAT[] vrResult; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddDays(-3).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } 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 (ConfigConst.GCICTypeMode == 1) { UNITERM[] termnow = GetTermByID(Parse(Request["dwYearTerm"])); if (termnow != null && termnow.Length > 0) { // vrParameter.dwStartDate = termnow[0].dwBeginDate; // vrParameter.dwEndDate = termnow[0].dwEndDate; } } if (vrParameter.szReqExtInfo.szOrderKey == null || vrParameter.szReqExtInfo.szOrderKey == "") { vrParameter.szReqExtInfo.szOrderKey = "dwTotalUseTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; } if (vrParameter.dwClassKind == null || vrParameter.dwClassKind == 0) { vrParameter.dwClassKind = (uint)UNIDEVCLS.DWKIND.CLSKIND_COMMONS; } if (vrParameter.szBuildingIDs == null || vrParameter.szBuildingIDs == "0") { vrParameter.szBuildingIDs = null; } if (vrParameter.szCampusIDs == null || vrParameter.szCampusIDs == "0") { vrParameter.szCampusIDs = null; } string szroomid = Request["roomid"]; if (!string.IsNullOrEmpty(szroomid)) { vrParameter.szRoomIDs = szroomid; } if (m_Request.Report.GetDevStat(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].dwDevID.ToString() + ">" + vrResult[i].szDevName + "</td>"; string szClsName = vrResult[i].szClassName; if (szClsName == null) { szClsName = ""; } m_szOut += "<td>" + szClsName.ToString() + "</td>"; // m_szOut += "<td class='lnkTeacher' data-id='" + vrResult[i].dwAttendantID + "'>" + vrResult[i].szAttendantName + "</td>"; uint uUseTime = (uint)vrResult[i].dwTotalUseTime; m_szOut += "<td class='lnkLab' data-id='" + vrResult[i].dwLabID + "' title='查看实验室信息'>" + vrResult[i].szLabName + "</td>"; //m_szOut += "<td>" + vrResult[i].szModel+"/"+ vrResult[i].szSpecification + "</td>"; m_szOut += "<td>" + uUseTime / 60 + "小时" + uUseTime % 60 + "分钟" + "</td>"; m_szOut += "<td>" + vrResult[i].dwPIDNum.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwUseTimes.ToString() + "</td>"; m_szOut += "</tr>"; } } PutBackValue(); }
/// <summary> /// 获取设备使用统计排行榜 /// </summary> public void GetDevUseTotal() { LoginRes res = new LoginRes(); uint uSessionID = GusetLogin(); if (uSessionID == 0) { res.nStatus = (int)LoginRes.Status.ERROR; res.szError = m_Request.szErrMessage; Response.Write(JsonConvert.SerializeObject(res)); Response.End(); return; } m_Request.m_UniDCom.SessionID = uSessionID; REPORTREQ vrParameter = new REPORTREQ(); vrParameter.szReqExtInfo.szOrderKey = "dwTotalUseTime"; vrParameter.szReqExtInfo.szOrderMode = "desc"; string szClassKind = Request["classkind"]; uint uBeginDate = Parse(Request["begindate"]); uint uEndDate = Parse(Request["enddate"]); uint uDateMonthB = Parse(DateTime.Now.ToString("yyyyMM") + "01"); uint uDateMonthE = Parse(DateTime.Now.ToString("yyyyMM") + "31"); if (uBeginDate != 0) { vrParameter.dwStartDate = uBeginDate; } else { vrParameter.dwStartDate = uDateMonthB; } if (uEndDate != 0) { vrParameter.dwEndDate = uEndDate; } else { vrParameter.dwEndDate = uDateMonthE; } if (!string.IsNullOrEmpty(szClassKind)) { uint uClassKind = Parse(szClassKind); if (uClassKind == (uint)UNIDEVCLS.DWKIND.CLSKIND_COMMONS) { vrParameter.dwClassKind = (uint)UNIDEVCLS.DWKIND.CLSKIND_COMMONS; } else if (uClassKind == (uint)UNIDEVCLS.DWKIND.CLSKIND_SEAT) { vrParameter.dwClassKind = (uint)UNIDEVCLS.DWKIND.CLSKIND_SEAT; } else if (uClassKind == (uint)UNIDEVCLS.DWKIND.CLSKIND_COMPUTER) { vrParameter.dwClassKind = (uint)UNIDEVCLS.DWKIND.CLSKIND_COMPUTER; } } DEVSTAT[] vrResult; if (m_Request.Report.GetDevStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS) { res.nStatus = (int)LoginRes.Status.SUCCESS; res.total = vrResult.Length.ToString(); res.rows = vrResult; } else { res.nStatus = (int)LoginRes.Status.ERROR; res.szError = m_Request.szErrMessage; } Response.Write(JsonConvert.SerializeObject(res)); Response.End(); Logout(); return; }