Пример #1
0
        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)
        {
            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();
                    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))
                    {
                        if (ustat == "1")
                        {
                            strwhere += " and schid in (select schid from SchAppRoleSoure where AppCode+'|' like '%,1|%')";
                        }
                        else
                        {
                            strwhere += " and schid not in (select schid from SchAppRoleSoure where AppCode+'|' like '%,1|%')";
                        }
                    }
                    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,ResourcePlatformName,ResourcePlatformUrl,ResourcePlatformIco,ResourcePlatformIP,SourceSerStat,SchoolSection,RecTime,SchSonSysEnableTime,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;
                    if (dt.Rows.Count > 0)
                    {
                        dt.Columns.Add("UsharStat");
                        dt.Columns.Add("SoureName");
                        dt.Columns.Add("SHENG");
                        dt.Columns.Add("SHI");
                        dt.Columns.Add("QU");
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            SchSystem.BLL.SchAppRoleSoure sarsBll = new SchSystem.BLL.SchAppRoleSoure();
                            DataTable dtsars = sarsBll.GetList("SchId='" + dt.Rows[i]["SchId"].ToString() + "'").Tables[0];
                            if (dtsars.Rows.Count > 0)
                            {
                                string[]      sarsAppCodearr = dtsars.Rows[0]["AppCode"].ToString().Split('|');
                                StringBuilder sarsAppCodesb  = new StringBuilder();
                                for (int j = 0; j < sarsAppCodearr.Length; j++)
                                {
                                    sarsAppCodesb.Append(sarsAppCodearr[j].Split(',')[0] + ",");
                                }
                                StringBuilder sasSoureName = new StringBuilder();
                                if (dtsars.Rows[0]["AppCode"].ToString().Length > (dtsars.Rows[0]["AppCode"].ToString() + "|").Replace(",1|", "").Length)
                                {
                                    dt.Rows[i]["UsharStat"] = "有";
                                }
                                else
                                {
                                    dt.Rows[i]["UsharStat"] = "无";
                                }
                                SchSystem.BLL.SchAppSoure sasBll = new SchSystem.BLL.SchAppSoure();
                                try
                                {
                                    DataTable dtsas = sasBll.GetList("AppName", "AppCode in (" + sarsAppCodesb.ToString().Substring(0, sarsAppCodesb.ToString().Length - 1) + ")").Tables[0];//在SchAppSoure表中查询资源模块

                                    if (dtsas.Rows.Count > 0)
                                    {
                                        foreach (DataRow dr in dtsas.Rows)
                                        {
                                            sasSoureName.Append(dr["AppName"] + ",");//拼接已有资源模块的名称
                                        }
                                    }
                                }
                                catch (Exception e) { }

                                dt.Rows[i]["SoureName"] = sasSoureName.ToString();
                            }
                            else
                            {
                                dt.Rows[i]["UsharStat"] = "";
                                dt.Rows[i]["SoureName"] = "";
                            }
                            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];
                        }
                        pages.list = dt;
                    }
                    rsp.data = Newtonsoft.Json.JsonConvert.SerializeObject(pages).Replace("\n\r", "");
                }
                catch (Exception ex)
                {
                    rsp.code = "error";
                    rsp.msg  = ex.Message;
                }
            }
            return(rsp);
        }
Пример #2
0
        public string umodelsarstr = "1"; //学校资源模块
        protected void Page_Load(object sender, EventArgs e)
        {
            //先得到操作类型
            SchSystem.BLL.SchInfo   schbll    = new SchSystem.BLL.SchInfo();
            SchSystem.Model.SchInfo usermodel = new SchSystem.Model.SchInfo();
            dotype = Request.Params["dotype"].ToString();
            if (dotype == "e")//修改,不能修改用户的类型及学校参数
            {
                schid = Request.Params["schid"].ToString();
                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);

                    //
                    SchSystem.BLL.SchAppSoure sasBll = new SchSystem.BLL.SchAppSoure();
                    DataTable dtsar = sasBll.GetList("AppCode,AppName,'false' checked", "Stat=1").Tables[0];

                    if (dtsar.Rows.Count > 0)
                    {
                        dtsar.Columns.Add("UsharStat");
                        for (int j = 0; j < dtsar.Rows.Count; j++)
                        {
                            SchSystem.BLL.SchAppRoleSoure sarsBll = new SchSystem.BLL.SchAppRoleSoure();
                            DataTable dtsars = sarsBll.GetList("SchId='" + schid + "'").Tables[0];
                            if (dtsars.Rows.Count > 0)
                            {
                                string[] sarsarr = dtsars.Rows[0]["AppCode"].ToString().Split('|');
                                for (int i = 0; i < sarsarr.Length; i++)
                                {
                                    int len = sarsarr[i].Split(',').Length;
                                    if (len > 1)
                                    {
                                        string issharstr = sarsarr[i].Split(',')[0];
                                        string isshar    = sarsarr[i].Split(',')[1];
                                        //string sss = dtsar.Rows[j]["AppCode"].ToString();
                                        if (isshar == "1" && issharstr == dtsar.Rows[j]["AppCode"].ToString())
                                        {
                                            dtsar.Rows[j]["UsharStat"] = isshar;
                                            dtsar.Rows[j]["checked"]   = "true";
                                        }
                                        else if (dtsar.Rows[j]["AppCode"].ToString() == issharstr)
                                        {
                                            dtsar.Rows[j]["checked"] = "true";
                                        }
                                    }
                                }
                            }
                        }
                    }
                    umodelsarstr = Newtonsoft.Json.JsonConvert.SerializeObject(dtsar);
                    //
                }
                else
                {
                    Response.Write("无该学校!");
                    Response.End();
                }
            }
            else//不在添加及修改之内,则返回
            {
                Response.Write("没有可供确认的操作类型!");
                Response.End();
            }
        }
        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();
                }
            }
        }
Пример #4
0
        public static Com.DataPack.DataRsp <string> page(string PageIndex, string PageSize, string txtname, string ustat, string cotycode, string aprovserch, string acityserch, string schname)
        {
            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 SourceSerStat=" + Com.Public.SqlEncStr(ustat);
                    }
                    string currentYear = "";
                    if (DateTime.Now.Month < 8)
                    {
                        currentYear = (DateTime.Now.Year - 1).ToString();
                    }
                    else
                    {
                        currentYear = DateTime.Now.Year.ToString();
                    }
                    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,ResourcePlatformName,ResourcePlatformUrl,ResourcePlatformIco,ResourcePlatformIP,SourceSerStat,SchMaster,SchoolSection,ServiceName,Artisan,SchCreator,RecTime,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;
                    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();
                            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.SchAppRoleSoure sarsBll = new SchSystem.BLL.SchAppRoleSoure();
                            DataTable     dtsars = sarsBll.GetList("AppCode", "SchId='" + dt.Rows[i]["SchId"].ToString() + "'").Tables[0];
                            StringBuilder sbsars = new StringBuilder();
                            if (dtsars.Rows.Count > 0)
                            {
                                foreach (DataRow dr in dtsars.Rows)
                                {
                                    string[] sarsarr = dr["AppCode"].ToString().Split('|');
                                    for (int s = 0; s < sarsarr.Length; s++)
                                    {
                                        sbsars.Append(sarsarr[s].Split(',')[0] + ",");
                                    }
                                }
                                string sarsitems = sbsars.ToString().Substring(0, sbsars.ToString().Length - 1);
                                SchSystem.BLL.SchAppSoure sasBll = new SchSystem.BLL.SchAppSoure();
                                StringBuilder             sbsas  = new StringBuilder();
                                if (!string.IsNullOrEmpty(sarsitems))
                                {
                                    DataTable dtsas = sasBll.GetList("AppName", "AppCode in (" + sarsitems + ")").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();
                                    }
                                }
                                else
                                {
                                    dt.Rows[i]["AppSonSys"] = "";
                                }
                            }
                            //查询科目
                            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);
        }