Example #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        {
            IDENTSTATREQ vrParameter = new IDENTSTATREQ();
            IDENTSTAT[]  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 (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 uDept = Parse(Request["dwDept"]);
            if (uDept != 0)
            {
                vrParameter.dwDeptID = uDept;
            }
            if (m_Request.Report.GeIdentStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
            {
                UpdatePageCtrl(m_Request.Report);
                identTotal other = new identTotal();
                other.szName = "其他";
                other.uTotal = 0;
                ArrayList list = new ArrayList();
                for (int i = 0; i < vrResult.Length; i++)
                {
                    string szIdent = GetJustNameEqual(vrResult[i].dwIdent, "Ident", true);
                    if (szIdent == "")
                    {
                        other.uTotal = other.uTotal + (uint)vrResult[i].dwTotalUsers;
                        continue;
                    }
                    identTotal temp = new identTotal();
                    temp.szName = szIdent;
                    temp.uTotal = (uint)vrResult[i].dwTotalUsers;;
                    list.Add(temp);
                }
                list.Add(other);
                for (int i = 0; i < list.Count; i++)
                {
                    identTotal temp = new identTotal();
                    temp        = (identTotal)list[i];
                    szResvRate += "<p data-value=" + temp.uTotal.ToString() + ">" + temp.szName + "</p>";
                }
            }
        }

        PutBackValue();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
        {
            {
                IDENTSTATREQ vrParameter = new IDENTSTATREQ();
                vrParameter.szReqExtInfo.dwNeedLines = 1000000;
                vrParameter.szReqExtInfo.dwStartLine = 0;
                IDENTSTAT[] vrResult;
                vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]);
                vrParameter.dwEndDate   = DateToUint(Request["dwEndDate"]);

                if (m_Request.Report.GeIdentStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
                {
                    System.IO.StringWriter swCSV = new System.IO.StringWriter();
                    swCSV.WriteLine("名称,人数,使用人数,使用人次,使用总时间,平均在馆时间");
                    uint nOtherTotalUsers     = 0;
                    uint nOtherTotalPIDNum    = 0;
                    uint nOtherTotalUseTimes  = 0;
                    uint nOtherdwTotalUseTime = 0;
                    for (int i = 0; i < vrResult.Length; i++)
                    {
                        System.Text.StringBuilder sbText = new System.Text.StringBuilder();
                        string szIdent = GetJustNameEqual(vrResult[i].dwIdent, "Ident");
                        if (szIdent == "")
                        {
                            nOtherTotalUsers     = nOtherTotalUsers + (uint)vrResult[i].dwTotalUsers;
                            nOtherTotalPIDNum    = nOtherTotalPIDNum + (uint)vrResult[i].dwPIDNum;
                            nOtherTotalUseTimes  = nOtherTotalUseTimes + (uint)vrResult[i].dwUseTimes;
                            nOtherdwTotalUseTime = nOtherdwTotalUseTime + (uint)vrResult[i].dwTotalUseTime;
                            continue;
                        }

                        sbText = AppendCSVFields(sbText, szIdent.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());
                    }
                    System.Text.StringBuilder sbText1 = new System.Text.StringBuilder();

                    sbText1 = AppendCSVFields(sbText1, "其他");
                    sbText1 = AppendCSVFields(sbText1, nOtherTotalUsers.ToString());
                    sbText1 = AppendCSVFields(sbText1, nOtherTotalPIDNum.ToString());
                    sbText1 = AppendCSVFields(sbText1, nOtherTotalUseTimes.ToString());
                    sbText1 = AppendCSVFields(sbText1, nOtherdwTotalUseTime / 60 + "小时" + nOtherdwTotalUseTime % 60 + "分钟");
                    sbText1 = AppendCSVFields(sbText1, (nOtherdwTotalUseTime / (nOtherTotalUsers * 1.0)).ToString(".00"));


                    sbText1.Remove(sbText1.Length - 1, 1);

                    //写datatable的一行
                    swCSV.WriteLine(sbText1.ToString());

                    DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv");
                    swCSV.Close();
                    Response.End();
                }
            }
        }
    }
Example #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        {
            string       szDevID     = Request["devID"];
            IDENTSTATREQ vrParameter = new IDENTSTATREQ();
            IDENTSTAT[]  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");
            }
            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;
                    }
                }
            }
            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;
                }
            }
            uint uDept = Parse(Request["dwDept"]);
            if (uDept != 0)
            {
                vrParameter.dwDeptID = uDept;
            }
            if (m_Request.Report.GeIdentStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
            {
                UpdatePageCtrl(m_Request.Report);
                uint nOtherTotalUsers     = 0;
                uint nOtherTotalPIDNum    = 0;
                uint nOtherTotalUseTimes  = 0;
                uint nOtherdwTotalUseTime = 0;
                for (int i = 0; i < vrResult.Length; i++)
                {
                    string szIdent = GetJustNameEqual(vrResult[i].dwIdent, "Ident");
                    if (szIdent == "")
                    {
                        nOtherTotalUsers     = nOtherTotalUsers + (uint)vrResult[i].dwTotalUsers;
                        nOtherTotalPIDNum    = nOtherTotalPIDNum + (uint)vrResult[i].dwPIDNum;
                        nOtherTotalUseTimes  = nOtherTotalUseTimes + (uint)vrResult[i].dwUseTimes;
                        nOtherdwTotalUseTime = nOtherdwTotalUseTime + (uint)vrResult[i].dwTotalUseTime;
                        continue;
                    }
                    m_szOut += "<tr>";
                    m_szOut += "<td data-id=" + vrResult[i].dwIdent.ToString() + ">" + GetJustNameEqual(vrResult[i].dwIdent, "Ident", true) + "</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>";
                }
                if (nOtherTotalUsers > 0)
                {
                    m_szOut += "<tr>";
                    m_szOut += "<td>" + "其他" + "</td>";
                    m_szOut += "<td>" + nOtherTotalUsers.ToString() + "</td>";                                       //学院人数
                    m_szOut += "<td>" + nOtherTotalPIDNum.ToString() + "</td>";                                      /*使用人数*/
                    m_szOut += "<td>" + nOtherTotalUseTimes.ToString() + "</td>";                                    /*使用人次*/
                    m_szOut += "<td>" + nOtherdwTotalUseTime / 60 + "小时" + nOtherdwTotalUseTime % 60 + "分钟" + "</td>";
                    m_szOut += "<td>" + (nOtherdwTotalUseTime / (nOtherTotalUsers * 1.0)).ToString(".00") + "</td>"; /*使用人次*/
                    m_szOut += "</tr>";
                }
            }
        }

        PutBackValue();
    }
Example #4
0
    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());
            }
        }

        {
            IDENTSTATREQ vrParameter = new IDENTSTATREQ();
            IDENTSTAT[]  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 (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 uDept = Parse(Request["dwDept"]);
            if (uDept != 0)
            {
                vrParameter.dwDeptID = uDept;
            }
            uint uActibitySN = Parse(Request["dwActivitySN"]);
            if (uActibitySN != 0)
            {
                vrParameter.dwActivitySN = uActibitySN;
            }
            if (m_Request.Report.GeIdentStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
            {
                UpdatePageCtrl(m_Request.Report);
                uint nOtherTotalUsers     = 0;
                uint nOtherTotalPIDNum    = 0;
                uint nOtherTotalUseTimes  = 0;
                uint nOtherdwTotalUseTime = 0;
                for (int i = 0; i < vrResult.Length; i++)
                {
                    string szIdent = GetJustNameEqual(vrResult[i].dwIdent, "Ident");
                    if (szIdent == "")
                    {
                        nOtherTotalUsers     = nOtherTotalUsers + (uint)vrResult[i].dwTotalUsers;
                        nOtherTotalPIDNum    = nOtherTotalPIDNum + (uint)vrResult[i].dwPIDNum;
                        nOtherTotalUseTimes  = nOtherTotalUseTimes + (uint)vrResult[i].dwUseTimes;
                        nOtherdwTotalUseTime = nOtherdwTotalUseTime + (uint)vrResult[i].dwTotalUseTime;
                        continue;
                    }
                    m_szOut += "<tr>";
                    m_szOut += "<td data-id=" + vrResult[i].dwIdent.ToString() + ">" + GetJustNameEqual(vrResult[i].dwIdent, "Ident", true) + "</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>";
                }
                if (nOtherTotalUsers > 0)
                {
                    m_szOut += "<tr>";
                    m_szOut += "<td>" + "其他" + "</td>";
                    m_szOut += "<td>" + nOtherTotalUsers.ToString() + "</td>";                                       //学院人数
                    m_szOut += "<td>" + nOtherTotalPIDNum.ToString() + "</td>";                                      /*使用人数*/
                    m_szOut += "<td>" + nOtherTotalUseTimes.ToString() + "</td>";                                    /*使用人次*/
                    m_szOut += "<td>" + nOtherdwTotalUseTime / 60 + "小时" + nOtherdwTotalUseTime % 60 + "分钟" + "</td>";
                    m_szOut += "<td>" + (nOtherdwTotalUseTime / (nOtherTotalUsers * 1.0)).ToString(".00") + "</td>"; /*使用人次*/
                    m_szOut += "</tr>";
                }
            }
        }

        PutBackValue();
    }