protected void Page_Load(object sender, EventArgs e) { if (Request.Params["schid"] != null && Request.Params["schid"].ToString() != "") { string schid = Com.Public.SqlEncStr(Request.Params["schid"].ToString()); //先得到操作类型 SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo(); SchSystem.Model.SchInfo usermodel = new SchSystem.Model.SchInfo(); if (string.IsNullOrEmpty(schid)) { Response.Write("无对应修改的记录!"); Response.End(); } //获取修改的对应用户的 usermodel = schbll.GetSupportModel(int.Parse(schid)); if (usermodel != null && usermodel.SchId > 0) { umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(usermodel); } else { Response.Write("无该学校!"); Response.End(); } if (!string.IsNullOrEmpty(schid)) { //获取管理员账号密码信息 SchSystem.BLL.SchUserInfo suiBll = new SchSystem.BLL.SchUserInfo(); SchSystem.Model.SchUserInfo modeluserinfo = suiBll.GetSupportModel(int.Parse(schid), 1); if (modeluserinfo != null) { if (modeluserinfo.PassWord == Com.Public.StrToMD5("123456")) { modeluserinfo.PassWord = "******"; } } usermanagerstr = Newtonsoft.Json.JsonConvert.SerializeObject(modeluserinfo); //系统科目 SchSystem.BLL.SysSub syssubbll = new SchSystem.BLL.SysSub(); DataTable dtsub = syssubbll.GetList("'0' pId,SubCode id,SubName name,'false' checked", "1=1 Order by SubCode").Tables[0];//Stat=1 //获取学校的sub SchSystem.BLL.SchSub schsubbll = new SchSystem.BLL.SchSub(); DataTable dtschsub = schsubbll.GetList("'0' pId,SubCode id,SubName name,'false' checked", "Stat=1 and SchId='" + schid + "' Order by SubCode").Tables[0]; DataTable dtsubmat = dtsub.Copy(); if (dtsub != null && dtschsub != null && dtsub.Rows.Count > 0 && dtschsub.Rows.Count > 0) { for (int i = 0; i < dtsub.Rows.Count; i++) { DataRow[] drs = dtschsub.Select("id='" + dtsub.Rows[i]["id"].ToString() + "'"); if (drs.Length > 0) { dtsub.Rows[i]["checked"] = "true"; } } } subs = Newtonsoft.Json.JsonConvert.SerializeObject(dtsub); subsmat = Newtonsoft.Json.JsonConvert.SerializeObject(dtsubmat); //获取子系统:AutoId,AppCode,AppName,Stat,RecTime,RecUser,LastRecTime,LastRecUser SchSystem.BLL.SchApp schappBll = new SchSystem.BLL.SchApp(); DataTable dtschapp = schappBll.GetList("'0' pId,AutoId id,AppName name,'false' checked,AppCode", "").Tables[0]; SchSystem.BLL.SchAppRole schapproleBll = new SchSystem.BLL.SchAppRole(); DataTable dtschapprole = schapproleBll.GetList("SchId='" + schid + "'").Tables[0]; if (dtschapp.Rows.Count > 0) { for (int i = 0; i < dtschapp.Rows.Count; i++) { DataRow[] drstr = dtschapprole.Select(); if (drstr.Length > 0) { string approlestr = drstr[0]["AppStr"].ToString(); string[] approlearr = approlestr.Split(','); int approlearrlen = approlearr.Length; for (int j = 0; j < approlearrlen; j++) { if (dtschapp.Rows[i]["AppCode"].ToString() == approlearr[j]) { dtschapp.Rows[i]["checked"] = "true"; } } } } } sonsys = Newtonsoft.Json.JsonConvert.SerializeObject(dtschapp); //获取整个系统的年级 SchSystem.BLL.SysGrade sysgradebll = new SchSystem.BLL.SysGrade(); DataTable dtgrade = sysgradebll.GetList("GradeType pId,GradeCode id,GradeName name,'false' checked,'false' nochecks,'0' IsFinish,'' GradeYear,'' GradeId", " GradeCode<>'3004' and GradeCode<>'4004' Order by GradeType,GradeLv").Tables[0]; #region 家校互通平台子模块 SchSystem.BLL.SchAppXXT saxxtBll = new SchSystem.BLL.SchAppXXT(); DataTable dtsaxxt = saxxtBll.GetList("'0' pId,AppCode id,AppName name,'false' checked,'false' isShar", "Stat=1").Tables[0]; SchSystem.BLL.SchAppRoleXXT sarxxtBll = new SchSystem.BLL.SchAppRoleXXT(); DataTable dtsarxxt = sarxxtBll.GetList("SchId='" + schid + "'").Tables[0]; DataRow[] drsarxxt = dtsarxxt.Select(); string[] approlexxtarr = { }; if (drsarxxt.Length > 0) { approlexxtarr = drsarxxt[0]["AppStr"].ToString().Split(','); if (dtsaxxt.Rows.Count > 0) { for (int i = 0; i < dtsaxxt.Rows.Count; i++) { for (int j = 0; j < approlexxtarr.Length; j++) { if (dtsaxxt.Rows[i]["id"].ToString() == approlexxtarr[j].ToString()) { dtsaxxt.Rows[i]["checked"] = "true"; } } } } } sarxxttree = Newtonsoft.Json.JsonConvert.SerializeObject(dtsaxxt); #endregion //家校互通平台学段、科目教版 SchSystem.BLL.SchPerSubMatXXT spsmxxtBll = new SchSystem.BLL.SchPerSubMatXXT(); DataTable dtspsmxxt = spsmxxtBll.SchPerSubMatXXTV("SchId='" + schid + "' Order by convert(int,PerCode) asc").Tables[0]; showmaterxxttree = Newtonsoft.Json.JsonConvert.SerializeObject(dtspsmxxt); //获取学校的年级 SchSystem.BLL.SchGradeInfo schgradebll = new SchSystem.BLL.SchGradeInfo(); DataTable dtschgrade = schgradebll.GetList("GradeCode id,GradeYear,GradeId", "isfinish='0' and SchId='" + schid + "'").Tables[0]; dtgrade.Columns["nochecks"].ColumnName = "nocheck"; DataRow dry = dtgrade.NewRow(); dry["pId"] = "0"; dry["id"] = "1"; dry["name"] = "幼儿园"; dry["nocheck"] = "false"; dry["IsFinish"] = "0"; dtgrade.Rows.Add(dry); dry = dtgrade.NewRow(); dry["pId"] = "0"; dry["id"] = "2"; dry["name"] = "小学"; dry["nocheck"] = "false"; dry["IsFinish"] = "0"; dtgrade.Rows.Add(dry); dry = dtgrade.NewRow(); dry["pId"] = "0"; dry["id"] = "3"; dry["name"] = "初中"; dry["nocheck"] = "false"; dry["IsFinish"] = "0"; dtgrade.Rows.Add(dry); dry = dtgrade.NewRow(); dry["pId"] = "0"; dry["id"] = "4"; dry["name"] = "高中"; dry["nocheck"] = "false"; dry["IsFinish"] = "0"; dtgrade.Rows.Add(dry); if (dtgrade != null && dtschgrade != null && dtgrade.Rows.Count > 0 && dtschgrade.Rows.Count > 0) //系统年级和学校年级不等于null { for (int i = 0; i < dtgrade.Rows.Count; i++) //遍历实体年级行数 { DataRow[] drs = dtschgrade.Select("id='" + dtgrade.Rows[i]["id"].ToString() + "'"); //根据系统年级id查询学校年级 if (drs.Length > 0) { dtgrade.Rows[i]["checked"] = "true"; dtgrade.Rows[i]["GradeYear"] = drs[0]["GradeYear"]; dtgrade.Rows[i]["GradeId"] = drs[0]["GradeId"]; } } } //獲取畢業年級的年級名稱和入學年份 //DataTable dtres = schgradebll.GetListGradeFinish("GradeCode,GradeName,GradeYear", int.Parse(schid), int.Parse(CurrentYear)).Tables[0]; DataTable dtres = schgradebll.Graduated(int.Parse(schid)).Tables[0]; updateGrade = Newtonsoft.Json.JsonConvert.SerializeObject(dtres); //获取服务资源:AutoId,AppCode,AppName,Stat,RecTime,RecUser,LastRecTime,LastRecUser #region 获取服务资源 SchSystem.BLL.SchAppSoure schappsoureBll = new SchSystem.BLL.SchAppSoure(); DataTable dtschappsoure = schappsoureBll.GetList("'0' pId,AppCode id,AppName name,'false' checked,'false' isShar", "Stat=1").Tables[0]; SchSystem.BLL.SchAppRoleSoure sarsBll = new SchSystem.BLL.SchAppRoleSoure(); DataTable dtsars = sarsBll.GetList("SchId='" + schid + "'").Tables[0]; DataRow[] drsarsstr = dtsars.Select(); string[] approlesourearr = { }; if (drsarsstr.Length > 0) { approlesourearr = drsarsstr[0]["AppCode"].ToString().Split('|'); } if (dtschappsoure.Rows.Count > 0) { for (int i = 0; i < dtschappsoure.Rows.Count; i++) { //dtschappsoure.Rows[i]["name"] = dtschappsoure.Rows[i]["name"] + "【不共享】"; for (int j = 0; j < approlesourearr.Length; j++) { if (approlesourearr[j].Split(',').Length > 1) { string appsourestr = approlesourearr[j].Split(',')[0]; string appsourestat = approlesourearr[j].Split(',')[1]; if (dtschappsoure.Rows[i]["id"].ToString() == appsourestr) { if (appsourestat == "1") { dtschappsoure.Rows[i]["name"] = dtschappsoure.Rows[i]["name"] + "【共享】"; //dtschappsoure.Rows[i]["isShar"] = "true"; } else if (appsourestat == "0") { dtschappsoure.Rows[i]["name"] = dtschappsoure.Rows[i]["name"] + "【不共享】"; //dtschappsoure.Rows[i]["isShar"] = "false"; } dtschappsoure.Rows[i]["checked"] = "true"; } } } if (dtschappsoure.Rows[i]["checked"].ToString() == "false") { dtschappsoure.Rows[i]["name"] = dtschappsoure.Rows[i]["name"] + "【不共享】"; //dtschappsoure.Rows[i]["isShar"] = "false"; } } } souretree = Newtonsoft.Json.JsonConvert.SerializeObject(dtschappsoure); #endregion //获取教版 SchSystem.BLL.SysMater smaterBll = new SchSystem.BLL.SysMater(); DataTable dtsmater = smaterBll.GetList("'0' pId,MaterCode id,MaterName name,'false' checked,'' subcodechk,MaterCode,'' PerCode,'' SubCode,'' SubName", "Stat=1").Tables[0]; SchSystem.BLL.SchPerSubMat spsmBll = new SchSystem.BLL.SchPerSubMat(); DataTable dtspsm = spsmBll.SchPerSubMatVMatSub("SchId='" + schid + "' Order by convert(int,PerCode) asc").Tables[0]; //if (dtsmater.Rows.Count > 0) //{ // for (int i = 0; i < dtsmater.Rows.Count; i++) // { // foreach (DataRow dr in dtspsm.Rows) // { // string ss = dtsmater.Rows[i]["MaterCode"].ToString(); // string sss = dr["MaterCode"].ToString(); // if (dtsmater.Rows[i]["MaterCode"].ToString() == dr["MaterCode"].ToString()) // { // dtsmater.Rows[i]["checked"] = "true"; // dtsmater.Rows[i]["PerCode"] = dr["PerCode"]; // dtsmater.Rows[i]["SubCode"] = dr["SubCode"]; // dtsmater.Rows[i]["SubName"] = dr["SubName"]; // } // } // } //} sysmatertree = Newtonsoft.Json.JsonConvert.SerializeObject(dtsmater); showmatertree = Newtonsoft.Json.JsonConvert.SerializeObject(dtspsm); grades = Newtonsoft.Json.JsonConvert.SerializeObject(dtgrade); //获取下拉列表 StringBuilder sbarea = new StringBuilder(); string[] areanames = Com.Public.GetArea(usermodel.AreaNo.ToString()).Split('|'); sbarea.Append(areanames[0]); sbarea.Append(areanames[1]); sbarea.Append(areanames[2]); areastr = sbarea.ToString(); } } }
public static Com.DataPack.DataRsp <string> page(string PageIndex, string PageSize, string txtname, string ustat, string cotycode, string schname, string aprovserch, string acityserch) { Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>(); if (Com.Session.userid == null) { rsp.code = "expire"; rsp.msg = "页面已经过期,请重新登录"; } else { try { SchSystem.BLL.SchInfo userbll = new SchSystem.BLL.SchInfo(); //Stat:0废弃,1正常,2被删除,正常界面不显示删除,超管界面可以考虑 string strwhere = "Stat<2 "; if (!string.IsNullOrEmpty(cotycode)) { strwhere += " and AreaNo = '" + Com.Public.SqlEncStr(cotycode) + "'"; } if (!string.IsNullOrEmpty(aprovserch)) { strwhere += " and left(AreaNo,2) = '" + Com.Public.SqlEncStr(aprovserch.Substring(0, 2)) + "'"; } if (!string.IsNullOrEmpty(acityserch)) { strwhere += " and left(AreaNo,4) = '" + Com.Public.SqlEncStr(acityserch.Substring(0, 4)) + "'"; } if (!string.IsNullOrEmpty(schname)) { strwhere += " and SchName like '%" + Com.Public.SqlEncStr(schname) + "%'"; } if (!string.IsNullOrEmpty(txtname)) { strwhere += " and SchId = '" + Com.Public.SqlEncStr(txtname) + "'"; } if (!string.IsNullOrEmpty(ustat)) { strwhere += " and SonSysStat=" + Com.Public.SqlEncStr(ustat); } Com.Public.PageModelResp pages = new Com.Public.PageModelResp(); pages.PageIndex = int.Parse(PageIndex); pages.PageSize = int.Parse(PageSize); int rowc = 0; int pc = 0; string dbcols = "SchId,SchName,PlatformName,PlatformUrl,PlatformIco,PlatformIP,SchMaster,SchoolSection,ServiceName,Artisan,SchCreator,RecTime,Stat,iscity,SonSysStat,SourceSerStat,AreaNo"; DataTable dt = userbll.GetListCols(dbcols, strwhere, "SchName", "ASC", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0]; pages.PageCount = pc; pages.RowCount = rowc; string currentYear = ""; if (DateTime.Now.Month < 8) { currentYear = (DateTime.Now.Year - 1).ToString(); } else { currentYear = DateTime.Now.Year.ToString(); } if (dt.Rows.Count > 0) { dt.Columns.Add("SHENG"); dt.Columns.Add("SHI"); dt.Columns.Add("QU"); dt.Columns.Add("graduated"); dt.Columns.Add("AppSonSys"); dt.Columns.Add("SchSubNames"); for (int i = 0; i < dt.Rows.Count; i++) { string[] areanames = Com.Public.GetArea(dt.Rows[i]["AreaNo"].ToString()).Split('|'); dt.Rows[i]["SHENG"] = areanames[0]; dt.Rows[i]["SHI"] = areanames[1]; dt.Rows[i]["QU"] = areanames[2]; //查询最近毕业年级 SchSystem.BLL.SchGradeInfo sgibll = new SchSystem.BLL.SchGradeInfo(); //dt.Rows[i]["graduated"] = sgibll.GetGradedYear("SchId=" + dt.Rows[i]["SchId"].ToString() + " and IsFinish=1"); string gradecurrent = " and isfinish=1 and ((left(GradeCode,1)='4' and " + currentYear + "-GradeYear=3) or (left(GradeCode,1)='3' and " + currentYear + "-GradeYear=3) or (left(GradeCode,1)='2' and " + currentYear + "-GradeYear=6) or (left(GradeCode,1)='1' and " + currentYear + "-GradeYear=5))"; dt.Rows[i]["graduated"] = sgibll.GetGradedYear("SchId=" + dt.Rows[i]["SchId"].ToString() + gradecurrent); // //查询应用子系统 SchSystem.BLL.SchAppRole sarBll = new SchSystem.BLL.SchAppRole(); DataTable dtsars = sarBll.GetList("SchId='" + dt.Rows[i]["SchId"].ToString() + "'").Tables[0]; StringBuilder sbsars = new StringBuilder(); if (dtsars.Rows.Count > 0) { string sarsarr = dtsars.Rows[0]["AppStr"].ToString(); SchSystem.BLL.SchApp saBll = new SchSystem.BLL.SchApp(); StringBuilder sbsas = new StringBuilder(); DataTable dtsas = saBll.GetList("AppName", "AppCode in (" + sarsarr + ")").Tables[0]; if (dtsas.Rows.Count > 0) { foreach (DataRow drsas in dtsas.Rows) { sbsas.Append(drsas["AppName"] + ","); } //sbsas.ToString().Substring(0, sbsas.ToString().Length - 1); dt.Rows[i]["AppSonSys"] = sbsas.ToString().Substring(0, sbsas.ToString().Length - 1); } } //查询科目 SchSystem.BLL.SchSub ssBll = new SchSystem.BLL.SchSub(); dt.Rows[i]["SchSubNames"] = ssBll.GetSubNames("Stat=1 and SchId='" + dt.Rows[i]["SchId"].ToString() + "'"); } pages.list = dt; } rsp.data = Newtonsoft.Json.JsonConvert.SerializeObject(pages); } catch (Exception ex) { rsp.code = "error"; rsp.msg = ex.Message; } } return(rsp); }
public static Com.DataPack.DataRsp <string> page(string PageIndex, string PageSize, string txtname, string ustat, string cotycode, string schid, string aprovserch, string acityserch, string txtschid, string gradelv, string isfinish) { Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>(); if (Com.Session.userid == null) { rsp.code = "expire"; rsp.msg = "页面已经过期,请重新登录"; } else { if (schid == "") { schid = "0"; } //Stat:0废弃,1正常,2被删除,正常界面不显示删除,超管界面可以考虑 string strwhere = "Stat<2 "; if (!string.IsNullOrEmpty(cotycode)) { strwhere += " and AreaNo = '" + Com.Public.SqlEncStr(cotycode) + "'"; } if (!string.IsNullOrEmpty(aprovserch)) { strwhere += " and left(AreaNo,2)= '" + Com.Public.SqlEncStr(aprovserch.Substring(0, 2)) + "'"; } if (!string.IsNullOrEmpty(acityserch)) { strwhere += " and left(AreaNo,4)= '" + Com.Public.SqlEncStr(acityserch.Substring(0, 4)) + "'"; } if (!string.IsNullOrEmpty(txtschid)) { strwhere += " and SchId = " + int.Parse(Com.Public.SqlEncStr(txtschid)); } else { if (schid != "0") { strwhere += " and SchId = '" + Com.Public.SqlEncStr(schid) + "'"; } } if (!string.IsNullOrEmpty(txtname)) { strwhere += " and SchName like '%" + Com.Public.SqlEncStr(txtname) + "%'"; } if (!string.IsNullOrEmpty(ustat)) { strwhere += " and SonSysStat=" + Com.Public.SqlEncStr(ustat); } string currentYear = ""; if (DateTime.Now.Month < 8) { currentYear = (DateTime.Now.Year - 1).ToString(); } else { currentYear = DateTime.Now.Year.ToString(); } if (!string.IsNullOrEmpty(gradelv)) //选择了学段 { if (!string.IsNullOrEmpty(isfinish)) //并且选择了是否有毕业班需要升级 { string yearlv = "0"; if (gradelv == "1") { yearlv = "4"; } else if (gradelv == "2") { yearlv = "5"; } else if (gradelv == "3") { yearlv = "3"; } else if (gradelv == "4") { yearlv = "3"; } if (isfinish == "0")//无毕业班,需要剔除有该学段毕业班学校 { strwhere += " and schid not in (select schid from SchGradeInfo where isfinish=0 and left(GradeCode,1)='" + Com.Public.SqlEncStr(gradelv) + "' and " + currentYear + "-GradeYear>" + yearlv + ")"; } else//有毕业班,含有该学段且有毕业班的学校 { strwhere += " and schid in (select schid from SchGradeInfo where isfinish=0 and left(GradeCode,1)='" + Com.Public.SqlEncStr(gradelv) + "' and " + currentYear + "-GradeYear>" + yearlv + ")"; } } else//仅选择了学段,则选择有该学段的学校 { strwhere += " and schid in (select schid from SchGradeInfo where isfinish=0 and left(GradeCode,1)='" + Com.Public.SqlEncStr(gradelv) + "')"; } } else { if (!string.IsNullOrEmpty(isfinish)) { if (isfinish == "0")//无毕业班,需要剔除含有毕业班学校 { strwhere += " and schid not in (select schid from SchGradeInfo where (isfinish=0 or isfinish=2) and ((left(GradeCode,1)='4' and " + currentYear + "-GradeYear>3) or (left(GradeCode,1)='3' and " + currentYear + "-GradeYear>3) or (left(GradeCode,1)='2' and " + currentYear + "-GradeYear>5) or (left(GradeCode,1)='1' and " + currentYear + "-GradeYear>4)))"; } else//有毕业班,含有毕业班的学校 { strwhere += " and schid in (select schid from SchGradeInfo where (isfinish=0 or isfinish=2) and ((left(GradeCode,1)='4' and " + currentYear + "-GradeYear>3) or (left(GradeCode,1)='3' and " + currentYear + "-GradeYear>3) or (left(GradeCode,1)='2' and " + currentYear + "-GradeYear>5) or (left(GradeCode,1)='1' and " + currentYear + "-GradeYear>4)))"; } } } //isfinish=0 and SchId=@SchId and ((left(GradeCode,1)='4' and @GradeYear-GradeYear>3) or (left(GradeCode,1)='3' and @GradeYear-GradeYear>3) or (left(GradeCode,1)='2' and @GradeYear-GradeYear>5) or (left(GradeCode,1)='1' and @GradeYear-GradeYear>4)) Com.Public.PageModelResp pages = new Com.Public.PageModelResp(); pages.PageIndex = int.Parse(PageIndex); pages.PageSize = int.Parse(PageSize); int rowc = 0; int pc = 0; try { SchSystem.BLL.SchInfo userbll = new SchSystem.BLL.SchInfo(); //查询最近毕业年级 SchSystem.BLL.SchGradeInfo sgibll = new SchSystem.BLL.SchGradeInfo(); SchSystem.BLL.SchApp saBll = new SchSystem.BLL.SchApp(); string dbcols = "SchId,SchName,PlatformIP,SchoolSection,SonSysStat,RecTime,SchSonSysEnableTime,SchSonSysEndDateTime,AreaNo,Stat,PlatformUrl";//,PlatformIco,SchMaster,ServiceName,Artisan,SchCreator,iscity DataTable dt = userbll.GetListCols(dbcols, strwhere, "SchName", "Asc", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0]; pages.PageCount = pc; pages.RowCount = rowc; if (dt.Rows.Count > 0) { dt.Columns.Add("IsUpgrade"); dt.Columns.Add("SHENG"); dt.Columns.Add("SHI"); dt.Columns.Add("QU"); dt.Columns.Add("SchoolSections"); dt.Columns.Add("graduated"); dt.Columns.Add("AppSonSys"); for (int i = 0; i < dt.Rows.Count; i++) { string[] areanames = Com.Public.GetArea(dt.Rows[i]["AreaNo"].ToString()).Split('|'); dt.Rows[i]["SHENG"] = areanames[0]; dt.Rows[i]["SHI"] = areanames[1]; dt.Rows[i]["QU"] = areanames[2]; StringBuilder sbstr = new StringBuilder(); string ss = dt.Rows[i]["SchoolSection"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[i]["SchoolSection"].ToString())) { string[] str = dt.Rows[i]["SchoolSection"].ToString().Split(','); for (int j = 0; j < str.Length; j++) { if (str[j] == "1") { sbstr.Append("幼儿园,"); } else if (str[j] == "2") { sbstr.Append("小学,"); } else if (str[j] == "3") { sbstr.Append("初中,"); } else if (str[j] == "4") { sbstr.Append("高中,"); } } if (sbstr.ToString() != "") { dt.Rows[i]["SchoolSections"] = sbstr.ToString().Substring(0, sbstr.ToString().Length - 1); } else { dt.Rows[i]["SchoolSections"] = ""; } } bool resBool = false; if (!string.IsNullOrEmpty(dt.Rows[i]["SchId"].ToString())) { resBool = sgibll.ExistsGradeFinish(int.Parse(dt.Rows[i]["SchId"].ToString()), int.Parse(currentYear)); } if (resBool) { dt.Rows[i]["IsUpgrade"] = "1"; } else { dt.Rows[i]["IsUpgrade"] = "0"; } string gradecurrent = " and isfinish=1 and ((left(GradeCode,1)='4' and " + currentYear + "-GradeYear=3) or (left(GradeCode,1)='3' and " + currentYear + "-GradeYear=3) or (left(GradeCode,1)='2' and " + currentYear + "-GradeYear=6) or (left(GradeCode,1)='1' and " + currentYear + "-GradeYear=5))"; dt.Rows[i]["graduated"] = sgibll.GetGradedYear("SchId=" + dt.Rows[i]["SchId"].ToString() + gradecurrent); //查询应用子系统 SchSystem.BLL.SchAppRole sarBll = new SchSystem.BLL.SchAppRole(); DataTable dtsars = sarBll.GetList("SchId='" + dt.Rows[i]["SchId"].ToString() + "'").Tables[0]; StringBuilder sbsars = new StringBuilder(); if (dtsars.Rows.Count > 0) { string sarsarr = dtsars.Rows[0]["AppStr"].ToString(); StringBuilder sbsas = new StringBuilder(); DataTable dtsas = saBll.GetList("AppName", "AppCode in (" + sarsarr + ")").Tables[0]; if (dtsas.Rows.Count > 0) { foreach (DataRow drsas in dtsas.Rows) { sbsas.Append(drsas["AppName"] + ","); } dt.Rows[i]["AppSonSys"] = sbsas.ToString().Substring(0, sbsas.ToString().Length - 1); } } } pages.list = dt; } rsp.data = Newtonsoft.Json.JsonConvert.SerializeObject(pages); } catch (Exception ex) { rsp.code = "ExcepError"; rsp.msg = ex.Message; } } return(rsp); }
//获取学校系统管理或者普通应用菜单列表 public static DataTable SchMenuData(string cols, string thstr, string schid, string systype) { if (schid == "") { schid = Com.Session.schid; } //查询学校的子系统、资源服务模块状态 SchSystem.BLL.SchInfo siBll = new SchSystem.BLL.SchInfo(); DataTable dtschinfo = siBll.GetList("SonSysStat,SourceSerStat,HomeschServStat", "SchId='" + schid + "'").Tables[0]; string SonSysStat = dtschinfo.Rows[0]["SonSysStat"].ToString(); string SourceSerStat = dtschinfo.Rows[0]["SourceSerStat"].ToString(); string SourceXXTStat = dtschinfo.Rows[0]["HomeschServStat"].ToString(); DataTable dt = new DataTable(); SchSystem.BLL.SchAppRole schapprolebll = new SchSystem.BLL.SchAppRole(); string appstr = schapprolebll.GetAppStr(int.Parse(schid)); if (appstr != "") { appstr = " AppCode in (" + appstr + ")"; } //0普通前台通用菜单,1学校管理后台菜单 if (systype == "0") { string sqlstr = ""; //获取正常的 if (appstr == "") { sqlstr = " Stat=1 and (AppCode=1 or AppCode=2 " + thstr + ")"; } else { sqlstr = " Stat=1 and (AppCode=1 or AppCode=2 or " + appstr + " " + thstr + ")"; } //获取菜单表 SchSystem.BLL.SchMenuInfoUser menuuserbll = new SchSystem.BLL.SchMenuInfoUser(); dt = menuuserbll.GetList(cols, sqlstr + " order by OrderId ").Tables[0]; if (dt.Rows.Count > 0) { DataRow row = dt.NewRow(); row["id"] = 1; row["pId"] = 0; row["name"] = "首页"; dt.Rows.InsertAt(row, 0); } } else if (systype == "1") { string sqlstr = ""; //获取正常的 if (appstr == "") { sqlstr = " Stat=1 and (AppCode=0 or AppCode=1 or AppCode=2 " + thstr + ") "; } else { sqlstr = " Stat=1 and (AppCode=0 or AppCode=1 or AppCode=2 or " + appstr + "" + thstr + ") "; } if (SonSysStat == "0" || SonSysStat == "") //子系统状态为0时,不显示管理平台菜单 { sqlstr += " and FuncCode<>22 and Pid<> (select MenuId from SchMenuInfoAdmin where FuncCode=22) "; //id是MenuId的别名 } if (SourceSerStat == "0" || SourceSerStat == "") //资源服务状态为0时,不显示资源平台菜单 { sqlstr += " and FuncCode<>23 and Pid<> (select MenuId from SchMenuInfoAdmin where FuncCode=23) "; } if (SourceXXTStat == "0" || SourceXXTStat == "")//家校互通服务状态为0时,不显示资源平台菜单 { sqlstr += " and FuncCode<>29 and Pid<> (select MenuId from SchMenuInfoAdmin where FuncCode=29) "; } SchSystem.BLL.SchMenuInfoAdmin menuuserbll = new SchSystem.BLL.SchMenuInfoAdmin(); dt = menuuserbll.GetList(cols, sqlstr + " order by OrderId").Tables[0]; //if (SonSysStat == "0" || SonSysStat == "")//子系统状态为0时,不显示管理平台菜单 //{ // DataRow[] dr = dt.Select("FuncCode=22");//通过FuncCode查找管理平台MenuId // int Manageid = int.Parse(dr[0]["id"].ToString());//id是MenuId的别称 // dt = DataRowToDataTable(dt, "FuncCode<>22 and pId<>" + Manageid);//查找出不属于管理平台的菜单项,并转换为DataTable //} //if (SourceSerStat == "0" || SourceSerStat == "")//资源服务状态为0时,不显示资源平台菜单 //{ // DataRow[] dr = dt.Select("FuncCode=23");//通过FuncCode查找资源平台MenuId // int Sourceid = int.Parse(dr[0]["id"].ToString());//id是MenuId的别称 // dt = DataRowToDataTable(dt, "FuncCode<>23 and pId<>" + Sourceid);//查找出不属于资源平台的菜单项,并转换为DataTable //} //if (SourceXXTStat == "0" || SourceXXTStat == "")//家校互通服务状态为0时,不显示资源平台菜单 //{ // DataRow[] dr = dt.Select("FuncCode=29");//通过FuncCode查找家校互通平台MenuId // int XXTid = int.Parse(dr[0]["id"].ToString());//id是MenuId的别称 // dt = DataRowToDataTable(dt, "FuncCode<>29 and pId<>" + XXTid);//查找出不属于家校互通平台的菜单项,并转换为DataTable //} } else { //获取子系统 if (appstr != "") { string sqlstr = "Stat=1 and (" + appstr + ")"; SchSystem.BLL.SchApp schappbll = new SchSystem.BLL.SchApp(); dt = schappbll.GetList(cols, sqlstr).Tables[0]; } } return(dt); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { usertname = Com.Session.uname; //先得到操作类型 SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo(); SchSystem.Model.SchInfo usermodel = new SchSystem.Model.SchInfo(); SchSystem.BLL.SysSub syssubbll = new SchSystem.BLL.SysSub(); DataTable dtsub = syssubbll.GetList("'0' pId,SubCode id,SubName name,'false' checked", "Stat=1 Order by SubCode").Tables[0];//Stat=1 DataTable dtsubmat = dtsub.Copy(); //获取学校的sub SchSystem.BLL.SchSub schsubbll = new SchSystem.BLL.SchSub(); DataTable dtschsub = schsubbll.GetList("'0' pId,SubCode id,SubName name,'false' checked", "Stat=1 and SchId='" + schid + "' Order by SubCode").Tables[0]; subs = Newtonsoft.Json.JsonConvert.SerializeObject(dtsub); subsmat = Newtonsoft.Json.JsonConvert.SerializeObject(dtsubmat); treeNodekinderstr = Newtonsoft.Json.JsonConvert.SerializeObject(dtschsub); //获取子系统:AutoId,AppCode,AppName,Stat,RecTime,RecUser,LastRecTime,LastRecUser SchSystem.BLL.SchApp schappBll = new SchSystem.BLL.SchApp(); DataTable dtschapp = schappBll.GetList("'0' pId,AppCode id,AppName name,'false' checked,AppCode", "Stat=1 and AppCode not in (1,2)").Tables[0]; sonsys = Newtonsoft.Json.JsonConvert.SerializeObject(dtschapp); //获取整个系统的年级 SchSystem.BLL.SysGrade sysgradebll = new SchSystem.BLL.SysGrade(); DataTable dtgrade = sysgradebll.GetList("GradeType pId,GradeCode id,GradeName name,'false' checked,'false' nochecks,'0' IsFinish", " GradeCode<>'3004' and GradeCode<>'4004' Order by GradeType,GradeLv").Tables[0]; //获取学校类型 SchSystem.BLL.SysPer sysperbll = new SchSystem.BLL.SysPer(); DataTable dtper = sysperbll.GetList("PerName Name,PerCode ID", " Stat=1 Order by convert(int,PerCode)").Tables[0]; if (dtper.Rows.Count > 0) { StringBuilder sb = new StringBuilder(); for (int i = 0; i < dtper.Rows.Count; i++) { if (dtper.Rows[i]["ID"].ToString() == percode) { sb.Append("<option value=\"" + dtper.Rows[i]["ID"].ToString() + "\" selected=\"selected\">" + dtper.Rows[i]["Name"].ToString() + "</option>"); } else { sb.Append("<option value=\"" + dtper.Rows[i]["ID"].ToString() + "\">" + dtper.Rows[i]["Name"].ToString() + "</option>"); } //} } percodes = sb.ToString(); } dtgrade.Columns["nochecks"].ColumnName = "nocheck"; DataRow dry = dtgrade.NewRow(); dry["pId"] = "0"; dry["id"] = "1"; dry["name"] = "幼儿园"; dry["nocheck"] = "false"; dry["IsFinish"] = "0"; dtgrade.Rows.Add(dry); dry = dtgrade.NewRow(); dry["pId"] = "0"; dry["id"] = "2"; dry["name"] = "小学"; dry["nocheck"] = "false"; dry["IsFinish"] = "0"; dtgrade.Rows.Add(dry); dry = dtgrade.NewRow(); dry["pId"] = "0"; dry["id"] = "3"; dry["name"] = "初中"; dry["nocheck"] = "false"; dry["IsFinish"] = "0"; dtgrade.Rows.Add(dry); dry = dtgrade.NewRow(); dry["pId"] = "0"; dry["id"] = "4"; dry["name"] = "高中"; dry["nocheck"] = "false"; dry["IsFinish"] = "0"; dtgrade.Rows.Add(dry); //if (dtgrade != null && dtschgrade != null && dtgrade.Rows.Count > 0 && dtschgrade.Rows.Count > 0)//系统年级和学校年级不等于null //{ // for (int i = 0; i < dtgrade.Rows.Count; i++)//遍历实体年级行数 // { // DataRow[] drs = dtschgrade.Select("id='" + dtgrade.Rows[i]["id"].ToString() + "'");//根据系统年级id查询学校年级 // if (drs.Length > 0) // { // //string ss = drs[0]["id"].ToString(); // //dtgrade.Rows[i]["checked"] = "true"; // //DataRow[] drss = dtgrade.Select("id='"+ss+"'"); // //int ss = int.Parse(drss["pId"].ToString()); // } // } //} grades = Newtonsoft.Json.JsonConvert.SerializeObject(dtgrade); //获取资源平台服务资源:AutoId,AppCode,AppName,Stat,RecTime,RecUser,LastRecTime,LastRecUser SchSystem.BLL.SchAppSoure schappsoureBll = new SchSystem.BLL.SchAppSoure(); DataTable dtschappsoure = schappsoureBll.GetList("'0' pId,AppCode id,AppName name,'false' checked,AppCode", "Stat=1").Tables[0]; if (dtschappsoure.Rows.Count > 0) { for (int i = 0; i < dtschappsoure.Rows.Count; i++) { dtschappsoure.Rows[i]["name"] = dtschappsoure.Rows[i]["name"] + "【不共享】"; } } souretree = Newtonsoft.Json.JsonConvert.SerializeObject(dtschappsoure); //获取教版 SchSystem.BLL.SysMater smaterBll = new SchSystem.BLL.SysMater(); DataTable dtsmater = smaterBll.GetList("'0' pId,AutoId id,MaterName name,'false' checked,MaterCode", "Stat=1").Tables[0]; sysmatertree = Newtonsoft.Json.JsonConvert.SerializeObject(dtsmater); //获取家校互通服务资源:AutoId,AppCode,AppName,Stat,RecTime,RecUser,LastRecTime,LastRecUser SchSystem.BLL.SchAppXXT schappxxtBll = new SchSystem.BLL.SchAppXXT(); DataTable dtschappxxt = schappxxtBll.GetList("'0' pId,AppCode id,AppName name,'false' checked,AppCode", "Stat=1").Tables[0]; //if (dtschappsoure.Rows.Count > 0) //{ // for (int i = 0; i < dtschappsoure.Rows.Count; i++) // { // dtschappsoure.Rows[i]["name"] = dtschappsoure.Rows[i]["name"] + "【不共享】"; // } //} homeschtree = Newtonsoft.Json.JsonConvert.SerializeObject(dtschappxxt); //获取下拉列表 StringBuilder sbarea = new StringBuilder(); //获取省份 sbarea.Append("<select id=\"aprov\">"); string sareacode = ""; if (usermodel != null && usermodel.SchId > 0 && usermodel.AreaNo.Length == 6) { sareacode = usermodel.AreaNo.Substring(0, 2) + "0000"; } sbarea.Append(SchWebAdmin.Com.Public.GetDrpArea("0", "", ref sareacode, false)); sbarea.Append("</select>"); //获取城市 sbarea.Append("<select id=\"acity\">"); string sareacitycode = ""; if (usermodel != null && usermodel.SchId > 0 && usermodel.AreaNo.Length == 6) { sareacitycode = usermodel.AreaNo.Substring(0, 4) + "00"; } sbarea.Append(SchWebAdmin.Com.Public.GetDrpArea("1", sareacode, ref sareacitycode, false)); sbarea.Append("</select>"); //获取区县 sbarea.Append("<select id=\"acoty\">"); string sareacotycode = ""; if (usermodel != null && usermodel.SchId > 0 && usermodel.AreaNo.Length == 6) { sareacotycode = usermodel.AreaNo; } sbarea.Append(SchWebAdmin.Com.Public.GetDrpArea("2", sareacitycode, ref sareacotycode, false)); sbarea.Append("</select>"); areastr = sbarea.ToString(); //根据部门分类查询人员信息 //当前学校老师 SchSystem.BLL.SchUserDeptV userbll = new SchSystem.BLL.SchUserDeptV(); DataTable dtuser = userbll.GetList("DeptId,DepartName,UserId,UserTname", "Stat=1 and Ustat=1 and SchId=" + Com.Public.SqlEncStr(schid)).Tables[0]; SchSystem.BLL.SchDepartInfo dptbll = new SchSystem.BLL.SchDepartInfo(); DataTable dt = dptbll.GetList("Pid pId,convert(varchar(20),DepartId) id,DepartName name,'0' isms,'' subcode,'false' checked,'true' nochecks", "SchId=" + schid + " and Stat=1 Order by OrderId,DepartName").Tables[0]; DataTable dtdptuser = dt.Clone(); dtdptuser.Columns["nochecks"].ColumnName = "nocheck"; if (dt.Rows.Count > 0) { //合并人员到部门表 for (int i = 0; i < dt.Rows.Count; i++) { dtdptuser.Rows.Add(dt.Rows[i].ItemArray); //获取该部门下的人员 DataRow[] drss = dtuser.Select("DeptId='" + dt.Rows[i]["id"].ToString() + "'"); if (drss.Length > 0) { foreach (DataRow item in drss) { DataRow dr = dtdptuser.NewRow(); dr["id"] = item["UserId"].ToString(); dr["name"] = item["UserTname"].ToString(); dr["pId"] = item["DeptId"].ToString(); if (dr["name"].ToString() == usermodel.Artisan.ToString()) { dr["checked"] = true; } dtdptuser.Rows.Add(dr); } } } } deptsuser = Newtonsoft.Json.JsonConvert.SerializeObject(dtdptuser); } }