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); }
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()))%> }
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); }
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(); //根据状态 判定去向 }
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; } } }
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); }
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); }