void Bind()
{
intSchoolId = Basic.RequestHelper.GetQueryInt("schoolid", 0);
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
SchoolLeft1.intSchoolId = intSchoolId;
SchoolBase1.info = info;
strSchoolName = info.SchoolName;
Crumb1.NavString = " <span>></span> <a href=\"/daxue.shtml\" title=\"高考报考院校库\">高考报考院校库</a> <span>></span> <a href=\"/daxue-jianjie-" + info.Id + ".shtml\" title=\"" + info.SchoolName + "\">" + info.SchoolName + "</a> <span>></span> 招生章程";
}
else
{
Basic.MsgHelper.AlertBackMsg("不合法的访问");
}
DataTable dt = DAL.SchoolArticle.SchoolArticleList(" SchoolId = " + intSchoolId + " and CategoryId = 2 ORDER By Year DESC");
if (dt != null && dt.Rows.Count > 0)
{
string strYear = "";
string strContent = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
strYear += "<li " + (i == 0 ? "class=\"current\"" : "") + "><a href=\"javascript:void(0);\">" + dt.Rows[i]["Year"].ToString() + "年</a></li>";
strContent += "<div class=\"conRword\" " + (i > 0 ? "style=\"display: none;\"" : "") + ">" + dt.Rows[i]["Content"].ToString() + "</div>";
}
ltlYear.Text = strYear;
ltlContent.Text = strContent;
}
}
void Bind()
{
intSchoolId = Basic.RequestHelper.GetQueryInt("schoolid", 0);
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
SchoolLeft1.intSchoolId = intSchoolId;
SchoolBase1.info = info;
strSchoolName = info.SchoolName;
Crumb1.NavString = " <span>></span> <a href=\"/daxue.shtml\" title=\"高考报考院校库\">高考报考院校库</a> <span>></span> <a href=\"/daxue-jianjie-" + info.Id + ".shtml\" title=\"" + info.SchoolName + "\">" + info.SchoolName + "</a> <span>></span> 招办访谈";
}
else
{
Basic.MsgHelper.AlertBackMsg("不合法的访问");
}
DataTable dt = DAL.SchoolArticle.SchoolArticleList("SchoolId = " + intSchoolId + " AND CategoryId = 20");
if (dt != null && dt.Rows.Count > 0)
{
rptList.DataSource = dt;
rptList.DataBind();
}
}
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()
{
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
SchoolLogo.Src = "../logo/" + (info.Logo == "" ? "default.png" : info.Logo);
}
}
public static bool SchoolClickNum(Entity.School info)
{
int intReturnValue = 0;
intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "UPDATE [School] SET ClickNum = " + info.ClickNum + " WHERE Id = " + info.Id);
if (intReturnValue == 1)
{
return(true);
}
return(false);
}
public async Task <SchoolDto> Add(SchoolInputDto input)
{
var school = new Entity.School()
{
Name = input.Name,
Address = input.Address,
};
await _dbContext.Schools.AddAsync(school);
await _dbContext.SaveChangesAsync();
return(_dtoFactory.CreateDto(school));
}
void Bind()
{
intSchoolId = Basic.RequestHelper.GetQueryInt("schoolid", 0);
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
SchoolLeft1.intSchoolId = intSchoolId;
SchoolBase1.info = info;
strPageTitle = info.SchoolName;
Crumb1.NavString = " <span>></span> <a href=\"/daxue.shtml\" title=\"高考报考院校库\">高考报考院校库</a> <span>></span> <a href=\"/daxue-jianjie-" + info.Id + ".shtml\" title=\"" + info.SchoolName + "\">" + info.SchoolName + "</a> <span>></span> 优势专业";
}
else
{
Basic.MsgHelper.AlertBackMsg("不合法的访问");
}
DataTable dt = null;
string strWhere = "sd.SchoolId = " + intSchoolId;
//特色专业
strWhere = "sd.SchoolId = " + intSchoolId + " AND sp.IsTeSe = 1";
dt = DAL.TengXB.SchoolDisciplines.YouShiZhuanYeList(strWhere);
if (dt != null && dt.Rows.Count > 0)
{
rpTeSetList.DataSource = dt;
rpTeSetList.DataBind();
}
//一级重点学科
strWhere = "sd.SchoolId = " + intSchoolId + " AND sp.IsYiJiZhongDian = 1";
dt = DAL.TengXB.SchoolDisciplines.YouShiZhuanYeList(strWhere);
if (dt != null && dt.Rows.Count > 0)
{
rptYiJiList.DataSource = dt;
rptYiJiList.DataBind();
}
//二级重点学科
strWhere = "sd.SchoolId = " + intSchoolId + " AND sp.IsErJiZhongDian = 1";
dt = DAL.TengXB.SchoolDisciplines.YouShiZhuanYeList(strWhere);
if (dt != null && dt.Rows.Count > 0)
{
rptErJiList.DataSource = dt;
rptErJiList.DataBind();
}
}
string GetSchoolHtml(int intSchoolId)
{
string strHtml = "";
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
strHtml += "<div class=\"dbdx\" sid='" + info.Id + "'>";
strHtml += "<dl>";
strHtml += "<dt><a target=\"_blank\" href=\"daxue-jianjie-" + info.Id + ".shtml\" title=\"" + info.SchoolName + "\"><img src=\"/logo/" + (info.Logo == "" ? "default.png" : info.Logo) + "\" width=\"72\" height=\"73\" /></a></dt>";
strHtml += "<dd><a target=\"_blank\" href=\"daxue-jianjie-" + info.Id + ".shtml\" title=\"" + info.SchoolName + "\">" + Basic.Utils.GetUnicodeSubString(info.SchoolName, 20, "") + "</a></dd>";
strHtml += "<dd><span><a href=\"javascript:cancelDuiBi(" + info.Id + ");\">[取消对比]</a></span></dd>";
strHtml += "</dl>";
strHtml += "</div>";
}
return(strHtml);
}
protected void Page_Load(object sender, EventArgs e)
{
intSchoolId = Basic.RequestHelper.GetQueryInt("schoolid", 0);
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
SchoolBase1.info = info;
SchoolLeft1.intSchoolId = info.Id;
strPageTitle = info.SchoolName;
Crumb1.NavString = " <span>></span> <a href=\"/daxue.shtml\" title=\"高考报考院校库\">高考报考院校库</a> <span>></span> <a href=\"/daxue-jianjie-" + info.Id + ".shtml\" title=\"" + info.SchoolName + "\">" + info.SchoolName + "</a> <span>></span> 历年分数线";
}
else
{
Basic.MsgHelper.AlertBackMsg("不合法的访问");
}
}
void Bind()
{
intSchoolId = Basic.RequestHelper.GetQueryInt("schoolid", 0);
SchoolLeft1.intSchoolId = intSchoolId;
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
info.ClickNum += 1;
DAL.TengXB.School.SchoolClickNum(info);
SchoolBase1.info = info;
strSchoolName = info.SchoolName;
strSchoolEnName = info.SchoolEnName;
//面包屑
Crumb1.NavString = " <span>></span> <a href=\"/daxue.shtml\" title=\"高考报考院校库\">高考报考院校库</a> <span>></span> " + info.SchoolName;
ltlSchoolIntro.Text = info.SchoolIntro;
DataTable dt = DAL.TengXB.SchoolCampus.GetSchoolCampusList(" SchoolId = " + intSchoolId);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string strCampus = dt.Rows[i]["Campus"].ToString();
if (strCampus == "")
{
strCampus = "本部校区";
}
ltlCampus.Text += "<li" + (i == 0 ? " class=\"current\"" : "") + " pano=\"" + dt.Rows[i]["Pano"].ToString() + "\" heading=\"" + dt.Rows[i]["Heading"].ToString() + "\" pitch=\"" + dt.Rows[i]["Pitch"].ToString() + "\" zoom=\"" + dt.Rows[i]["Zoom"].ToString() + "\"><a href=\"javascript:void(0)\">" + strCampus + "</a></li>";
}
}
else
{
strHasCampus = "no";
}
BindSchools(info.ProvinceId);
}
}
void Bind()
{
int intId = Basic.RequestHelper.GetQueryInt("id", 0);
Entity.SchoolArticle info = DAL.SchoolArticle.SchoolArticleEntityGet(intId);
if (info != null)
{
Entity.School infoSchool = DAL.School.SchoolEntityGet(info.SchoolId);
strPageTitle = info.Title;
SchoolLeft1.intSchoolId = info.SchoolId;
SchoolBase1.info = infoSchool;
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> <a href=\"/daxue-fangtan-" + infoSchool.Id + ".shtml\" title=\"" + infoSchool.SchoolName + "招办访谈\">招办访谈" + "</a> <span>></span> " + info.Title;
ltlTitle.Text = info.Title;
ltlContent.Text = info.Content;
}
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()
{
intSchoolId = Basic.RequestHelper.GetQueryInt("schoolid", 0);
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
SchoolLeft1.intSchoolId = intSchoolId;
SchoolBase1.info = info;
strSchoolName = info.SchoolName;
Crumb1.NavString = " <span>></span> <a href=\"/daxue.shtml\" title=\"高考报考院校库\">高考报考院校库</a> <span>></span> <a href=\"/daxue-jianjie-" + info.Id + ".shtml\" title=\"" + info.SchoolName + "\">" + info.SchoolName + "</a> <span>></span> 录取规则";
}
else
{
Basic.MsgHelper.AlertBackMsg("不合法的访问");
}
DataTable dt = DAL.SchoolArticle.SchoolArticleList(" SchoolId = " + intSchoolId + " and CategoryId = 13 ORDER By Year DESC");
if (dt != null && dt.Rows.Count > 0)
{
ltlContent.Text = dt.Rows[0]["Content"].ToString();
}
}
void Bind()
{
intSchoolId = Basic.RequestHelper.GetQueryInt("schoolid", 0);
Entity.School info = DAL.School.SchoolEntityGet(intSchoolId);
if (info != null)
{
SchoolLeft1.intSchoolId = intSchoolId;
SchoolBase1.info = info;
strPageTitle = info.SchoolName;
Crumb1.NavString = " <span>></span> <a href=\"/daxue.shtml\" title=\"高考报考院校库\">高考报考院校库</a> <span>></span> <a href=\"/daxue-jianjie-" + info.Id + ".shtml\" title=\"" + info.SchoolName + "\">" + info.SchoolName + "</a> <span>></span> 开设专业";
}
else
{
Basic.MsgHelper.AlertBackMsg("不合法的访问");
}
DataTable dt = null;
//本科
dt = DAL.TengXB.SchoolDisciplines.GetSchoolDisciplinesList(" sd.SchoolId = " + intSchoolId + " AND p.IsBen = 1");
if (dt != null && dt.Rows.Count > 0)
{
rptBenKeList.DataSource = dt;
rptBenKeList.DataBind();
}
//专科
dt = DAL.TengXB.SchoolDisciplines.GetSchoolDisciplinesList(" sd.SchoolId = " + intSchoolId + " AND p.IsBen = 2");
if (dt != null && dt.Rows.Count > 0)
{
rptZhuanKeList.DataSource = dt;
rptZhuanKeList.DataBind();
}
}
