Exemplo n.º 1
0
        public static string GetProvinceTableName(int ProvinceId, string strTable, string DataYear)
        {
            //    return GetProvinceTableName(strTable, ProvinceId, "");

            Entity.ProvinceConfig provinceConfig = DAL.ProvinceConfig.ProvinceConfigEntityGet(ProvinceId);
            if (provinceConfig != null && provinceConfig.OwnTable == 1)
            {
                if (DataYear == "All")
                {
                    strTable = strTable + "_" + GetProvincePinYin(ProvinceId) + "_All";
                }
                else
                {
                    strTable = strTable + "_" + GetProvincePinYin(ProvinceId);
                }
            }
            else
            {
                if (DataYear != "")
                {
                    strTable = strTable + "_All";
                }
            }
            return(strTable);
        }
Exemplo n.º 2
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";

            //基础html
            string strHtml = "";

            //获取传递过来的参数  并 拼接筛选条件
            string strWhere = GetFormStringANDCondition();

            StudentProvinceId = 11;
            int StudentId    = Basic.RequestHelper.GetFormInt("StudentId", 0);
            int StudentKeLei = Basic.RequestHelper.GetFormInt("StudentKeLei", 5);

            StudentPiCi = Basic.RequestHelper.GetFormInt("StudentPiCi", 1);
            int StudentPcLeiBie = Basic.RequestHelper.GetFormInt("StudentPcLeiBie", 0);
            int WeiCi           = Basic.RequestHelper.GetFormInt("weici", 0);
            int FenShu          = Basic.RequestHelper.GetFormInt("fenshu", 0);

            Entity.ProvinceConfig config = DAL.ProvinceConfig.ProvinceConfigEntityGet(StudentProvinceId);
            Entity.StudentGaoKaoHistory_ZheJiang history = DAL.StudentGaoKaoHistory_ZheJiang.StudentGaoKaoHistory_ZheJiangEntityGetByStudentId(StudentId);

            Entity.FenShuXian fenshuxian = DAL.FenShuXian.FenShuXianEntityGet(StudentProvinceId, " AND KeLei = " + StudentKeLei + "  AND DataYear = " + config.LatestProvinceWeiCiYear);
            int FirstPiCiWeiCi           = DAL.ProvinceWeiCi.ProvinceWeiCiEntityGetByFenShu(fenshuxian.PcFirst, config.LatestProvinceWeiCiYear, StudentProvinceId, StudentKeLei).WeiCi;
            // Entity.StudentChengJi studentChengJi = DAL.CommonTuiJian.GetUserPiCi(fenshuxian, FenShu, config.LatestProvinceWeiCiYear, StudentProvinceId, StudentKeLei);

            int XianCha = 0;

            if (StudentPiCi == 0)//浙江提前批的线差和一批次的线差一样
            {
                XianCha = DAL.CommonTuiJian.GetUserPiCiXianCha(fenshuxian, FenShu, 1);
            }
            else
            {
                XianCha = DAL.CommonTuiJian.GetUserPiCiXianCha(fenshuxian, FenShu, StudentPiCi);
            }

            DataTable dt = DAL.CommonTuiJian.FenShengYuanXiaoLuQuList(strWhere, StudentProvinceId, StudentId, StudentKeLei, StudentPiCi, StudentPcLeiBie, XianCha, 0, 0);

            //給DataTable
            dt.Columns.Add("BaoKaoTuiJian", typeof(int));
            foreach (DataRow dr in dt.Rows)
            {
                dr["BaoKaoTuiJian"] = DAL.CommonTuiJian.ShowSuggest(StudentProvinceId, StudentPiCi, FirstPiCiWeiCi, WeiCi, Basic.Utils.StrToInt(dr["glZuiXiaoWeiCi"].ToString(), 0), Basic.Utils.StrToInt(dr["glZuiDaWeiCi"].ToString(), 0), Basic.Utils.StrToInt(dr["glPingJunWeiCi"].ToString(), 0), XianCha, Basic.Utils.StrToInt(dr["PiCiXian"].ToString(), 0), Basic.Utils.StrToInt(dr["glZuiGaoFen"].ToString(), 0), Basic.Utils.StrToInt(dr["glZuiDiFen"].ToString(), 0), Basic.Utils.StrToInt(dr["glPingJunFen"].ToString(), 0));
            }

            DataView dv = dt.DefaultView;

            dv.Sort = "BaoKaoTuiJian ASC";

            DataTable dt2 = dv.ToTable();

            strHtml += GetBaseHtml();
            strHtml += GetSchoolHtml(dt2);//院校相关html
            context.Response.Write(strHtml);

            //ShowSuggestImg(int.Parse(Eval("glZuiXiaoWeiCi").ToString()), int.Parse(Eval("glZuiDaWeiCi").ToString()), int.Parse(Eval("glPingJunWeiCi").ToString()), int.Parse(Eval("PiCiXian").ToString()),  int.Parse(Eval("glZuiGaoFen").ToString()), int.Parse(Eval("glZuiDiFen").ToString()),int.Parse(Eval("glPingJunFen").ToString()))%>
        }
Exemplo n.º 3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (userinfo.ProvinceId == 11)
            {
                //浙江
                Server.Transfer("zhineng1_ZheJiang.aspx");
            }

            Entity.ProvinceConfig pConfig = DAL.ProvinceConfig.ProvinceConfigEntityGet(userinfo.ProvinceId);
            DataTable             dt      = DAL.ProvincePiCi.ProvincePiCiList(" ProvinceId = " + userinfo.ProvinceId + " AND LeiBie =  1  ORDER BY ShowOrder ASC,Id ASC ");

            rpt_PiCiList.DataSource = dt;
            rpt_PiCiList.DataBind();

            //
            DataTable dt2 = DAL.FenShuXian.FenShuXianList("DataYear,PcFirst,PcSecond,PcThird,ZkFirst,ZkSecond", " ProvinceId = " + userinfo.ProvinceId + " AND KeLei = " + userinfo.KeLei + " Order by DataYear DESC;");

            DataView dv1 = dt2.DefaultView;

            dv1.Sort = "DataYear Asc";
            DataTable dt3 = dv1.ToTable();

            //給DataTable
            dt3.Columns.Add("StudentFenShu", typeof(int));
            foreach (DataRow dr in dt3.Rows)
            {
                dr["StudentFenShu"] = studentChengJi.FenShu;
            }

            //userinfo.ProvinceName + userinfo.KeLeiMingCheng + "历年省控线对比图"

            //浙江必须要显示为文理科一批,文理科二批
            if (userinfo.ProvinceId == 11)
            {
                DataView dvZJ = dt3.DefaultView;
                dvZJ.Sort = "DataYear ASC";
                DataTable dtZJ = dvZJ.ToTable(true, new string[] { "DataYear", "PcFirst", "PcSecond", "ZkFirst", "StudentFenShu" });
                strHighCharts = Basic.HighCharts.CreatHighChartsFromDT("duibitu1", "spline", "", "分数", "文理科一批|文理科二批|文理科三批|学生成绩", dtZJ);
            }
            else
            {
                strHighCharts = Basic.HighCharts.CreatHighChartsFromDT("duibitu1", "spline", "", "分数", "一本线|二本线|三本线|一专线|二专线|学生成绩", dt3);
            }


            DataTable dt4 = DAL.ProvinceWeiCi.ProvinceWeiCiGetByFenShuList(studentChengJi.FenShu, userinfo.ProvinceId, userinfo.KeLei);
            DataView  dv2 = dt4.DefaultView;

            dv2.Sort = "DataYear ASC";
            DataTable dt5 = dv2.ToTable(true, new string[] { "DataYear", "WeiCi", "LeiJiRenShu" });

            strHighCharts += Basic.HighCharts.CreatHighChartsFromDT("duibitu2", "column", "", "人", "|位次|累计人数", dt5);

            lit_Suggesiton.Text = ShowTiShiXinXi(studentChengJi.PiCi);
        }
Exemplo n.º 4
0
        void page_Loading(object sender, EventArgs e)
        {
            userinfo.StudentId    = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "StudentId"), 0);
            userinfo.StudentLevel = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "StudentLevel"), 0); //用户等级id:1普通注册用户;2高考查看卡; 3普通测试卡; 4普通卡;  5VIP测试卡;  6VIP卡;9会员卡
            userinfo.ProvinceId   = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "ProvinceId"), 0);   //省份id
            userinfo.KeLei        = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "KeLei"), 0);        //科类

            userinfo.GKYear       = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "GKYear"), 0);       //参加高考的年份
            userinfo.Status       = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "Status"), 0);       //登陆之后的状态值
            userinfo.StudentName  = Basic.CookieHelper.GetCookie("Student", "StudentName");                           //学生姓名
            userinfo.Bank         = Basic.CookieHelper.GetCookie("Student", "Bank");                                  //当前登陆的账号
            userinfo.LevelName    = Basic.CookieHelper.GetCookie("Student", "LevelName");                             //用户等级名称: 1普通注册用户;2高考查看卡; 3普通测试卡; 4普通卡;  5VIP测试卡;  6VIP卡;9会员卡
            userinfo.ProvinceName = Basic.CookieHelper.GetCookie("Student", "ProvinceName");                          //省份名称


            #region 新疆乌鲁木齐咨询中心的卡不能在喀什地区使用

            if (userinfo.ProvinceId == 72)//新疆乌鲁木齐咨询中心
            {
                Entity.AreaJson infoAreaJson = DAL.AnalysisArea.GetAreaModel();
                if (infoAreaJson != null)
                {
                    if (infoAreaJson.code == "0")
                    {
                        if (infoAreaJson.data.city_id == "653100")
                        {
                            //新疆乌鲁木齐咨询中心的卡不能在喀什地区使用
                            Basic.MsgHelper.AlertUrlMsg("该卡不能在喀什地区使用", "/logout.aspx");
                        }
                    }
                }
            }
            #endregion


            userinfo.KeLeiMingCheng = DAL.Common.GetKeLeiMingCheng(userinfo.KeLei); //科类名称


            provinceConfig = DAL.ProvinceConfig.ProvinceConfigEntityGet(userinfo.ProvinceId);

            //userinfo.StudentId = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "StudentId"), 5);
            //userinfo.StudentLevel = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "StudentLevel"), 4);//用户等级id:1普通注册用户;2高考查看卡; 3普通测试卡; 4普通卡;  5VIP测试卡;  6VIP卡;9会员卡
            //userinfo.ProvinceId = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "ProvinceId"), 3);//省份id
            //userinfo.KeLei = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "KeLei"), 5);//科类
            //userinfo.GKYear = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "GKYear"), 2014);//参加高考的年份
            //userinfo.Status = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "Status"), 1);//登陆之后的状态值


            Status(); //根据状态  判定去向
        }
Exemplo n.º 5
0
        void page_Loading(object sender, EventArgs e)
        {
            #region 用户登录信息
            userinfo.StudentId    = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "StudentId"), 0);
            userinfo.StudentLevel = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "StudentLevel"), 0); //用户等级id:1普通注册用户;2高考查看卡; 3普通测试卡; 4普通卡;  5VIP测试卡;  6VIP卡;9会员卡
            userinfo.ProvinceId   = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "ProvinceId"), 0);   //省份id
            userinfo.KeLei        = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "KeLei"), 0);        //科类
            userinfo.GKYear       = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "GKYear"), 0);       //参加高考的年份
            userinfo.Status       = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "Status"), 0);       //登陆之后的状态值
            userinfo.StudentName  = Basic.CookieHelper.GetCookie("Student", "StudentName");                           //学生姓名
            userinfo.Bank         = Basic.CookieHelper.GetCookie("Student", "Bank");                                  //当前登陆的账号
            userinfo.LevelName    = Basic.CookieHelper.GetCookie("Student", "LevelName");                             //用户等级名称: 1普通注册用户;2高考查看卡; 3普通测试卡; 4普通卡;  5VIP测试卡;  6VIP卡;9会员卡
            userinfo.ProvinceName = Basic.CookieHelper.GetCookie("Student", "ProvinceName");                          //省份名称

            //userinfo.StudentId = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "StudentId"), 5);
            //userinfo.StudentLevel = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "StudentLevel"), 4);//用户等级id:1普通注册用户;2高考查看卡; 3普通测试卡; 4普通卡;  5VIP测试卡;  6VIP卡;9会员卡
            //userinfo.ProvinceId = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "ProvinceId"), 3);//省份id
            //userinfo.KeLei = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "KeLei"), 5);//科类
            //userinfo.GKYear = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "GKYear"), 2014);//参加高考的年份
            //userinfo.Status = Basic.Utils.StrToInt(Basic.CookieHelper.GetCookie("Student", "Status"), 1);//登陆之后的状态值

            userinfo.ProvinceName   = DAL.Common.GetProvinceName(userinfo.ProvinceId);
            userinfo.KeLeiMingCheng = DAL.Common.GetKeLeiMingCheng(userinfo.KeLei);
            #endregion


            #region 新疆乌鲁木齐咨询中心的卡不能在喀什地区使用

            if (userinfo.ProvinceId == 72)//新疆乌鲁木齐咨询中心
            {
                Entity.AreaJson infoAreaJson = DAL.AnalysisArea.GetAreaModel();
                if (infoAreaJson != null)
                {
                    if (infoAreaJson.code == "0")
                    {
                        if (infoAreaJson.data.city_id == "653100")
                        {
                            //新疆乌鲁木齐咨询中心的卡不能在喀什地区使用
                            Basic.MsgHelper.AlertUrlMsg("该卡不能在喀什地区使用", "/logout.aspx");
                        }
                    }
                }
            }
            #endregion


            Status(); //根据状态  判定去向

            //根据登陆用户的省份,去取一下省份的志愿配置信息
            int ProvinceId = userinfo.ProvinceId;

            provinceConfig = DAL.ProvinceConfig.ProvinceConfigEntityGet(userinfo.ProvinceId);

            //测试数据
            //history.LeiJiRenShu = 1000;
            //history.RenShu = 99;
            //history.WeiCi = 900;
            //history.FenShu = 600;

            if (userinfo.ProvinceId == 11)//浙江
            {
                history_zhejiang = DAL.StudentGaoKaoHistory_ZheJiang.StudentGaoKaoHistory_ZheJiangEntityGetByStudentId(userinfo.StudentId);
                if (history_zhejiang == null)
                {
                    Basic.MsgHelper.AlertUrlMsg("请首先设置自己的考试成绩!", "/Persional/ChengJiEdit2.aspx"); //跳转到成绩输入页面
                }
                if (history_zhejiang.ZongFen1 == 0 && history_zhejiang.ZongFen2 == 0 && history_zhejiang.ZongFen3 == 0)
                {
                    Basic.MsgHelper.AlertUrlMsg("您的成绩设置有问题,请重新设置后使用", "/Persional/ChengJiEdit2.aspx");
                }

                //判断第几批次,批次线差
                fenshuxian = DAL.FenShuXian.FenShuXianEntityGet(ProvinceId, " AND KeLei = " + userinfo.KeLei);
                // studentChengJi = DAL.CommonTuiJian.GetZheJiangUserPiCi(fenshuxian, history_zhejiang.ZongFen1, provinceConfig.LatestProvinceWeiCiYear, ProvinceId, userinfo.KeLei);

                //if (studentChengJi.PiCi == 0)
                //    Basic.MsgHelper.AlertUrlMsg("您的成绩设置有问题,请重新设置后使用", "/Persional/ChengJiEdit2.aspx");

                //StudentChengJiPiCi = studentChengJi.PiCi;
                ////studentChengJi.PiCiMingCheng = DAL.Common.GetPiCiName(StudentChengJiPiCi, userinfo.ProvinceId);
                //if (StudentChengJiPiCi <= 3)
                //    StudentChengJiPiCiMingCheng = "本科" + StudentChengJiPiCiMingCheng;
            }
            else
            {
                history = DAL.StudentGaoKaoHistory.StudentGaoKaoHistoryEntityGet(userinfo.StudentId);

                //非浙江
                if (history == null)
                {
                    Basic.MsgHelper.AlertUrlMsg("请首先设置自己的考试成绩!", "/Persional/ChengJiEdit2.aspx"); //跳转到成绩输入页面
                }
                if (history.FenShu == 0)
                {
                    Basic.MsgHelper.AlertUrlMsg("您的成绩设置有问题,请重新设置后使用", "/Persional/ChengJiEdit2.aspx");
                }


                if (history.IsSetUpWeiCi == 0)
                {
                    Entity.ProvinceWeiCi infoProvinceWeiCi = null;
                    if (userinfo.ProvinceId == 10)//江苏
                    {
                        //if (history.FenShu < 180)
                        //{
                        //    history.FenShu = 180;
                        //}
                        infoProvinceWeiCi = DAL.ProvinceWeiCi.ProvinceWeiCiEntityGetByFenShu(history.FenShu, provinceConfig.LatestProvinceWeiCiYear, userinfo.ProvinceId, userinfo.KeLei);
                    }
                    else
                    {
                        infoProvinceWeiCi = DAL.ProvinceWeiCi.ProvinceWeiCiEntityGetByFenShu(history.FenShu, provinceConfig.LatestProvinceWeiCiYear, userinfo.ProvinceId, userinfo.KeLei);
                    }
                    if (infoProvinceWeiCi != null)
                    {
                        history.WeiCi = infoProvinceWeiCi.WeiCi;
                    }
                    else
                    {
                        Basic.MsgHelper.AlertUrlMsg("您设置的成绩有问题,请重新设置后使用", "/Persional/ChengJiEdit2.aspx");
                    }
                }

                //判断第几批次,批次线差
                fenshuxian = DAL.FenShuXian.FenShuXianEntityGet(ProvinceId, " AND KeLei = " + userinfo.KeLei);
                if (history.IsSetUpFenShuXian == 1)
                {
                    fenshuxian.PcFirst  = (history.PcFirst > 0 ? history.PcFirst : fenshuxian.PcFirst);
                    fenshuxian.PcSecond = (history.PcSecond > 0 ? history.PcSecond : fenshuxian.PcSecond);
                    fenshuxian.PcThird  = (history.PcThird > 0 ? history.PcThird : fenshuxian.PcThird);
                    fenshuxian.ZkFirst  = (history.PcZhuanKeFirst > 0 ? history.PcZhuanKeFirst : fenshuxian.ZkFirst);
                    fenshuxian.ZkSecond = (history.PcZhuanKeSecond > 0 ? history.PcZhuanKeSecond : fenshuxian.ZkSecond);
                }


                studentChengJi = DAL.CommonTuiJian.GetUserPiCi(fenshuxian, history.FenShu, provinceConfig.LatestProvinceWeiCiYear, ProvinceId, userinfo.KeLei);
                if (studentChengJi.PiCi == 0)
                {
                    Basic.MsgHelper.AlertUrlMsg("您的成绩设置有问题,请重新设置后使用", "/Persional/ChengJiEdit2.aspx");
                }

                StudentChengJiPiCi = studentChengJi.PiCi;
                //<%=DAL.Common.GetPiCiMingCheng(studentChengJi.PiCi) %>
                if (history.IsSetUpFenShuXian == 1)
                {
                    switch (StudentChengJiPiCi)
                    {
                    case 1:
                        if (history.PcFirst > 0)
                        {
                            studentChengJi.PiCiMingCheng = "预估" + DAL.Common.GetPiCiName(StudentChengJiPiCi, userinfo.ProvinceId);
                        }
                        break;

                    case 2:
                        if (history.PcSecond > 0)
                        {
                            studentChengJi.PiCiMingCheng = "预估" + DAL.Common.GetPiCiName(StudentChengJiPiCi, userinfo.ProvinceId);
                        }
                        break;

                    case 3:
                        if (history.PcThird > 0)
                        {
                            studentChengJi.PiCiMingCheng = "预估" + DAL.Common.GetPiCiName(StudentChengJiPiCi, userinfo.ProvinceId);
                        }
                        break;

                    case 4:
                        if (history.PcZhuanKeFirst > 0)
                        {
                            studentChengJi.PiCiMingCheng = "预估" + DAL.Common.GetPiCiName(StudentChengJiPiCi, userinfo.ProvinceId);
                        }
                        break;

                    case 5:
                        if (history.PcZhuanKeSecond > 0)
                        {
                            studentChengJi.PiCiMingCheng = "预估" + DAL.Common.GetPiCiName(StudentChengJiPiCi, userinfo.ProvinceId);
                        }
                        break;

                    default:
                        studentChengJi.PiCiMingCheng = DAL.Common.GetPiCiName(StudentChengJiPiCi, userinfo.ProvinceId);
                        break;
                    }
                }
                else
                {
                    studentChengJi.PiCiMingCheng = DAL.Common.GetPiCiName(StudentChengJiPiCi, userinfo.ProvinceId);
                }
                if (StudentChengJiPiCi <= 3)
                {
                    StudentChengJiPiCiMingCheng = "本科" + StudentChengJiPiCiMingCheng;
                }
            }
        }
Exemplo n.º 6
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";

            string strHtml = "";

            int cxbl = Basic.RequestHelper.GetQueryInt("cxbl", -1);
            int sfid = Basic.RequestHelper.GetQueryInt("sfid", -1);
            int lqcc = Basic.RequestHelper.GetQueryInt("lqcc", -1);
            int lqpc = Basic.RequestHelper.GetQueryInt("lqpc", -1);
            int kl   = Basic.RequestHelper.GetQueryInt("kl", -1);


            string strSidList        = Basic.RequestHelper.GetQueryString("sidlist");
            int    studentProvinceId = Basic.RequestHelper.GetQueryInt("sfid", 0);


            string[] strArray    = strSidList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
            int[]    tdindex     = new int[strArray.Length];
            int[]    schoollist  = new int[strArray.Length];
            int[]    zhuanyelist = new int[strArray.Length];
            for (int i = 0; i < strArray.Length; i++)
            {
                string[] arr = strArray[i].Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
                if (arr.Length == 3)
                {
                    tdindex[i]     = Basic.TypeConverter.StrToInt(arr[0], 0);
                    schoollist[i]  = Basic.TypeConverter.StrToInt(arr[1], 0);
                    zhuanyelist[i] = Basic.TypeConverter.StrToInt(arr[2], 0);
                }
            }

            DataTable  dtPic = new DataTable();
            DataColumn dc    = null;

            dc = dtPic.Columns.Add("DataYear", Type.GetType("System.Int32"));
            dc.AutoIncrement     = true;  //自动增加
            dc.AutoIncrementSeed = 1;     //起始为1
            dc.AutoIncrementStep = 1;     //步长为1
            dc.AllowDBNull       = false; //

            dc = dtPic.Columns.Add("Professional1", Type.GetType("System.Int32"));
            dc = dtPic.Columns.Add("Professional2", Type.GetType("System.Int32"));
            dc = dtPic.Columns.Add("Professional3", Type.GetType("System.Int32"));
            dc = dtPic.Columns.Add("Professional4", Type.GetType("System.Int32"));
            dc = dtPic.Columns.Add("Professional5", Type.GetType("System.Int32"));

            DataRow newRow;



            Entity.ProvinceConfig provinceConfig = DAL.ProvinceConfig.ProvinceConfigEntityGet(studentProvinceId);
            DataTable             dtFen          = new DataTable();
            string strSchoolNameList             = "";

            for (int i = provinceConfig.LatestBenKeYear; i >= 2010; i--)
            {
                newRow             = dtPic.NewRow();
                newRow["DataYear"] = i;

                strHtml += "<tr><td>" + i + "</td>";
                for (int j = 1; j <= 5; j++)//循环获取5个td
                {
                    bool b = false;
                    for (int n = 0; n < tdindex.Length; n++)
                    {
                        if (j == tdindex[n])
                        {
                            b = true;
                            string    strWhere = "A.ProvinceId=" + studentProvinceId + " and A.DataYear=" + i + " and A.SchoolId = " + schoollist[n] + " and A.ZyId = " + zhuanyelist[n];
                            DataTable dt       = DAL.FenShengZhuanYeLuQu.FenShengZhuanYeLuQuWithSchoolList(strWhere, studentProvinceId, "All");//i.ToString()
                            if (dt != null && dt.Rows.Count > 0)
                            {
                                switch (cxbl)
                                {
                                case 0:    //提档分
                                    strHtml += "<td>" + dt.Rows[0]["ZyZuiDiFen"].ToString() + "</td>";
                                    newRow["Professional" + j + ""] = dt.Rows[0]["ZyZuiDiFen"].ToString();
                                    break;

                                case 1:    //平均分
                                    strHtml += "<td>" + dt.Rows[0]["ZyPingJunFen"].ToString() + "</td>";
                                    newRow["Professional" + j + ""] = dt.Rows[0]["ZyPingJunFen"].ToString();
                                    break;

                                case 2:    //批次线差
                                    strHtml += "<td>" + dt.Rows[0]["ZyPingJunXianCha"].ToString() + "</td>";
                                    newRow["Professional" + j + ""] = dt.Rows[0]["ZyPingJunXianCha"].ToString();
                                    break;

                                default:
                                    strHtml += "<td>0</td>";
                                    newRow["Professional" + j + ""] = "0";
                                    break;
                                }

                                strSchoolNameList += dt.Rows[0]["YuanXiaoMingCheng"].ToString() + "<br />" + dt.Rows[0]["ZhuanYeMingCheng"].ToString() + "|";
                            }
                            else
                            {
                                //不存在数据,那就是0了
                                strHtml += "<td>0</td>";
                                newRow["Professional" + j + ""] = "0";

                                strSchoolNameList += "未选择|";
                            }
                        }
                    }
                    if (b == false)
                    {
                        //不存在院校,那就是0了
                        strHtml += "<td>0</td>";
                        newRow["Professional" + j + ""] = "0";
                        strSchoolNameList += "未选择|";
                    }
                }
                strHtml += "</tr>";
                dtPic.Rows.Add(newRow);
            }

            strHtml += Basic.HighCharts.CreatHighChartsFromDT("duibitupian", "spline", "", "分数", strSchoolNameList, dtPic);;
            context.Response.Write(strHtml);
        }
Exemplo n.º 7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Entity.ProvinceConfig pConfig = DAL.ProvinceConfig.ProvinceConfigEntityGet(userinfo.ProvinceId);
            DataTable             dt      = DAL.ProvincePiCi.ProvincePiCiList(" ProvinceId = " + userinfo.ProvinceId + " AND LeiBie =  1  ORDER BY ShowOrder ASC,Id ASC ");

            rpt_PiCiList.DataSource = dt;
            rpt_PiCiList.DataBind();


            #region 绘图

            ////
            //DataTable dt2 = DAL.FenShuXian.FenShuXianList("DataYear,PcFirst,PcSecond,PcThird,ZkFirst,ZkSecond", " ProvinceId = " + userinfo.ProvinceId + " AND KeLei = " + userinfo.KeLei + " Order by DataYear DESC;");

            //DataView dv1 = dt2.DefaultView;
            //dv1.Sort = "DataYear Asc";
            //DataTable dt3 = dv1.ToTable();

            ////給DataTable
            //dt3.Columns.Add("StudentFenShu", typeof(int));
            //foreach (DataRow dr in dt3.Rows)
            //    dr["StudentFenShu"] = studentChengJi.FenShu;

            ////userinfo.ProvinceName + userinfo.KeLeiMingCheng + "历年省控线对比图"

            ////浙江必须要显示为文理科一批,文理科二批
            //if (userinfo.ProvinceId == 11)
            //{
            //    DataView dvZJ = dt3.DefaultView;
            //    dvZJ.Sort = "DataYear ASC";
            //    DataTable dtZJ = dvZJ.ToTable(true, new string[] { "DataYear", "PcFirst", "PcSecond", "ZkFirst", "StudentFenShu" });
            //    strHighCharts = Basic.HighCharts.CreatHighChartsFromDT("duibitu1", "spline", "", "分数", "文理科一批|文理科二批|文理科三批|学生成绩", dtZJ);
            //}
            //else
            //    strHighCharts = Basic.HighCharts.CreatHighChartsFromDT("duibitu1", "spline", "", "分数", "一本线|二本线|三本线|一专线|二专线|学生成绩", dt3);


            //DataTable dt4 = DAL.ProvinceWeiCi.ProvinceWeiCiGetByFenShuList(history_zhejiang.ZongFen1, userinfo.ProvinceId, userinfo.KeLei,1);
            //DataView dv2 = dt4.DefaultView;
            //dv2.Sort = "DataYear ASC";
            //DataTable dt5 = dv2.ToTable(true, new string[] { "DataYear", "WeiCi", "LeiJiRenShu" });
            //strHighCharts += Basic.HighCharts.CreatHighChartsFromDT("duibitu2", "column", "", "人", "|位次|累计人数", dt5);

            #endregion

            if (history_zhejiang.ZongFen1 > fenshuxian.PcFirst)
            {
                showtishipici = 1;
            }
            else
            {
                if (history_zhejiang.ZongFen2 > fenshuxian.PcSecond)
                {
                    showtishipici = 2;
                }
                else
                {
                    if (history_zhejiang.ZongFen3 > fenshuxian.ZkFirst)
                    {
                        showtishipici = 4;
                    }
                    else
                    {
                        showtishipici = 0;
                    }
                }
            }
            lit_Suggesiton.Text = ShowTiShiXinXi(showtishipici);
        }