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; } }
private List <unidev> ToRankDev(DEVSTAT[] list) { List <unidev> devs = new List <unidev>(); for (int i = 0; i < list.Length; i++) { DEVSTAT item = list[i]; unidev dev = new unidev(); dev.id = item.dwDevID.ToString(); dev.name = item.szDevName; dev.count = item.dwUseTimes.ToString(); dev.time = item.dwTotalUseTime.ToString(); devs.Add(dev); } return(devs); }
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; } }