protected void Page_Load(object sender, EventArgs e)
{
SchSystem.BLL.SchGradeInfo schgradebll = new SchSystem.BLL.SchGradeInfo();
SchSystem.Model.SchGradeInfo schgrademodel = new SchSystem.Model.SchGradeInfo();
dotype = Request.Params["dotype"].ToString();
if (dotype == "e")//修改,不能修改用户的类型及学校参数
{
schid = Request.Params["schid"].ToString();
schname = Request.Params["schname"].ToString();
if (string.IsNullOrEmpty(schid))
{
Response.Write("无对应修改的记录!");
Response.End();
}
string CurrentYear = "";
//获取年份
if (DateTime.Now.Month < 8) //当当前日期在8月份之前
{
CurrentYear = (DateTime.Now.Year - 1).ToString(); //系统当前年份-1
}
else
{
CurrentYear = DateTime.Now.Year.ToString();//系统当前年份
}
//獲取畢業年級的年級名稱和入學年份
DataTable dtres = schgradebll.GetListGradeFinish("GradeCode,GradeName,GradeYear", int.Parse(schid), int.Parse(CurrentYear)).Tables[0];
updateGrade = Newtonsoft.Json.JsonConvert.SerializeObject(dtres);
}
else//不在添加及修改之内,则返回
{
Response.Write("没有可供确认的操作类型!");
Response.End();
}
}
public static Com.DataPack.DataRsp <string> schDatasave(List <string> arr)
{
int schid = 0;
Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>();
if (Com.Session.userid == null)
{
rsp.code = "expire";
rsp.msg = "页面已经过期，请重新登录";
}
else
{
SchSystem.BLL.SchGradeInfo schgradebll = new SchSystem.BLL.SchGradeInfo();
foreach (string str in arr)
{
string[] strarr = str.Split('#');
if (strarr[0] == "schid")
{
schid = int.Parse(strarr[1]);
}
}
schgradebll.SupportSysSchGradeAdd(schid);//添加年级
rsp.code = "Success";
rsp.msg = "升级成功";
}
return(rsp);
}
public static void GradeSubAdd(string selgrades, int schid)
{
if (selgrades != "")
{
SchSystem.BLL.SchGradeInfo gradebll = new SchSystem.BLL.SchGradeInfo();
SchSystem.Model.SchGradeInfo grademodel = new SchSystem.Model.SchGradeInfo();
string[] gradeIdsarr = selgrades.Split(',');
int gradeIdsLen = gradeIdsarr.Length;
for (int i = 0; i < gradeIdsLen; i++)
{
string[] graderowarr = gradeIdsarr[i].Split('|');
grademodel.GradeCode = graderowarr[0];
grademodel.GradeYear = graderowarr[1];
grademodel.GradeName = graderowarr[2];
grademodel.IsFinish = int.Parse(graderowarr[3]);
grademodel.SchId = schid;
grademodel.RecTime = DateTime.Now;
grademodel.RecUser = Com.Session.userid;
grademodel.LastRecTime = DateTime.Now;
gradebll.Add(grademodel);
}
}
}
//public string schclassinfo = "";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.Params["schid"] != null && Request.Params["schid"].ToString() != "")
{
schid = Com.Public.SqlEncStr(Request.Params["schid"].ToString());
}
//获取学校的科目
SchSystem.BLL.SchSub SchSubBll = new SchSystem.BLL.SchSub();
DataTable dtschsub = SchSubBll.GetList("SubName", "Stat=1 and SchId='" + schid + "' order by SubCode").Tables[0];
if (dtschsub.Rows.Count > 0)
{
StringBuilder sbSubName = new StringBuilder();
foreach (DataRow drSubName in dtschsub.Rows)
{
sbSubName.Append(drSubName["SubName"] + "、");
}
schsubname = sbSubName.ToString().Substring(0, sbSubName.Length - 1);
}
//获取学校年级
SchSystem.BLL.SchGradeInfo SchGradeBll = new SchSystem.BLL.SchGradeInfo();
DataTable dtschgrade = SchGradeBll.GetList("GradeId,GradeYear,GradeName", "IsFinish=0 and SchId='" + schid + "' Order by GradeCode").Tables[0];
schgradeinfo = Newtonsoft.Json.JsonConvert.SerializeObject(dtschgrade);
//获取学校班级
//SchSystem.BLL.SchClassInfo SchClassBll = new SchSystem.BLL.SchClassInfo();
//DataTable dtschclass = SchClassBll.GetList("ClassId,GradeId,ClassName", "IsFinish=0 and SchId='" + schid + "'").Tables[0];
//schclassinfo = Newtonsoft.Json.JsonConvert.SerializeObject(dtschclass);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["schid"] != null && Request.Params["schid"].ToString() != "")
{
schid = Com.Public.SqlEncStr(Request.Params["schid"].ToString());
//年级
SchSystem.BLL.SchGradeInfo sgiBLL = new SchSystem.BLL.SchGradeInfo();
DataTable dtSchGrade = sgiBLL.GetList(" IsFinish=0 and SchId='" + schid + "' order by GradeCode").Tables[0];//得到年级数据列表,并且是为非毕业的年级
//年级领导
SchSystem.BLL.SchGradeUsers sguBLL = new SchSystem.BLL.SchGradeUsers();
dtSchGrade.Columns.Add("GradeBoss");
if (dtSchGrade.Rows.Count > 0)
{
for (int i = 0; i < dtSchGrade.Rows.Count; i++)
{
dtSchGrade.Rows[i]["GradeBoss"] = sguBLL.GetNames("GradeId=" + dtSchGrade.Rows[i]["GradeId"].ToString());
}
}
grades = Newtonsoft.Json.JsonConvert.SerializeObject(dtSchGrade);
//当前学校所开设的科目
SchSystem.BLL.SchSub schsubBll = new SchSystem.BLL.SchSub();
DataSet dsSchSub = schsubBll.GetList("Stat=1 and SchId='" + schid + "'");
subs = Newtonsoft.Json.JsonConvert.SerializeObject(dsSchSub);
//获取科目教师
SchSystem.BLL.SchSubLeader scuBll = new SchSystem.BLL.SchSubLeader();
DataSet dssubUser = scuBll.GetListTecSub("*", "schid='" + schid + "' and Stat=1");
subUser = Newtonsoft.Json.JsonConvert.SerializeObject(dssubUser);
//subUser
//当前学校的教师
SchSystem.BLL.SchUserInfo suiBll = new SchSystem.BLL.SchUserInfo();
DataSet dsSUI = suiBll.GetList("*", "Stat=1 and SchId='" + schid + "'");
tecs = Newtonsoft.Json.JsonConvert.SerializeObject(dsSUI);
}
}
public static string getschgrade(string schid)
{
string ret = "";
//获取学校年级
SchSystem.BLL.SchGradeInfo SchGradeBll = new SchSystem.BLL.SchGradeInfo();
DataTable dtschgrade = SchGradeBll.GetList("GradeId,GradeYear,GradeName", "IsFinish=0 and SchId='" + schid + "'").Tables[0];
ret = Newtonsoft.Json.JsonConvert.SerializeObject(dtschgrade);
return(ret);
}
public static string getSearch(string schid, string gradecode, string subcode, string ustat)
{
schid = Com.Public.SqlEncStr(schid);
gradecode = Com.Public.SqlEncStr(gradecode);
subcode = Com.Public.SqlEncStr(subcode);
ustat = Com.Public.SqlEncStr(ustat);
string ret = "";
Com.DataPack.DataRsp <Com.DataPack.UserInfo> rsp = Com.Public.UserFuncSoure(Com.SoureSession.jsid, Com.SoureSession.jstoken);
if (rsp.code == "ERROR_TOKEN")
{
ret = "expire";
}
else
{
try
{
//年级
SchSystem.BLL.SchGradeInfo sgiBLL = new SchSystem.BLL.SchGradeInfo();
DataTable dtSchGrade = sgiBLL.GetList(" IsFinish=0 and SchId=" + schid + " order by GradeCode").Tables[0];//得到年级数据列表,并且是为非毕业的年级
//年级领导
SchSystem.BLL.SchGradeUsers sguBLL = new SchSystem.BLL.SchGradeUsers();
dtSchGrade.Columns.Add("GradeBoss");
if (dtSchGrade.Rows.Count > 0)
{
for (int i = 0; i < dtSchGrade.Rows.Count; i++)
{
dtSchGrade.Rows[i]["GradeBoss"] = sguBLL.GetNames("GradeId=" + dtSchGrade.Rows[i]["GradeId"].ToString());
}
}
//grades = Newtonsoft.Json.JsonConvert.SerializeObject(dtSchGrade);
//当前学校所开设的科目
SchSystem.BLL.SchSub schsubBll = new SchSystem.BLL.SchSub();
DataSet dsSchSub = schsubBll.GetList("Stat=1 and SchId=" + schid);
//subs = Newtonsoft.Json.JsonConvert.SerializeObject(dsSchSub);
//获取科目教师
SchSystem.BLL.SchSubLeader scuBll = new SchSystem.BLL.SchSubLeader();
DataSet dssubUser = scuBll.GetListTecSub("*", "schid='" + schid + "' and Stat=1");
//subUser = Newtonsoft.Json.JsonConvert.SerializeObject(dssubUser);
searchgradsub ds = new searchgradsub();
ds.grade = dtSchGrade;
ds.subs = dsSchSub;
ds.subtec = dssubUser;
ret = Newtonsoft.Json.JsonConvert.SerializeObject(ds);
}
catch (Exception ex)
{
ret = ex.Message;
}
}
return(ret);
}
public static string getschgrade(string schid)
{
string ret = "";
Com.DataPack.DataRsp <Com.DataPack.UserInfo> rsp = Com.Public.UserFuncSoure(Com.SoureSession.jsid, Com.SoureSession.jstoken);
if (rsp.code == "ERROR_TOKEN")
{
ret = "expire";
}
else
{
//获取学校年级
SchSystem.BLL.SchGradeInfo SchGradeBll = new SchSystem.BLL.SchGradeInfo();
DataTable dtschgrade = SchGradeBll.GetList("GradeId,GradeYear,GradeName", "IsFinish=0 and SchId='" + schid + "'").Tables[0];
ret = Newtonsoft.Json.JsonConvert.SerializeObject(dtschgrade);
}
return(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
SchId = Com.Session.schid;
//栏目初始化
SchSystem.BLL.WebSchChn SchChn = new SchSystem.BLL.WebSchChn();
DataTable dtSchChn = SchChn.GetList("ChnName,ChnCode", "Stat=1").Tables[0];
SchChnJsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dtSchChn);
//年级
SchSystem.BLL.SchGradeInfo schgrade = new SchSystem.BLL.SchGradeInfo();
DataTable dtSchGrade = schgrade.GetList("GradeName,GradeCode", "IsFinish=0 and SchId=" + SchId).Tables[0];
string GradeCode = dtSchGrade.Rows[0]["GradeCode"].ToString();
SchGradeJsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dtSchGrade);
//班级
SchSystem.BLL.SchClassInfo schclass = new SchSystem.BLL.SchClassInfo();
DataTable dtSchClass = schclass.GetList("ClassName,ClassId", "IsFinish=0 and GradeCode='" + GradeCode + "' and SchId='" + SchId + "'").Tables[0];
SchClassJsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dtSchClass);
}
protected void Page_Load(object sender, EventArgs e)
{
//
string newsid = Request.Params["newsid"].ToString();
SchSystem.BLL.WebSchChnNewsV bll = new SchSystem.BLL.WebSchChnNewsV();//
SchSystem.Model.WebSchChnNewsV model = bll.GetModel(int.Parse(newsid));
if (model != null)
{
newlv = model.Lv.ToString();
chnname = model.ChnName;
SchSystem.BLL.SchGradeInfo bllgrade = new SchSystem.BLL.SchGradeInfo();
gradename = bllgrade.GetName(model.GradeId);
SchSystem.BLL.SchClassInfo bllclass = new SchSystem.BLL.SchClassInfo();
classname = bllclass.GetName(model.ClassId);
content = model.Content;
isqur = model.IsQuo.ToString();
qurl = model.QuoUrl;
topic = model.Topic;
isrep = model.IsReply.ToString();
}
}
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 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();
SchSystem.BLL.SchGradeInfo schgradebll = new SchSystem.BLL.SchGradeInfo();
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(ustat))
{
if (ustat == "1")
{
strwhere += " and schid in (select schid from SchThdInfo)";
}
else
{
strwhere += " and schid not in (select schid from SchThdInfo)";
}
}
//"schid in (select schid from SchThdInfo)"
if (!string.IsNullOrEmpty(txtname))
{
strwhere += " and SchName like '%" + Com.Public.SqlEncStr(txtname) + "%'";
}
Com.Public.PageModelResp pages = new Com.Public.PageModelResp();
pages.PageIndex = int.Parse(PageIndex);
pages.PageSize = int.Parse(PageSize);
int rowc = 0; int pc = 0;
SchSystem.BLL.SchThdInfo thdbll = new SchSystem.BLL.SchThdInfo();
string clos = "SchId,SchName,AreaNo";
DataTable dt = userbll.GetListCols(clos, strwhere, "SchName", "", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0];
pages.PageCount = pc;
pages.RowCount = rowc;
if (dt.Rows.Count > 0)
{
dt.Columns.Add("Ustat");
dt.Columns.Add("SHENG");
dt.Columns.Add("SHI");
dt.Columns.Add("QU");
for (int i = 0; i < dt.Rows.Count; i++)
{
bool thdbool = thdbll.Exists(int.Parse(dt.Rows[i]["SchId"].ToString()));
if (thdbool)
{
dt.Rows[i]["Ustat"] = "有";
}
else
{
dt.Rows[i]["Ustat"] = "无";
}
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);
}
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)
{
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))
{
strwhere += " and Stat='1' 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();
}
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,PlatformIP,SchoolSection,SonSysStat,RecTime,SchSonSysEnableTime,SchSonSysEndDateTime,AreaNo,Stat,PlatformUrl,SonSysStat";
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("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();
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"] = "";
}
}
//查询最近毕业年级
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);
}
}
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
string jsid = Request.Params["sid"].ToString();
string jstoken = Request.Params["token"].ToString();
Com.SoureSession.jsid = jsid;
Com.SoureSession.jstoken = jstoken;
Com.DataPack.DataRsp <Com.DataPack.UserInfo> rsp = Com.Public.UserFuncSoure(jsid, jstoken);
if (rsp.code == "ERROR_TOKEN")
{
Response.Write("登录已失效!");
Response.End();
}
else if (!IsPostBack)
{
if (Com.SoureSession.Souresystype == "1" || Com.SoureSession.Souresystype == "2")//超级管理员和学校管理员
{
islook = true;
if (Com.SoureSession.Souresystype == "1")
{
isadd = false;
isedit = false;
isdel = false;
}
else
{
isadd = true;
isedit = true;
isdel = true;
}
}
else//普通老师
{
isadd = false;
isedit = false;
isdel = false;
islook = true;//学科/年级/班级任课权限
}
//isGradeClassAuth = Com.Public.IsUserVal(Com.Session.userrolestr, 2) ? true : false;//学科/年级/班级任课权限
//不是超管获取本学校的
if (Com.SoureSession.Souresystype != "2")
{
schid = Com.SoureSession.Soureschid;
}
else//超管还要加省市区学校下拉,后面需要更改
{
//第一次加载,获取省市区,获取第一个省份下的所有学校
StringBuilder sbarea = new StringBuilder();
//获取省份
sbarea.Append("省:<select id=\"aprov\">");
string sareacode = "";
sbarea.Append(Com.Public.GetDrpArea("0", "", ref sareacode, false));
sbarea.Append("</select>");
//获取城市
sbarea.Append("市:<select id=\"acity\">");
string sareacitycode = "";
sbarea.Append(Com.Public.GetDrpArea("1", sareacode, ref sareacitycode, false));
sbarea.Append("</select>");
//获取区县
sbarea.Append("区:<select id=\"acoty\">");
string sareacotycode = "";
sbarea.Append(Com.Public.GetDrpArea("2", sareacitycode, ref sareacotycode, false));
cotycode = sareacotycode;
sbarea.Append("</select>");
sbarea.Append("学校:<select id=\"asch\">");
string sareaschid = "";
sbarea.Append(Com.Public.GetDrpArea("3", sareacotycode, ref sareaschid, false));
if (sareaschid != "")
{
schid = sareaschid;
}
sbarea.Append("</select>");
areastr = sbarea.ToString();
systype = Com.SoureSession.Souresystype;
}
//当前学校年级:IsFinish状态，1代表已毕业；0代表未毕业
// SchSystem.BLL.SchGradeInfo sgiBll = new SchSystem.BLL.SchGradeInfo();
//DataSet dsSchGrade = sgiBll.GetList("IsFinish=0 and SchId=" + schid);
//年级
SchSystem.BLL.SchGradeInfo sgiBLL = new SchSystem.BLL.SchGradeInfo();
DataTable dtSchGrade = sgiBLL.GetList(" IsFinish=0 and SchId='" + schid + "' order by GradeCode").Tables[0];//得到年级数据列表,并且是为非毕业的年级
//年级领导
SchSystem.BLL.SchGradeUsers sguBLL = new SchSystem.BLL.SchGradeUsers();
dtSchGrade.Columns.Add("GradeBoss");
if (dtSchGrade.Rows.Count > 0)
{
for (int i = 0; i < dtSchGrade.Rows.Count; i++)
{
dtSchGrade.Rows[i]["GradeBoss"] = sguBLL.GetNames("GradeId=" + dtSchGrade.Rows[i]["GradeId"].ToString());
}
}
grades = Newtonsoft.Json.JsonConvert.SerializeObject(dtSchGrade);
//当前学校所开设的科目
SchSystem.BLL.SchSub schsubBll = new SchSystem.BLL.SchSub();
DataSet dsSchSub = schsubBll.GetList("Stat=1 and SchId='" + schid + "'");
subs = Newtonsoft.Json.JsonConvert.SerializeObject(dsSchSub);
//获取科目教师
SchSystem.BLL.SchSubLeader scuBll = new SchSystem.BLL.SchSubLeader();
DataSet dssubUser = scuBll.GetListTecSub("*", "schid='" + schid + "' and Stat=1");
subUser = Newtonsoft.Json.JsonConvert.SerializeObject(dssubUser);
//subUser
//当前学校的教师
SchSystem.BLL.SchUserInfo suiBll = new SchSystem.BLL.SchUserInfo();
DataSet dsSUI = suiBll.GetList("*", "Stat=1 and SchId='" + schid + "'");
tecs = Newtonsoft.Json.JsonConvert.SerializeObject(dsSUI);
}
}
protected void Page_Load(object sender, EventArgs e)
{
usertname = Com.Session.uname;
if (Com.Session.systype == "2")
{
returl = "<div class=\"nav-search\" id=\"nav-search\"><a class=\"btn btn-danger btn-sm pull-right\" href=\"javascript:window.history.go(-1);\"><i class=\"icon-reply icon-only\"></i></a></div>";
}
if (!IsPostBack)
{
if (Com.Session.systype != "2")
{
systype = Com.Session.systype;
}
//先得到操作类型
SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo();
SchSystem.Model.SchInfo usermodel = new SchSystem.Model.SchInfo();
dotype = Request.Params["dotype"].ToString();
if (dotype == "a")//添加
{
}
else if (dotype == "e")//修改,不能修改用户的类型及学校参数
{
btnname = "修改";
schid = Request.Params["schid"].ToString();
//判断跨界操作的可能性
if (!Com.Public.isVa(schid, ""))
{
Response.Write("出错,用户非法跨界操作!");
Response.End();
}
if (string.IsNullOrEmpty(schid))
{
Response.Write("无对应修改的记录!");
Response.End();
}
//获取修改的对应用户的
usermodel = schbll.GetModel(int.Parse(schid));
if (usermodel != null && usermodel.SchId > 0)
{
umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(usermodel);
}
else
{
Response.Write("无该学校!");
Response.End();
}
if (Com.Session.systype != "2")
{
btnname = "开始编辑";
}
}
else//不在添加及修改之内,则返回
{
Response.Write("没有可供确认的操作类型!");
Response.End();
}
if (!string.IsNullOrEmpty(schid))
{
//系统科目
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
//获取学校的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];
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);
schsubs = Newtonsoft.Json.JsonConvert.SerializeObject(dtschsub);
//获取整个系统的年级
SchSystem.BLL.SysGrade sysgradebll = new SchSystem.BLL.SysGrade();
DataTable dtgrade = sysgradebll.GetList("GradeType pId,GradeCode id,GradeName name,'false' checked,'false' nochecks", " 1=1 Order by GradeType,GradeLv").Tables[0];
//获取学校的sub
SchSystem.BLL.SchGradeInfo schgradebll = new SchSystem.BLL.SchGradeInfo();
DataTable dtschgrade = schgradebll.GetList("GradeCode id", "isfinish='0' and SchId='" + schid + "'").Tables[0];
if (dtgrade != null && dtschgrade != null && dtgrade.Rows.Count > 0 && dtschgrade.Rows.Count > 0)
{
for (int i = 0; i < dtgrade.Rows.Count; i++)
{
DataRow[] drs = dtschgrade.Select("id='" + dtgrade.Rows[i]["id"].ToString() + "'");
if (drs.Length > 0)
{
dtgrade.Rows[i]["checked"] = "true";
}
}
}
dtgrade.Columns["nochecks"].ColumnName = "nocheck";
DataRow dry = dtgrade.NewRow();
dry["pId"] = "0";
dry["id"] = "1";
dry["name"] = "幼儿园";
dry["nocheck"] = "false";
DataRow[] drs1 = dtgrade.Select("pId='1' and checked='false'");
if (drs1.Length == 0)
{
dry["checked"] = "true";
}
dtgrade.Rows.Add(dry);
dry = dtgrade.NewRow();
dry["pId"] = "0";
dry["id"] = "2";
dry["name"] = "小学";
dry["nocheck"] = "false";
DataRow[] drs2 = dtgrade.Select("pId='2' and checked='false'");
if (drs2.Length == 0)
{
dry["checked"] = "true";
}
dtgrade.Rows.Add(dry);
dry = dtgrade.NewRow();
dry["pId"] = "0";
dry["id"] = "3";
dry["name"] = "初中";
dry["nocheck"] = "false";
DataRow[] drs3 = dtgrade.Select("pId='3' and checked='false'");
if (drs3.Length == 0)
{
dry["checked"] = "true";
}
dtgrade.Rows.Add(dry);
dry = dtgrade.NewRow();
dry["pId"] = "0";
dry["id"] = "4";
dry["name"] = "高中";
dry["nocheck"] = "false";
DataRow[] drs4 = dtgrade.Select("pId='4' and checked='false'");
if (drs4.Length == 0)
{
dry["checked"] = "true";
}
dtgrade.Rows.Add(dry);
grades = Newtonsoft.Json.JsonConvert.SerializeObject(dtgrade);
//获取下拉列表
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(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(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(Com.Public.GetDrpArea("2", sareacitycode, ref sareacotycode, false));
sbarea.Append("</select>");
areastr = sbarea.ToString();
}
}
}
//需要根据不同情况建立或修改的不同学校用户和不同类型的用户,本学校用户唯一,不需要全系统唯一
protected void Page_Load(object sender, EventArgs e)
{
//if (true)//如果没对应权限,及判断用户类型是否跨界,主要防止非法篡改数据出现
//{
// Response.Write("无对应权限");
// Response.End();
//}
if (!IsPostBack)
{
//先得到操作类型
dotype = Com.Public.SqlEncStr(Request.Params["dotype"].ToString());
string gradeid = "0";//修改时的用户ID
string uname = "";//修改时的用户账号
if (dotype == "e")//修改,不能修改用户的类型及学校参数
{
btnname = "保存";
gradeid = Com.Public.SqlEncStr(Request.Params["gradeid"].ToString());
if (string.IsNullOrEmpty(gradeid))
{
Response.Write("无对应修改的用户!");
Response.End();
}
//获取修改的对应用户的
SchSystem.BLL.SchGradeInfo sgibll = new SchSystem.BLL.SchGradeInfo();
SchSystem.Model.SchGradeInfo sgimodel = sgibll.GetModel(int.Parse(gradeid));
if (sgimodel != null && sgimodel.GradeId > 0)
{
umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(sgimodel);
schid = sgimodel.SchId.ToString();
}
else
{
Response.Write("无该用户!");
Response.End();
}
}
else//不在添加及修改之内,则返回
{
Response.Write("没有可供确认的操作类型!");
Response.End();
}
//判断跨界操作的可能性
if (!Com.Public.isVa(schid, systype))
{
Response.Write("出错,用户非法跨界操作!");
Response.End();
}
#region
SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo();
schname = schbll.GetSchName(int.Parse(schid));
SchSystem.BLL.SchDepartInfo sdiBll = new SchSystem.BLL.SchDepartInfo();
//获取部门列表
DataTable dtdpt = sdiBll.GetList("Pid pId,convert(varchar(20),DepartId) id,DepartName name,'false' checked,'true' nochecks", "SchId=" + schid + " and Stat=1 Order by OrderId").Tables[0];
dtdpt.Columns["nochecks"].ColumnName = "nocheck";
DataTable dtdptuser = dtdpt.Clone();
if (dtdpt.Rows.Count > 0)
{
//获取该年级下关联的领导
SchSystem.BLL.SchGradeUsers usergradebll = new SchSystem.BLL.SchGradeUsers();
DataTable dtgradeuser = usergradebll.GetList("UserName", "GradeId=" + gradeid).Tables[0];
//获取该学校的所有人员
SchSystem.BLL.SchUserDeptV userbll = new SchSystem.BLL.SchUserDeptV();
DataTable dtuser = userbll.GetList("DeptId ,UserId,UserTname", "Stat=1 and Ustat=1 and SchId=" + Com.Public.SqlEncStr(schid)).Tables[0];
//合并人员到部门表
for (int i = 0; i < dtdpt.Rows.Count; i++)
{
dtdptuser.Rows.Add(dtdpt.Rows[i].ItemArray);
//获取该部门下的人员
DataRow[] drs = dtuser.Select("DeptId='" + dtdpt.Rows[i]["id"].ToString()+"'");
if (drs.Length > 0)
{
foreach (DataRow item in drs)
{
//如果是被绑定了,则勾选
DataRow[] drsgrade = dtgradeuser.Select("UserName='******'");
DataRow dr = dtdptuser.NewRow();
dr["id"] = "u_" + item["UserId"].ToString();
dr["name"] = item["UserTname"].ToString();
dr["pId"] = item["DeptId"].ToString();
if (drsgrade.Length > 0)
dr["checked"] = "true";
dtdptuser.Rows.Add(dr);
}
}
}
}
depart =Newtonsoft.Json.JsonConvert.SerializeObject(dtdptuser);
#endregion
}
}
public static string GetIdsAllStu(string TypeCode, string pAreaCode)
{
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder("0");
SchSystem.BLL.SchGradeInfo bllgrade = new SchSystem.BLL.SchGradeInfo();
SchSystem.BLL.SchClassInfo bllclass = new SchSystem.BLL.SchClassInfo();
if (TypeCode == "4")//年级
{
//普通老师
if (Com.Session.systype == "0")
{
if (Com.Public.IsUserVal(Com.Session.userrolestr, 2))//有查询权限,则全校
{
dt = bllgrade.GetList("GradeId ID", "IsFinish=0 and SchId='" + Com.Public.SqlEncStr(pAreaCode) + "'").Tables[0];
}
else//年级主任或者普通老师
{
dt = bllgrade.GetList("GradeId ID", "IsFinish=0 and SchId='" + Com.Public.SqlEncStr(pAreaCode) + "' and (GradeId in (select GradeId FROM SchGradeUsers where UserName="******") or GradeId in (select GradeId FROM SchClassUserV where UserName="******"))").Tables[0];
}
}
else//学校超管
{
dt = bllgrade.GetList("GradeId ID", "IsFinish=0 and SchId='" + Com.Public.SqlEncStr(pAreaCode) + "'").Tables[0];
}
}
else if (TypeCode == "5")//班级
{
if (pAreaCode == "")
{
pAreaCode = "0";
}
if (pAreaCode == "-1")
{
//普通老师
if (Com.Session.systype == "0")
{
if (Com.Public.IsUserVal(Com.Session.userrolestr, 2))//有查询权限,则全校
{
dt = bllclass.GetList("ClassId ID", "IsFinish=0 and SchId='" + Com.Session.schid + "'").Tables[0];
}
else//年级主任或者普通老师
{
dt = bllclass.GetList("ClassId ID", "IsFinish=0 and SchId='" + Com.Session.schid + "' and (GradeId in (select GradeId FROM SchGradeUsers where UserName="******") or ClassId in (select ClassId FROM SchClassUserV where UserName="******"))").Tables[0];
}
}
else//学校超管
{
dt = bllclass.GetList("ClassId ID", "IsFinish=0 and SchId='" + Com.Session.schid + "'").Tables[0];
}
}
else
{
//普通老师
if (Com.Session.systype == "0")
{
if (Com.Public.IsUserVal(Com.Session.userrolestr, 2))//有查询权限,则全校
{
dt = bllclass.GetList("ClassId ID", "IsFinish=0 and GradeId='" + Com.Public.SqlEncStr(pAreaCode) + "'").Tables[0];
}
else//年级主任或者普通老师
{
dt = bllclass.GetList("ClassId ID", "IsFinish=0 and GradeId='" + Com.Public.SqlEncStr(pAreaCode) + "' and (GradeId in (select GradeId FROM SchGradeUsers where UserName="******") or ClassId in (select ClassId FROM SchClassUserV where UserName="******"))").Tables[0];
}
}
else//学校超管
{
dt = bllclass.GetList("ClassId ID", "IsFinish=0 and GradeId='" + Com.Public.SqlEncStr(pAreaCode) + "'").Tables[0];
}
}
}
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("," + dt.Rows[i]["ID"].ToString());
}
}
return(sb.ToString());
}
public static string GetDrpAreaStu(string TypeCode, string pAreaCode, ref string sAreaCode, bool addall)
{
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
SchSystem.BLL.SysArea bll = new SchSystem.BLL.SysArea();
SchSystem.BLL.SchInfo bllsch = new SchSystem.BLL.SchInfo();
SchSystem.BLL.SchGradeInfo bllgrade = new SchSystem.BLL.SchGradeInfo();
SchSystem.BLL.SchClassInfo bllclass = new SchSystem.BLL.SchClassInfo();
string sqlstr = "";
if (TypeCode == "0")//取省份
{
sqlstr = "";
}
else if (TypeCode == "1" && pAreaCode != "")//取城市
{
if (pAreaCode.Length == 6)
{
sqlstr = " and left(AreaCode,2)='" + pAreaCode.Substring(0, 2) + "'";
}
else
{
sqlstr = " and AreaCode='" + Com.Public.SqlEncStr(pAreaCode) + "'";
}
}
else if (TypeCode == "2" && pAreaCode != "")//取区县
{
if (pAreaCode.Length == 6)
{
sqlstr = " and left(AreaCode,4)='" + pAreaCode.Substring(0, 4) + "'";
}
else
{
sqlstr = " and AreaCode='" + Com.Public.SqlEncStr(pAreaCode) + "'";
}
}
if (addall)
{
sb.Append("<option value=\"-1\" selected=\"selected\">全部</option>");
}
if (TypeCode == "0" || TypeCode == "1" || TypeCode == "2")
{
//dt = bll.GetList("AreaCode ID,AreaName Name", "Stat=1 and TypeCode='" + TypeCode + "' " + sqlstr + " Order by AreaName").Tables[0];
dt = bll.GetList("AreaCode ID,AreaName Name", "TypeCode='" + Com.Public.SqlEncStr(TypeCode) + "' " + sqlstr + " Order by AreaName").Tables[0]; //获取全部省份
}
else if (TypeCode == "3") //学校
{
dt = bllsch.GetList("SchId ID,SchName Name", "Stat=1 and AreaNo='" + Com.Public.SqlEncStr(pAreaCode) + "' Order by SchName").Tables[0];
}
else if (TypeCode == "4")//年级
{
//普通老师
if (Com.Session.systype == "0")
{
if (Com.Public.IsUserVal(Com.Session.userrolestr, 2))//有查询权限,则全校
{
dt = bllgrade.GetList("GradeId ID ,GradeName Name", "IsFinish=0 and SchId='" + Com.Public.SqlEncStr(pAreaCode) + "' Order by GradeCode").Tables[0];
}
else
{
dt = bllgrade.GetList("GradeId ID ,GradeName Name", "IsFinish=0 and SchId='" + Com.Public.SqlEncStr(pAreaCode) + "' and (GradeId in (select GradeId FROM SchGradeUsers where UserName="******") or GradeId in (select GradeId FROM SchClassUserV where UserName="******")) Order by GradeCode").Tables[0];
}
}
else//学校超管
{
dt = bllgrade.GetList("GradeId ID ,GradeName Name", "IsFinish=0 and SchId='" + Com.Public.SqlEncStr(pAreaCode) + "' Order by GradeCode").Tables[0];
}
}
else if (TypeCode == "5")//班级
{
if (pAreaCode == "")
{
pAreaCode = "0";
}
//普通老师
if (Com.Session.systype == "0")
{
if (Com.Public.IsUserVal(Com.Session.userrolestr, 2))//有查询权限,则全校
{
dt = bllclass.GetList("ClassId ID, ClassName Name", "IsFinish=0 and GradeId='" + Com.Public.SqlEncStr(pAreaCode) + "' Order by ClassName").Tables[0];
}
else
{
dt = bllclass.GetList("ClassId ID, ClassName Name", "IsFinish=0 and GradeId='" + Com.Public.SqlEncStr(pAreaCode) + "' and (GradeId in (select GradeId FROM SchGradeUsers where UserName="******") or ClassId in (select ClassId FROM SchClassUserV where UserName="******")) Order by ClassName").Tables[0];
}
}
else//学校超管
{
dt = bllclass.GetList("ClassId ID, ClassName Name", "IsFinish=0 and GradeId='" + Com.Public.SqlEncStr(pAreaCode) + "' Order by ClassName").Tables[0];
}
}
if (dt.Rows.Count > 0)
{
if (sAreaCode == "")//输出第一个节点
{
sAreaCode = dt.Rows[0]["ID"].ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (sAreaCode == "" && i == 0)
{
sb.Append("<option value=\"" + dt.Rows[i]["ID"].ToString() + "\" selected=\"selected\">" + dt.Rows[i]["Name"].ToString() + "</option>");
}
else
{
// selected="selected"
if (dt.Rows[i]["ID"].ToString() == sAreaCode)
{
sb.Append("<option value=\"" + dt.Rows[i]["ID"].ToString() + "\">" + dt.Rows[i]["Name"].ToString() + "</option>");
}
else
{
sb.Append("<option value=\"" + dt.Rows[i]["ID"].ToString() + "\">" + dt.Rows[i]["Name"].ToString() + "</option>");
}
}
}
}
return(sb.ToString());
}
/// <summary>
///
/// </summary>
/// <param name="TypeCode"></param>
/// <param name="pAreaCode"></param>
/// <param name="sAreaCode"></param>
/// <param name="addall"></param>
/// <param name="listoredit">區分是否為列表頁面和編輯頁面（1代表列表頁面；0代表編輯頁面）</param>
/// <returns></returns>
public static string GetDrpArea(string TypeCode, string pAreaCode, ref string sAreaCode, bool addall, string listoredit = "1")
{
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
SchSystem.BLL.SysArea bll = new SchSystem.BLL.SysArea();
SchSystem.BLL.SchInfo bllsch = new SchSystem.BLL.SchInfo();
SchSystem.BLL.SchGradeInfo bllgrade = new SchSystem.BLL.SchGradeInfo();
SchSystem.BLL.SchClassInfo bllclass = new SchSystem.BLL.SchClassInfo();
string sqlstr = "";
if (TypeCode == "0")//取省份
{
sqlstr = "";
}
else if (TypeCode == "1")//取城市
{
if (pAreaCode.Length == 6)
{
sqlstr = " and left(AreaCode,2)='" + pAreaCode.Substring(0, 2) + "'";
}
else
{
sqlstr = " and AreaCode='" + pAreaCode + "'";
}
}
else if (TypeCode == "2")//取区县
{
if (pAreaCode.Length == 6)
{
sqlstr = " and left(AreaCode,4)='" + pAreaCode.Substring(0, 4) + "'";
}
else
{
sqlstr = " and AreaCode='" + pAreaCode + "'";
}
}
if (addall)
{
sb.Append("<option value=\"\" selected=\"selected\">全部</option>");
}
if (TypeCode == "0" || TypeCode == "1" || TypeCode == "2")
{
//dt = bll.GetList("AreaCode ID,AreaName Name", "Stat=1 and TypeCode='" + TypeCode + "' " + sqlstr + " Order by AreaName").Tables[0];
dt = bll.GetList("AreaCode ID,AreaName Name", "TypeCode='" + TypeCode + "' " + sqlstr + " Order by AreaName").Tables[0]; //获取全部省份
}
else if (TypeCode == "3") //学校
{
dt = bllsch.GetList("SchId ID,SchName Name", "Stat=1 and AreaNo='" + pAreaCode + "' Order by SchName").Tables[0];
}
else if (TypeCode == "4")//年级
{
schids = pAreaCode;
dt = bllgrade.GetList("GradeId ID ,GradeName Name", "IsFinish=0 and SchId='" + pAreaCode + "' Order by GradeCode").Tables[0];
}
else if (TypeCode == "5")//班级
{
string strWhere = "";
if (Com.Session.systype != "2")
{
strWhere += " and schid ='" + Com.Session.schid + "'";
}
else
{
strWhere += " and schid ='" + schids + "'";
}
dt = bllclass.GetList("ClassId ID, ClassName Name", "IsFinish=0 and GradeId='" + pAreaCode + "'" + strWhere + " Order by ClassName").Tables[0];
}
if (dt.Rows.Count > 0)
{
if (addall && listoredit == "1")
{
sAreaCode = "";
}
else
{
if (string.IsNullOrEmpty(sAreaCode))
{
sAreaCode = dt.Rows[0]["ID"].ToString();
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
//if (sAreaCode == "" && i == 0)
//{
// sb.Append("<option value=\"" + dt.Rows[i]["ID"].ToString() + "\" selected=\"selected\">" + dt.Rows[i]["Name"].ToString() + "</option>");
//}
//else
//{
// selected="selected"
if (dt.Rows[i]["ID"].ToString() == sAreaCode)
{
sb.Append("<option value=\"" + dt.Rows[i]["ID"].ToString() + "\" selected=\"selected\">" + dt.Rows[i]["Name"].ToString() + "</option>");
}
else
{
sb.Append("<option value=\"" + dt.Rows[i]["ID"].ToString() + "\">" + dt.Rows[i]["Name"].ToString() + "</option>");
}
//}
}
}
return(sb.ToString());
}
public static Com.DataPack.DataRsp <string> page(string PageIndex, string PageSize, string txtname, string ustat, string txtcode, string drptype)
{
Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>();
if (Com.Session.userid == null)
{
rsp.code = "expire";
rsp.msg = "页面已经过期，请重新登录";
}
else
{
try
{
//Stat:0废弃,1正常,2被删除,正常界面不显示删除,超管界面可以考虑
string strwhere = "Stat<2 and SchId='" + Com.Session.schid + "' ";
if (!string.IsNullOrEmpty(txtname))
{
strwhere += " and Topic like '%" + Com.Public.SqlEncStr(txtname) + "%'";
}
if (!string.IsNullOrEmpty(ustat))
{
strwhere += " and Stat='" + Com.Public.SqlEncStr(ustat) + "'";
}
if (txtcode != "0")
{
strwhere += " and ChnId='" + Com.Public.SqlEncStr(txtcode) + "'";
}
if (drptype != "")
{
strwhere += " and Lv='" + Com.Public.SqlEncStr(drptype) + "'";
}
Com.Public.PageModelResp pages = new Com.Public.PageModelResp();
pages.PageIndex = int.Parse(PageIndex);
pages.PageSize = int.Parse(PageSize);
int rowc = 0;
int pc = 0;
SchSystem.BLL.WebSchChnNewsV userbll = new SchSystem.BLL.WebSchChnNewsV();
string dbcols = "NewsId,ChnName,ChnId,Topic,RecTime,GradeId,ClassId,Lv,'' GradeName,'' ClassName,'' LvName,'0' isdel,'0' isedit,'1' islook,Stat,IsTop";
DataTable dt = userbll.GetListCols(dbcols, strwhere, "IsTop Desc,RecTime DESC", "", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0];
pages.PageCount = pc;
pages.RowCount = rowc;
if (dt.Rows.Count > 0)
{
SchSystem.BLL.SchClassUser bllclassuser = new SchSystem.BLL.SchClassUser();
SchSystem.BLL.SchGradeUsers bllgradeuser = new SchSystem.BLL.SchGradeUsers();
SchSystem.BLL.SchClassInfo bllclass = new SchSystem.BLL.SchClassInfo();
SchSystem.BLL.SchGradeInfo bllgrade = new SchSystem.BLL.SchGradeInfo();
//权限
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Com.Session.appeditstat == "1") //允许编辑
{
if (dt.Rows[i]["Lv"].ToString() == "0") //班级新闻
{
if (Com.Public.IsUserVal(Com.Session.userrolestr, 14) || bllclassuser.ExistsIsMs(dt.Rows[i]["ClassId"].ToString(), Com.Session.usertid, Com.Session.schid, 1) == true) //如果有所有班级权限或是班主任
{
dt.Rows[i]["isdel"] = "1";
dt.Rows[i]["isedit"] = "1";
}
//获取年级,班级,类型
dt.Rows[i]["GradeName"] = bllgrade.GetName(int.Parse(dt.Rows[i]["GradeId"].ToString()));
dt.Rows[i]["ClassName"] = bllclass.GetName(int.Parse(dt.Rows[i]["ClassId"].ToString()));
dt.Rows[i]["LvName"] = "班级";
}
else if (dt.Rows[i]["Lv"].ToString() == "1") //年级新闻
{
if (Com.Public.IsUserVal(Com.Session.userrolestr, 13) || bllgradeuser.ExistsGrade(dt.Rows[i]["GradeId"].ToString(), Com.Session.schid, Com.Session.usertid) == true) //如果有全校权限或是年级组长
{
dt.Rows[i]["isdel"] = "1";
dt.Rows[i]["isedit"] = "1";
}
//获取年级
dt.Rows[i]["GradeName"] = bllgrade.GetName(int.Parse(dt.Rows[i]["GradeId"].ToString()));
dt.Rows[i]["LvName"] = "年级";
}
else if (dt.Rows[i]["Lv"].ToString() == "2") //学校新闻
{
if (Com.Public.IsUserVal(Com.Session.userrolestr, 13)) //如果有全校权限
{
dt.Rows[i]["isdel"] = "1";
dt.Rows[i]["isedit"] = "1";
}
dt.Rows[i]["LvName"] = "学校";
}
}
}
pages.list = dt;
}
rsp.RspData = Newtonsoft.Json.JsonConvert.SerializeObject(pages).Replace("\n\r", "");
}
catch (Exception ex)
{
rsp.code = "error";
rsp.msg = ex.Message;
}
}
return(rsp);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string Action = context.Request.Form["Action"];
string SchId = context.Request.Form["SchId"];
if (string.IsNullOrEmpty(SchId))
{
SchId = "0";
}
else
{
SchId = Com.Public.SqlEncStr(SchId);
}
if (Action == "GradeClassInfo")
{
//年级
SchSystem.BLL.SchGradeInfo sgiBLL = new SchSystem.BLL.SchGradeInfo();
DataTable dt = sgiBLL.GetList(" IsFinish=0 and SchId=" + SchId + " order by GradeCode").Tables[0];//得到年级数据列表,并且是为非毕业的年级
//年级领导
SchSystem.BLL.SchGradeUsers sguBLL = new SchSystem.BLL.SchGradeUsers();
dt.Columns.Add("GradeBoss");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["GradeBoss"] = sguBLL.GetNames("GradeId=" + dt.Rows[i]["GradeId"].ToString());
}
}
context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(dt));
}
/*if (Action == "GradeClassList")
* {
* //string UserId = Com.Session.userid;//获取session中的username
*
* //int SchId = int.Parse(Com.Session.schid);//获取session中的schid
*
* SchSystem.BLL.SchUserInfo suiBll = new SchSystem.BLL.SchUserInfo();
* DataSet UserDs = suiBll.GetList("*", "Stat=1 and SchId=" + SchId);//获取当前学校的用户
* string UserStr = SchManagerInfoSystem.Common.Function.DatSetToJSON2(UserDs, "UserRows");
*
* StringBuilder sb = new StringBuilder();
* sb.Append("{");
* sb.Append(UserStr);
* sb.Append("}");
* context.Response.Write(sb.ToString());
* }
* else if (Action == "GradeEdit")
* {
* int GradeId = int.Parse(context.Request.Form["GradeId"]);
* string nameval = context.Request.Form["name"];
* nameval = nameval.Substring(0, nameval.Length - 1);
* string[] NameArr = nameval.Split(',');
* int NameArrLenght = NameArr.Length;
*
* SchSystem.BLL.SchGradeUsers sguBll = new SchSystem.BLL.SchGradeUsers();
* //先删除原有年级领导，仅供测试之用
* DataSet ds = sguBll.GetList("AutoId","GradeId="+GradeId);
*
* StringBuilder sb = new StringBuilder();
* //遍历一个表多行多列
* if (ds.Tables[0].Rows.Count > 0)
* {
* foreach (DataRow row in ds.Tables[0].Rows)
* {
* sb.Append(row[0].ToString() + ",");
* }
* string str = sb.ToString();
* str = str.Substring(0, str.Length - 1);
* sguBll.DeleteList(str);
* }
* //下面的少量数据批量插入数据，仅供测试之用
* int iStr = 0;
* for (int i=0; i < NameArrLenght; i++)
* {
* SchSystem.Model.SchGradeUsers sgi = new SchSystem.Model.SchGradeUsers();
* sgi.GradeId = GradeId;
* sgi.UserName = NameArr[i];
* sgi.UserTname = NameArr[i];
* iStr = sguBll.Add(sgi);
* }
* if(iStr>=0)
* context.Response.Write("1");
* else
* context.Response.Write("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 HomeschServStat=" + 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,HomeSchPlatName,HomeSchPlatUrl,HomeSchPlatIco,HomeSchPlatIP,SchMaster,SchoolSection,ServiceName,Artisan,SchCreator,RecTime,HomeschServStat,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("SoureName");
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.SchAppRoleXXT sarxxtBll = new SchSystem.BLL.SchAppRoleXXT();
DataTable dtsarxxt = sarxxtBll.GetList("SchId='" + dt.Rows[i]["SchId"].ToString() + "'").Tables[0];
if (dtsarxxt.Rows.Count > 0)
{
string[] sarsAppCodearr = dtsarxxt.Rows[0]["AppStr"].ToString().Split(',');
StringBuilder sarsAppCodesb = new StringBuilder();
StringBuilder sasSoureName = new StringBuilder();
for (int j = 0; j < sarsAppCodearr.Length; j++)
{
sarsAppCodesb.Append(sarsAppCodearr[j] + ",");
}
SchSystem.BLL.SchAppXXT saxxtBll = new SchSystem.BLL.SchAppXXT();
if (sarsAppCodesb.ToString() != "")
{
try
{
DataTable dtsas = saxxtBll.GetList("AppName", "AppCode in (" + sarsAppCodesb.ToString().Substring(0, sarsAppCodesb.ToString().Length - 1) + ")").Tables[0];
if (dtsas.Rows.Count > 0)
{
foreach (DataRow dr in dtsas.Rows)
{
sasSoureName.Append(dr["AppName"] + ",");
}
dt.Rows[i]["SoureName"] = sasSoureName.ToString().Substring(0, sasSoureName.Length - 1);
}
}
catch (Exception e) { }
}
else
{
dt.Rows[i]["SoureName"] = "";
}
}
//查询科目
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 string gradesave(string dotype, string schid, string gradename, string gradeid, string tagsusers)
{
dotype = Com.Public.SqlEncStr(dotype);
schid = Com.Public.SqlEncStr(schid);
gradename = Com.Public.SqlEncStr(gradename);
gradeid = Com.Public.SqlEncStr(gradeid);
tagsusers = Com.Public.SqlEncStr(tagsusers);
string ret = "";
//字符串匹配验证
string PatternStr = @"^[\u4e00-\u9fa5]+$";
bool resultStr = Regex.IsMatch(gradename, PatternStr);
if (resultStr != true)
{
return ret = "只能输入中文名称";
}
try
{
if (string.IsNullOrEmpty(schid) || schid == "0")
ret += "非法的学校!";
SchSystem.BLL.SchGradeInfo userbll = new SchSystem.BLL.SchGradeInfo();
SchSystem.Model.SchGradeInfo usermodel = new SchSystem.Model.SchGradeInfo();
usermodel.LastRecTime = DateTime.Now;
usermodel.LastRecUser = Com.Session.userid;
//判断编号及账号是否有重复,生成密码加密
if (dotype == "e")
{
if (userbll.ExistsGradeCode(int.Parse(gradeid), Com.Public.SqlEncStr(gradename), int.Parse(schid)))
{
ret += "年级编号重复!";
}
}
if (dotype == "a")
{
if (userbll.ExistsGradeCode(0, Com.Public.SqlEncStr(gradename), int.Parse(schid)))
{
ret += "年级编号重复!";
}
if (userbll.ExistsGradeCode(0, Com.Public.SqlEncStr(gradename), int.Parse(schid)))
{
ret += "年级重复!";
}
}
if (ret == "")
{
if (!Com.Public.isVa(schid, ""))
{
return ret = "无跨界权限";
}
if (schid == Com.Public.getKey("adminschid"))
{
ret = "此为系统学校,不允许操作";
}
else if (dotype == "e")
{
usermodel.GradeId = int.Parse(gradeid);
usermodel.GradeName = Com.Public.SqlEncStr(gradename);
usermodel.LastRecTime = DateTime.Now;
usermodel.LastRecUser = Com.Session.userid;
userbll.UpdateGrade(usermodel);
}
tagsusers = Com.Public.SqlEncStr(tagsusers);
//添加或更新关联年级
SchSystem.BLL.SchGradeUsers userdeptbll = new SchSystem.BLL.SchGradeUsers();
if (tagsusers == "null") tagsusers = "";
else
tagsusers = "'"+tagsusers.Replace(",", "','").Replace("u_","") + "'";
userdeptbll.DoUserGrade(gradeid, Com.Session.userid,schid, tagsusers);
//添加或更新关联角色
//SchSystem.BLL.SchUserRole userrolebll = new SchSystem.BLL.SchUserRole();
// if (userroles == null) userroles = "0";
// userrolebll.DoUserRole(username, Com.Session.userid, schid, userroles);
ret = "success";
}
}
catch (Exception ex)
{
ret = ex.Message;
}
return ret;
}
public static string udel(string type, string schid, string gradeid, string classid)
{
schid = Com.Public.SqlEncStr(schid);
gradeid = Com.Public.SqlEncStr(gradeid);
classid = Com.Public.SqlEncStr(classid);
string ret = "";
try
{
if (!Com.Public.IsOne(Com.Session.userrolestr, 13))
{
return(ret = "无操作权限");
}
if (!Com.Public.isVa(schid, ""))
{
return(ret = "无跨界权限");
}
if (schid == Com.Public.getKey("adminschid"))
{
ret = "此为系统学校,不允许操作";
}
else
{
if (type == "1")//删除年级
{
SchSystem.BLL.SchGradeInfo bll = new SchSystem.BLL.SchGradeInfo();
SchSystem.Model.SchGradeInfo model = new SchSystem.Model.SchGradeInfo();
model.GradeId = int.Parse(gradeid);
model.IsFinish = 2;
model.LastRecTime = DateTime.Now;
model.LastRecUser = Com.Session.userid;
if (bll.UpdateStat(model))
{
ret = "success";
}
else
{
ret = "操作失败";
}
}
else if (type == "0")//删除班级
{
SchSystem.BLL.SchClassInfo classbll = new SchSystem.BLL.SchClassInfo();
SchSystem.Model.SchClassInfo classmodel = new SchSystem.Model.SchClassInfo();
classmodel.ClassId = int.Parse(classid);
classmodel.IsFinish = 2;
classmodel.LastRecTime = DateTime.Now;
classmodel.LastRecUser = Com.Session.userid;
if (classbll.UpdateStat(classmodel))
{
ret = "success";
}
else
{
ret = "操作失败";
}
}
}
}
catch (Exception ex)
{
ret = ex.Message;
}
return(ret);
}
public static string schsave(string dotype, string schid, string schname, string schaddr, string schmaster, string schmasterpst, string schmastertel, string iscity, string schstat, string selgrades, string selsubs, string areano, string schnote)
{
string ret = "";
if (Com.Session.userid == null)
{
ret = "expire";
}
else
{
try
{
//学校名不能为空,
if (string.IsNullOrEmpty(schname))
{
ret += "学校名称不能为空!";
}
if (!Com.Public.isVa(schid, ""))
{
ret += "无跨界权限;";
}
if (ret == "")
{
SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo();
SchSystem.Model.SchInfo schmodel = new SchSystem.Model.SchInfo();
schmodel.LastRecTime = DateTime.Now;
schmodel.LastRecUser = Com.Session.userid;
schmodel.SchAddr = schaddr;
schmodel.SchMaster = schmaster;
schmodel.MasterPostion = schmasterpst;
schmodel.SchName = schname;
schmodel.SchTel = schmastertel;
schmodel.IsCity = int.Parse(iscity);
schmodel.Stat = int.Parse(schstat);
schmodel.AreaNo = areano;
schmodel.SchNote = schnote;
if (dotype == "e")
{
schmodel.SchId = int.Parse(schid);
schbll.UpdateSch(schmodel);
}
if (dotype == "a")
{
schmodel.RecTime = DateTime.Now;
schmodel.RecUser = Com.Session.userid;
schid = schbll.Add(schmodel).ToString();
}
if (int.Parse(schid) > 0)
{
//添加年级及科目
SchSystem.BLL.SchGradeInfo gradebll = new SchSystem.BLL.SchGradeInfo();
gradebll.DoSchGrades(Com.Session.userid, schid, selgrades);
//添加科目
SchSystem.BLL.SchSub subbll = new SchSystem.BLL.SchSub();
subbll.DoSchSubs(Com.Session.userid, schid, selsubs);
}
ret = "success";
}
}
catch (Exception ex)
{
ret = ex.Message;
}
}
return(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
islook = true;
if (Com.Session.appeditstat == "0" && Com.Session.systype == "1")
{
isadd = false;
isedit = false;
isdel = false;
}
else
{
isadd = true;
isedit = true;
isdel = true;
}
//不是超管获取本学校的
if (Com.Session.systype != "2")
{
schid = Com.Session.schid;
}
else//超管还要加省市区学校下拉,后面需要更改
{
//第一次加载,获取省市区,获取第一个省份下的所有学校
StringBuilder sbarea = new StringBuilder();
//获取省份
sbarea.Append("省:<select id=\"aprov\">");
string sareacode = "";
sbarea.Append(Com.Public.GetDrpArea("0", "", ref sareacode, false));
sbarea.Append("</select>");
//获取城市
sbarea.Append("市:<select id=\"acity\">");
string sareacitycode = "";
sbarea.Append(Com.Public.GetDrpArea("1", sareacode, ref sareacitycode, false));
sbarea.Append("</select>");
//获取区县
sbarea.Append("区:<select id=\"acoty\">");
string sareacotycode = "";
sbarea.Append(Com.Public.GetDrpArea("2", sareacitycode, ref sareacotycode, false));
cotycode = sareacotycode;
sbarea.Append("</select>");
sbarea.Append("学校:<select id=\"asch\">");
string sareaschid = "";
sbarea.Append(Com.Public.GetDrpArea("3", sareacotycode, ref sareaschid, false));
if (sareaschid != "")
{
schid = sareaschid;
}
sbarea.Append("</select>");
areastr = sbarea.ToString();
}
//获取学校的科目
SchSystem.BLL.SchSub SchSubBll = new SchSystem.BLL.SchSub();
DataTable dtschsub = SchSubBll.GetList("SubName", "Stat=1 and SchId='" + schid + "'").Tables[0];
if (dtschsub.Rows.Count > 0)
{
StringBuilder sbSubName = new StringBuilder();
foreach (DataRow drSubName in dtschsub.Rows)
{
sbSubName.Append(drSubName["SubName"] + "、");
}
schsubname = sbSubName.ToString().Substring(0, sbSubName.Length - 1);
}
//获取学校年级
SchSystem.BLL.SchGradeInfo SchGradeBll = new SchSystem.BLL.SchGradeInfo();
DataTable dtschgrade = SchGradeBll.GetList("GradeId,GradeYear,GradeName", "IsFinish=0 and SchId='" + schid + "' Order by GradeCode ASC").Tables[0];
schgradeinfo = Newtonsoft.Json.JsonConvert.SerializeObject(dtschgrade);
//获取学校班级
//SchSystem.BLL.SchClassInfo SchClassBll = new SchSystem.BLL.SchClassInfo();
//DataTable dtschclass = SchClassBll.GetList("ClassId,GradeId,ClassName", "IsFinish=0 and SchId='" + schid + "'").Tables[0];
//schclassinfo = Newtonsoft.Json.JsonConvert.SerializeObject(dtschclass);
}
}
public static string udel(string type, string schid, string gradeid, string classid)
{
schid = Com.Public.SqlEncStr(schid);
gradeid = Com.Public.SqlEncStr(gradeid);
classid = Com.Public.SqlEncStr(classid);
string ret = "";
Com.DataPack.DataRsp <Com.DataPack.UserInfo> rsp = Com.Public.UserFuncSoure(Com.SoureSession.jsid, Com.SoureSession.jstoken);
if (rsp.code == "ERROR_TOKEN")
{
ret = "expire";
}
else
{
try
{
if (!Com.Public.isVa(schid, ""))
{
return(ret = "无跨界权限");
}
if (schid == Com.Public.getKey("adminschid"))
{
ret = "此为系统学校,不允许操作";
}
else
{
if (type == "1")//删除年级
{
SchSystem.BLL.SchGradeInfo bll = new SchSystem.BLL.SchGradeInfo();
SchSystem.Model.SchGradeInfo model = new SchSystem.Model.SchGradeInfo();
model.GradeId = int.Parse(gradeid);
model.IsFinish = 2;
model.LastRecTime = DateTime.Now;
model.LastRecUser = Com.SoureSession.Soureuserid;
if (bll.UpdateStat(model))
{
ret = "success";
}
else
{
ret = "操作失败";
}
}
else if (type == "0")//删除班级
{
SchSystem.BLL.SchClassInfo classbll = new SchSystem.BLL.SchClassInfo();
bool resultBool = classbll.ExistsClassStuData(int.Parse(classid));
SchSystem.BLL.SchClassUser classuserbll = new SchSystem.BLL.SchClassUser();
bool resultBoolUser = classuserbll.ExistsClassUser(schid, classid);
if (resultBool || resultBoolUser)//如果为true说明是班级内有属性数据
{
ret = "success01";
}
else//否则即可删除班级记录
{
SchSystem.Model.SchClassInfo classmodel = new SchSystem.Model.SchClassInfo();
classmodel.ClassId = int.Parse(classid);
classmodel.IsFinish = 2;
classmodel.LastRecTime = DateTime.Now;
classmodel.LastRecUser = Com.SoureSession.Soureuserid;
if (classbll.UpdateStat(classmodel))
{
SchSystem.BLL.SchClassUser scuBll = new SchSystem.BLL.SchClassUser();
// bool ecu = scuBll.ExistsClassUser(int.Parse(schid), int.Parse(classid));
bool scubool = scuBll.Delete(classid, schid);
//if (scubool)
// {
ret = "success";
//}
}
else
{
ret = "操作失败";
}
}
}
}
}
catch (Exception ex)
{
ret = ex.Message;
}
}
return(ret);
}
public static Com.DataPack.DataRsp <string> page(string PageIndex, string PageSize, string txtname, string ustat, string cotycode, string schid, 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 (schid != "")
{
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);
}
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,AreaNo,SchType";
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("ManagerAcount");
dt.Columns.Add("InitialPwd");
dt.Columns.Add("graduated");
dt.Columns.Add("AppSonSys");
dt.Columns.Add("SchSubNames");
dt.Columns.Add("SchTypeName");
SchSystem.BLL.SysPer bllper = new SchSystem.BLL.SysPer();
DataTable dtper = bllper.GetList("PerName,PerCode", " Stat=1 ").Tables[0];
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];
DataRow[] dtr = dtper.Select("PerCode='" + dt.Rows[i]["SchType"].ToString() + "'");
if (dtr.Length > 0)
{
dt.Rows[i]["SchTypeName"] = dtr[0]["PerName"].ToString();
}
else
{
dt.Rows[i]["SchTypeName"] = "";
}
//获取管理员账号密码信息
SchSystem.BLL.SchUserInfo suiBll = new SchSystem.BLL.SchUserInfo();
SchSystem.Model.SchUserInfo modeluserinfo = suiBll.GetSupportModel(int.Parse(dt.Rows[i]["SchId"].ToString()), 1);
if (modeluserinfo != null)
{
if (modeluserinfo.UserName != "" && modeluserinfo.UserName != null)
{
dt.Rows[i]["ManagerAcount"] = modeluserinfo.UserName;
}
if (modeluserinfo.PassWord != "" && modeluserinfo.PassWord != null)
{
dt.Rows[i]["InitialPwd"] = 1;
}
}
else
{
dt.Rows[i]["ManagerAcount"] = "";
dt.Rows[i]["InitialPwd"] = "";
}
//查询最近毕业年级
string currentYear = "";
if (DateTime.Now.Month < 8)
{
currentYear = (DateTime.Now.Year - 1).ToString();
}
else
{
currentYear = DateTime.Now.Year.ToString();
}
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"] + ",");
}
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 string GetDrp(string drptype, string schid, string stat, bool addall, string selfid, string selid)
{
drptype = SqlEncStr(drptype);
schid = SqlEncStr(schid);
stat = SqlEncStr(stat);
selfid = SqlEncStr(selfid);
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
if (schid == "")
{
schid = "0";
}
//获取部门
if (drptype == "dpt")
{
SchSystem.BLL.SchDepartInfo dptbll = new SchSystem.BLL.SchDepartInfo();
dt = dptbll.GetList("Pid,DepartId ID,DepartName Name", "SchId=" + schid + " and Stat=" + stat + " Order by OrderId,DepartName").Tables[0];
}
else if (drptype == "sub")
{
SchSystem.BLL.SchSub subbll = new SchSystem.BLL.SchSub();
dt = subbll.GetList("0 Pid,SubCode ID,SubName Name", "SchId=" + schid + " and Stat=" + stat + " Order by OrderId,SubName").Tables[0];
}
else if (drptype == "grade")
{
SchSystem.BLL.SchGradeInfo subbll = new SchSystem.BLL.SchGradeInfo();
if (stat == "")
{
dt = subbll.GetList("0 Pid,GradeId ID,GradeName Name", "SchId=" + schid + " Order by GradeCode").Tables[0];
}
else
{
dt = subbll.GetList("0 Pid,GradeId ID,GradeName Name", "SchId=" + schid + " and IsFinish=" + stat + " Order by GradeCode").Tables[0];
}
}
if (addall)
{
sb.Append("<option value=\'0\'>全部</option>");
}
if (dt.Rows.Count > 0)
{
string childrenids = "";
DataRow[] drs = dt.Select("Pid=0");
foreach (DataRow dr in drs)
{
string nodeID = dr["ID"].ToString();
string nodeText = dr["Name"].ToString();
if (nodeID != selfid)
{
//GetSonId(nodeID, dt, ref childrenids);
if (drptype == "dpt")
{
nodeText = "├" + nodeText;
}
if (dr["ID"].ToString() == selid)
{
sb.Append("<option value=\"" + nodeID + "\" selected=\"selected\" childrenids=\"\">" + nodeText + "</option>");
}
else
{
sb.Append("<option value=\"" + nodeID + "\" childrenids=\"\">" + nodeText + "</option>");
}
if (drptype == "dpt")
{
string blank = " ";
BindSon(sb, nodeID, dt, blank, selid, selfid);
}
}
}
}
return(sb.ToString());
}
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);
}
