protected void Page_Load(object sender, EventArgs e)
{
int SchoolId = Basic.RequestHelper.GetQueryInt("schoolid", 0);
int PiCi = Basic.RequestHelper.GetQueryInt("pici", 0);
int ZyId = Basic.RequestHelper.GetQueryInt("zyid", 0);
int PcLeiBie = Basic.RequestHelper.GetQueryInt("pcleibie", 0);
Entity.School school = DAL.School.SchoolEntityGet(SchoolId);
if (ZyId == 0)
{
return;
}
Entity.Professional zhuanye = DAL.Professional.ProfessionalEntityGet(ZyId);
strPageTitle = school.SchoolName + " " + zhuanye.ProfessionalName + "专业 <span>" + userinfo.ProvinceName + " " + userinfo.KeLeiMingCheng + " " + DAL.Common.GetPiCiName(PiCi, userinfo.ProvinceId) + DAL.Common.GetPcLeiBieMingCheng(PcLeiBie) + "</span>的历年录取情况";
DataTable dt = DAL.FenShengZhuanYeLuQu.FenShengZhuanYeLuQuList("SchoolId = " + SchoolId + " AND ZyId = " + ZyId + " AND PiCi = " + PiCi + " AND PcLeiBie = " + PcLeiBie + " AND ProvinceId = " + userinfo.ProvinceId + " AND KeLei = " + userinfo.KeLei + " ORDER BY DataYear DESC", userinfo.ProvinceId, "All");
rpt_List.DataSource = dt;
rpt_List.DataBind();
int XianCha = 0;
if (userinfo.ProvinceId == 11)
{
XianCha = DAL.CommonTuiJian.GetUserPiCiXianCha(fenshuxian, history.FenShu, (PiCi == 0 ? 1 : PiCi));
}
else
{
XianCha = DAL.CommonTuiJian.GetUserPiCiXianCha(fenshuxian, history.FenShu, PiCi);
}
//給DataTable
dt.Columns.Add("StudentWeiCi", typeof(int));
dt.Columns.Add("StudentFenShu", typeof(int));
dt.Columns.Add("StudentXianCha", typeof(int));
foreach (DataRow dr in dt.Rows)
{
dr["StudentWeiCi"] = studentChengJi.WeiCi;
dr["StudentFenShu"] = studentChengJi.FenShu;
dr["StudentXianCha"] = XianCha;
}
//位次 线差 分数
DataView dv = dt.DefaultView;
dv.Sort = "DataYear ASC";
DataTable dt2 = dv.ToTable(true, new string[] { "DataYear", "zyZuiXiaoWeiCi", "zyPingJunWeiCi", "zyZuiDaWeiCi", "StudentWeiCi" });
strHighCharts += Basic.HighCharts.CreatHighChartsFromDT("weicicontainer", "spline", "", "分数", "|最小位次|平均位次|最大位次|您的位次", dt2);
DataTable dt3 = dv.ToTable(true, new string[] { "DataYear", "zyPingJunXianCha", "StudentXianCha" });
strHighCharts += Basic.HighCharts.CreatHighChartsFromDT("xianchacontainer", "column", "", "分数", "|平均线差|您的线差", dt3);
DataTable dt4 = dv.ToTable(true, new string[] { "DataYear", "zyZuiGaoFen", "zyPingJunFen", "zyZuiDiFen", "StudentFenShu" });
strHighCharts += Basic.HighCharts.CreatHighChartsFromDT("fenshucontainer", "spline", "", "分数", "|最高分|平均分|最低分|您的分数", dt4);
}
void Bind()
{
intArticleId = Basic.RequestHelper.GetQueryInt("articleid", 0);
intProfessionalId = Basic.RequestHelper.GetQueryInt("professionalid", 0);
Entity.Professional infoSP = DAL.Professional.ProfessionalEntityGet(intProfessionalId);
if (infoSP != null)
{
strProfessionalName = infoSP.ProfessionalName;//专业名称
ProfessionalBase1.info = infoSP;
ProfessionalLeft1.ProfessionalId = infoSP.Id;
ProfessionalLeft1.XueKeMenLeiName = infoSP.XueKeMenLeiName;
Crumb1.NavString = " <span>></span> <a href=\"/zhuanye.shtml\" title\"高考报考专业库\">高考报考专业库</a> <span>></span> <a href=\"/zhuanye-jianjie-" + infoSP.Id + ".shtml\" title\"" + infoSP.ProfessionalName + "\">" + infoSP.ProfessionalName + "</a> <span>></span> <a href=\"/zhuanye-bianxi-" + infoSP.Id + ".shtml\" title\"" + infoSP.ProfessionalName + "专业辨析\">专业辨析</a>";
Entity.Article info = DAL.Article.ArticleEntityGet(intArticleId);
if (info != null)
{
Crumb1.NavString += " <span>></span> " + info.Title;
strPageTitle = info.Title;//标题
ltlTitle.Text = info.Title;
ltlContent.Text = info.Content;
}
else
{
Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
}
}
else
{
Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
}
}
void Bind()
{
intProfessionalId = Basic.RequestHelper.GetQueryInt("professionalid", 0);
Entity.Professional info = DAL.TengXB.Professional.ProfessionalEntityGet(intProfessionalId);
if (info != null)
{
strProfessionalName = info.ProfessionalName;//专业名称
ProfessionalBase1.info = info;
ProfessionalLeft1.ProfessionalId = info.Id;
ProfessionalLeft1.XueKeMenLeiName = info.XueKeMenLeiName;
Crumb1.NavString = " <span>></span> <a href=\"/zhuanye.shtml\" title\"高考报考专业库\">高考报考专业库</a> <span>></span> <a href=\"/zhuanye-jianjie-" + info.Id + ".shtml\" title\"" + info.ProfessionalName + "\">" + info.ProfessionalName + "</a> <span>></span> 专业排名";
DataTable dt = DAL.TengXB.ProfessionalArticle.ProfessionalAndArticleList(" Article.CategoryId = 2 AND Article.IsPause = 0 AND ProfessionalId = " + intProfessionalId);
if (dt != null && dt.Rows.Count > 0)
{
ltlContent.Text = dt.Rows[0]["Content"].ToString();
}
}
else
{
Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
}
}
/// <summary>
/// 获取某一个实体
/// </summary>
/// <param name="Id">标识</param>
/// <returns>返回Entity</returns>
public static Entity.Professional ProfessionalEntityGet(int Id)
{
Entity.Professional info = new Entity.Professional();
DataTable dt = SqlDB.ExecuteDataset(CommandType.Text, "select P3.* ,P2.ProfessionalName AS ZhaunYeLeiName,P1.ProfessionalName AS XueKeMenLeiName from Professional as P3,Professional as P2,Professional as P1 where P3.ParentId=P2.Id and P2.ParentId = P1.Id and P3.Id = " + Id + ";").Tables[0];
if (dt.Rows.Count > 0)
{
info.Id = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0);
info.Code = dt.Rows[0]["Code"].ToString();
info.ProfessionalName = dt.Rows[0]["ProfessionalName"].ToString();
info.Remark = dt.Rows[0]["Remark"].ToString();
info.ProfessionalGrade = Basic.Utils.StrToInt(dt.Rows[0]["ProfessionalGrade"].ToString(), 0);
info.ParentId = Basic.Utils.StrToInt(dt.Rows[0]["ParentId"].ToString(), 0);
info.ProfessionalIntro = dt.Rows[0]["ProfessionalIntro"].ToString();
info.IsBen = Basic.Utils.StrToInt(dt.Rows[0]["IsBen"].ToString(), 0);
info.ClickNum = Basic.Utils.StrToInt(dt.Rows[0]["ClickNum"].ToString(), 0);
info.ZhaunYeLeiName = dt.Rows[0]["ZhaunYeLeiName"].ToString();
info.XueKeMenLeiName = dt.Rows[0]["XueKeMenLeiName"].ToString();
return(info);
}
else
{
return(null);
}
}
void Bind()
{
intProfessionalId = Basic.RequestHelper.GetQueryInt("professionalid", 0);
Entity.Professional info = DAL.TengXB.Professional.ProfessionalEntityGet(intProfessionalId);
if (info != null)
{
strProfessionalName = info.ProfessionalName;//专业名称
ProfessionalBase1.info = info;
ProfessionalLeft1.ProfessionalId = info.Id;
ProfessionalLeft1.XueKeMenLeiName = info.XueKeMenLeiName;
Crumb1.NavString = " <span>></span> <a href=\"/zhuanye.shtml\" title\"高考报考专业库\">高考报考专业库</a> <span>></span> <a href=\"/zhuanye-jianjie-" + info.Id + ".shtml\" title\"" + info.ProfessionalName + "\">" + info.ProfessionalName + "</a> <span>></span> 历年就业率";
string strWhere = "";
Entity.Professional infoP = DAL.Professional.ProfessionalEntityGet(intProfessionalId);
if (infoP != null)
{
if (infoP.ProfessionalGrade == 1)
{
strWhere = "XueKeMenLei = " + intProfessionalId;
}
else if (infoP.ProfessionalGrade == 2)
{
strWhere = "ZhuanYeLei = " + intProfessionalId;
}
else
{
strWhere = "ZhuanYeId = " + intProfessionalId;
}
}
else
{
Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
}
strWhere += " ORDER BY Year DESC ";
DataTable dt = DAL.JiuYeLv.JiuYeLvList(strWhere);
if (dt != null && dt.Rows.Count > 0)
{
rptList.DataSource = dt;
rptList.DataBind();
}
else
{
//没有改专业的相关就业率数据
}
}
else
{
Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
}
}
public static bool ProfessionalClickNum(Entity.Professional info)
{
int intReturnValue = 0;
intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "UPDATE [Professional] SET ClickNum = " + info.ClickNum + " WHERE Id = " + info.Id);
if (intReturnValue == 1)
{
return(true);
}
return(false);
}
void Bind()
{
intProfessionalId = Basic.RequestHelper.GetQueryInt("professionalid", 0);
Entity.Professional info = DAL.TengXB.Professional.ProfessionalEntityGet(intProfessionalId);
if (info != null)
{
info.ClickNum += 1;
DAL.TengXB.Professional.ProfessionalClickNum(info);
Crumb1.NavString = " <span>></span> <a href=\"/zhuanye.shtml\" title\"高考报考专业库\">高考报考专业库</a> <span>></span> " + info.ProfessionalName;
ProfessionalBase1.info = info;
ProfessionalLeft1.ProfessionalId = info.Id;
ProfessionalLeft1.XueKeMenLeiName = info.XueKeMenLeiName;
strProfessionalName = info.ProfessionalName;//专业名称
ltlContent.Text = info.ProfessionalIntro;
}
}
void Bind()
{
intProfessionalId = Basic.RequestHelper.GetQueryInt("professionalid", 0);
Entity.Professional info = DAL.TengXB.Professional.ProfessionalEntityGet(intProfessionalId);
if (info != null)
{
strProfessionalName = info.ProfessionalName;
ProfessionalBase1.info = info;
ProfessionalLeft1.ProfessionalId = info.Id;
ProfessionalLeft1.XueKeMenLeiName = info.XueKeMenLeiName;
Crumb1.NavString = " <span>></span> <a href=\"/zhuanye.shtml\" title\"高考报考专业库\">高考报考专业库</a> <span>></span> <a href=\"/zhuanye-jianjie-" + info.Id + ".shtml\" title\"" + info.ProfessionalName + "\">" + info.ProfessionalName + "</a> <span>></span> 相关职业";
BindZhiYe();//相关职业
}
else
{
Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
}
}
void Bind()
{
int intId = Basic.RequestHelper.GetQueryInt("spid", 0);
Entity.SchoolProfessional info = DAL.SchoolProfessional.SchoolProfessionalEntityGet(intId);
if (info != null)
{
strProfessionalName = info.ProfessionalName;//专业名称
Entity.School infoSchool = DAL.School.SchoolEntityGet(info.SchoolId);
if (infoSchool != null)
{
SchoolLeft1.intSchoolId = info.SchoolId;
SchoolBase1.info = infoSchool;
strSchoolName = infoSchool.SchoolName;//院校名称
Crumb1.NavString = " <span>></span> <a href=\"/daxue.shtml\" title=\"高考报考院校库\">高考报考院校库</a> <span>></span> <a href=\"/daxue-jianjie-" + infoSchool.Id + ".shtml\" title=\"" + infoSchool.SchoolName + "\">" + infoSchool.SchoolName + "</a> <span>></span> " + strProfessionalName;
}
//专业相关信息
ltlTitle.Text = info.ProfessionalName;
string strIntro = info.ProfessionalIntro;
if (strIntro.Trim() == "")
{
Entity.Professional infoPro = DAL.Professional.ProfessionalEntityGet(info.ProfessionalId);
if (infoPro != null)
{
strIntro = infoPro.ProfessionalIntro;
}
}
ltlContent.Text = strIntro;
}
else
{
Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
}
}
void Bind()
{
intProfessionalId = Basic.RequestHelper.GetQueryInt("professionalid", 0);
Entity.Professional info = DAL.TengXB.Professional.ProfessionalEntityGet(intProfessionalId);
if (info != null)
{
strProfessionalName = info.ProfessionalName;//专业名称
ProfessionalBase1.info = info;
ProfessionalLeft1.ProfessionalId = info.Id;
ProfessionalLeft1.XueKeMenLeiName = info.XueKeMenLeiName;
Crumb1.NavString = " <span>></span> <a href=\"/zhuanye.shtml\" title\"高考报考专业库\">高考报考专业库</a> <span>></span> <a href=\"/zhuanye-jianjie-" + info.Id + ".shtml\" title\"" + info.ProfessionalName + "\">" + info.ProfessionalName + "</a> <span>></span> 开设院校";
DataTable dt0 = DAL.FenShengZhuanYeLuQu.ZhuanYeKaiSheYuanXiaoList("ZyId = " + intProfessionalId, "2013");
DataView dv = dt0.DefaultView;
//1华东地区（包括15山东、10江苏、12安徽、11浙江、13福建、9上海）
//2华南地区（包括19广东、20广西、21海南）
//3华中地区（包括17湖北、18湖南、16河南、14江西）
//4华北地区（包括1北京、2天津、3河北、4山西、5内蒙古）
//5西北地区（包括30宁夏、31新疆、29青海、27陕西、28甘肃）
//6西南地区（包括23四川、25云南、24贵州、26西藏、22重庆）
//7东北地区（包括6辽宁、7吉林、8黑龙江）
//8台港澳地区（32包括台湾、香港、澳门）
dv.RowFilter = " SchoolProvinceId = 15 OR SchoolProvinceId = 10 OR SchoolProvinceId = 12 OR SchoolProvinceId = 11 OR SchoolProvinceId = 13 OR SchoolProvinceId = 9 ";
DataTable dt1 = dv.ToTable();
Repeater1.DataSource = dt1;
Repeater1.DataBind();
dv.RowFilter = " SchoolProvinceId = 19 OR SchoolProvinceId = 20 OR SchoolProvinceId = 21 ";
DataTable dt2 = dv.ToTable();
Repeater2.DataSource = dt2;
Repeater2.DataBind();
dv.RowFilter = " SchoolProvinceId = 17 OR SchoolProvinceId = 18 OR SchoolProvinceId = 16 OR SchoolProvinceId = 14 ";
DataTable dt3 = dv.ToTable();
Repeater3.DataSource = dt3;
Repeater3.DataBind();
dv.RowFilter = " SchoolProvinceId = 1 OR SchoolProvinceId = 2 OR SchoolProvinceId = 3 OR SchoolProvinceId = 4 OR SchoolProvinceId = 5 ";
DataTable dt4 = dv.ToTable();
Repeater4.DataSource = dt4;
Repeater4.DataBind();
dv.RowFilter = " SchoolProvinceId = 30 OR SchoolProvinceId = 31 OR SchoolProvinceId = 29 OR SchoolProvinceId = 27 OR SchoolProvinceId = 28 ";
DataTable dt5 = dv.ToTable();
Repeater5.DataSource = dt5;
Repeater5.DataBind();
dv.RowFilter = " SchoolProvinceId = 23 OR SchoolProvinceId = 25 OR SchoolProvinceId = 24 OR SchoolProvinceId = 26 OR SchoolProvinceId = 22 ";
DataTable dt6 = dv.ToTable();
Repeater6.DataSource = dt6;
Repeater6.DataBind();
dv.RowFilter = " SchoolProvinceId = 6 OR SchoolProvinceId = 7 OR SchoolProvinceId = 8 ";
DataTable dt7 = dv.ToTable();
Repeater7.DataSource = dt7;
Repeater7.DataBind();
}
else
{
Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string str = "";
DataTable dt = DAL.FenShengZhuanYeLuQu.FenShengZhuanYeLuQu_AllList();
for (int i = 0; i < dt.Rows.Count; i++)
{
int SchoolId = Basic.TypeConverter.StrToInt(dt.Rows[i]["SchoolId"].ToString(), 0);
int ProfessionalId = Basic.TypeConverter.StrToInt(dt.Rows[i]["ZyId"].ToString(), 0);
if (DAL.FenShengZhuanYeLuQu.SchoolZhuanYeCount(SchoolId, ProfessionalId) == 0)
{
//需要新增
int DisciplinesId = 0;
int ProfessionalGrade = Basic.TypeConverter.StrToInt(dt.Rows[i]["ProfessionalGrade"].ToString(), 0);
int ParentId = Basic.TypeConverter.StrToInt(dt.Rows[i]["ParentId"].ToString(), 0);
if (ProfessionalGrade == 3)
{
Entity.Professional info = DAL.Professional.ProfessionalEntityGet(ParentId);
if (info != null)
{
DisciplinesId = info.ParentId;
}
else
{
str += SchoolId + "-" + ProfessionalId + ";";
}
}
else if (ProfessionalGrade == 2)
{
DisciplinesId = ParentId;
}
else
{
str += SchoolId + "-" + ProfessionalId + ";";
}
if (DisciplinesId > 0)
{
int SchoolDisciplinesId = 0;
//开始插入数据
//1.操作 SchoolDisciplines 表
DataTable dt2 = DAL.SchoolDisciplines.SchoolDisciplinesList("SchoolId=" + SchoolId + " and DisciplinesId=" + DisciplinesId);
if (dt2 != null && dt2.Rows.Count > 0)
{
SchoolDisciplinesId = Basic.TypeConverter.StrToInt(dt2.Rows[0]["Id"].ToString(), 0);
int ProfessionalCount = Basic.TypeConverter.StrToInt(dt2.Rows[0]["ProfessionalCount"].ToString(), 0);
DAL.SchoolDisciplines.SchoolDisciplinesProfessionalCount((ProfessionalCount + 1), SchoolDisciplinesId);
}
else
{
Entity.SchoolDisciplines info = new Entity.SchoolDisciplines();
info.DisciplinesId = DisciplinesId;
info.IsPause = 0;
info.ProfessionalCount = 1;
info.SchoolId = SchoolId;
SchoolDisciplinesId = DAL.SchoolDisciplines.SchoolDisciplinesAdd(info);
}
if (SchoolDisciplinesId == 0)
{
Basic.MsgHelper.AlertBackMsg("wrong");
}
else
{
//2.操作 SchoolProfessional 表
Entity.SchoolProfessional model = new Entity.SchoolProfessional();
model.AddTime = DateTime.Now;
model.AddWid = 0;
model.ClickNum = 0;
model.IsErJiZhongDian = 0;
model.IsPause = 0;
model.IsTeSe = 0;
model.IsXueKePaiMing = 0;
model.IsYiJiZhongDian = 0;
model.ProfessionalId = ProfessionalId;
model.ProfessionalIntro = "";
model.ProfessionalName = dt.Rows[i]["ZhuanYeMingCheng"].ToString();
model.SchoolDisciplinesId = SchoolDisciplinesId;
int nu = DAL.SchoolProfessional.SchoolProfessionalAdd(model);
if (nu == 0)
{
Basic.MsgHelper.AlertBackMsg("aa");
}
}
}
}
}
}
