Ejemplo n.º 1
0
    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();
            }
        }
    }
Ejemplo n.º 3
0
    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+'&amp;time={dwBeginTime}&amp;dwResvID={dwResvID}&amp;dwTestPlanID={dwTestPlanID}&amp;dwCourseID={dwCourseID}&amp;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();
            }
        }
    }
Ejemplo n.º 5
0
    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);
        }
    }