public static string getnj(string typecode, string pcode, string schid, string classid) { if (schid == "undefined") { schid = Com.SoureSession.Soureschid; } schid = Com.Public.SqlEncStr(schid); typecode = Com.Public.SqlEncStr(typecode); string ClassId = ""; SchSystem.BLL.SchGradeUsers sguBLL = new SchSystem.BLL.SchGradeUsers(); SchSystem.BLL.SchClassUser scuBLL = new SchSystem.BLL.SchClassUser(); SchWebMaster.Web.Student.StudentList.namepack np = new SchWebMaster.Web.Student.StudentList.namepack(); if (typecode == "1")//1为获取年级领导 { string GradeCode = Com.Public.SqlEncStr(pcode); string sql1 = ""; string sql2 = ""; if (Com.SoureSession.Souresystype != "2")//判断是否是超管 { sql1 = "select GradeId from dbo.SchGradeInfo where GradeId='" + GradeCode + "' and SchId='" + Com.SoureSession.Soureschid + "'"; sql2 = "select * FROM SchClassGradeV where IsFinish<>2 and SchId='" + Com.SoureSession.Soureschid + "' and IsFinish=0 and GradeCode='" + GradeCode + "' and ClassId='" + classid + "' order by GradeCode,ClassName "; } else { sql1 = "select GradeId from dbo.SchGradeInfo where GradeId='" + GradeCode + "' and SchId='" + schid + "'"; sql2 = "select * FROM SchClassGradeV where IsFinish<>2 and SchId='" + schid + "' and IsFinish=0 and GradeCode='" + GradeCode + "' and ClassId='" + classid + "' order by GradeCode,ClassName "; } DataTable dt1 = DbHelperSQL.Query(sql1).Tables[0]; string GradeId = ""; if (dt1.Rows.Count > 0) { GradeId = dt1.Rows[0]["GradeId"].ToString(); } DataTable dt2 = DbHelperSQL.Query(sql2).Tables[0]; if (dt2.Rows.Count > 0) { njld = np.gradeboss = sguBLL.GetNames("GradeId='" + GradeId + "'"); } if (dt2.Rows.Count != 0) { ClassId = dt2.Rows[0]["ClassId"].ToString(); bzr = np.classms = scuBLL.GetNames("ClassId='" + ClassId + "' and IsMs=1"); bjjs = np.classtec = scuBLL.GetNames("ClassId=" + ClassId + " and IsMs=0"); } } else//侧为获取班主任和任课老师 { np.classms = scuBLL.GetNames("ClassId='" + pcode + "' and IsMs=1 and SchId='" + schid + "'"); np.classtec = scuBLL.GetNames("ClassId=" + pcode + " and IsMs=0 and SchId='" + schid + "'"); } return(Newtonsoft.Json.JsonConvert.SerializeObject(np)); }
public static string page(string txtname, string ustat, string cotycode, string schid, string gradeCode) { txtname = Com.Public.SqlEncStr(txtname); ustat = Com.Public.SqlEncStr(ustat); cotycode = Com.Public.SqlEncStr(cotycode); schid = Com.Public.SqlEncStr(schid); gradeCode = Com.Public.SqlEncStr(gradeCode); SchSystem.BLL.SchClassInfo sciBll = new SchSystem.BLL.SchClassInfo(); if (schid == "") { schid = "0"; } //IsFinish:毕业状态,0非,1是,2被删除,正常界面不显示删除,超管界面可以考虑 string strwhere = "IsFinish = 0 and SchId = '" + Com.Public.SqlEncStr(schid) + "'"; if (!string.IsNullOrEmpty(ustat)) { strwhere += " and IsFinish=" + Com.Public.SqlEncStr(ustat); } if (!string.IsNullOrEmpty(gradeCode) || gradeCode != "") { strwhere += " and GradeCode='" + Com.Public.SqlEncStr(gradeCode) + "'"; } int rowc = 0; int pc = 0; //DataTable dt = userbll.GetListCols("*", strwhere, "SchName", "ASC", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0]; DataTable ClassDt = sciBll.GetList(strwhere).Tables[0];//得到班级数据列表 //pages.PageCount = pc; if (ClassDt.Rows.Count > 0) { ClassDt.Columns.Add("Ustat"); ClassDt.Columns.Add("Ucity"); ClassDt.Columns.Add("TeacherClass"); //班主任 //ClassDt.Columns.Add("Teacher");//任课老师 ClassDt.Columns.Add("TeacherSub"); //任课老师科目 SchSystem.BLL.SchClassUser scuBLL = new SchSystem.BLL.SchClassUser(); for (int i = 0; i < ClassDt.Rows.Count; i++) { ClassDt.Rows[i]["Ustat"] = ClassDt.Rows[i]["IsFinish"].ToString() == "0" ? "正常" : "停用"; string ClassId = ClassDt.Rows[i]["ClassId"].ToString(); //班级教师(班主任) ClassDt.Rows[i]["TeacherClass"] = scuBLL.GetNames("ClassId='" + ClassId + "' and Stat=1 and IsMs=1"); //任课老师 ClassDt.Rows[i]["TeacherSub"] = scuBLL.GetNames("ClassId='" + ClassId + "' and Stat=1 and IsMs=0"); } //pages.list = ClassDt; } //Newtonsoft.Json.JsonConvert(); //string ddd = Newtonsoft.Json.JsonConvert.SerializeObject(pages); //string ddd = Newtonsoft.Json.JsonConvert.SerializeObject(ClassDt); return(Newtonsoft.Json.JsonConvert.SerializeObject(ClassDt)); }
public static string getusers(string tp, string id) { StudentList.namepack np = new StudentList.namepack(); if (Com.Public.IsNum(id)) { if (tp == "1")//获取年级主任 { SchSystem.BLL.SchGradeUsers sguBLL = new SchSystem.BLL.SchGradeUsers(); np.gradeboss = sguBLL.GetNames("GradeId=" + Com.Public.SqlEncStr(id)); } else { SchSystem.BLL.SchClassUser scuBLL = new SchSystem.BLL.SchClassUser(); np.classms = scuBLL.GetNames("ClassId=" + Com.Public.SqlEncStr(id) + " and IsMs=1"); np.classtec = scuBLL.GetNames("ClassId=" + Com.Public.SqlEncStr(id) + " and IsMs=0"); } } return(Newtonsoft.Json.JsonConvert.SerializeObject(np)); }
public static string page(string txtname, string ustat, string cotycode, string schid, string gradeCode, string classid, string subcode) { 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.SchClassInfo sciBll = new SchSystem.BLL.SchClassInfo(); //Stat:0废弃,1正常,2被删除,正常界面不显示删除,超管界面可以考虑 string strwhere = "ClassStat=0 and SchId = '" + Com.Public.SqlEncStr(schid) + "'"; if (!string.IsNullOrEmpty(ustat)) { strwhere += " and IsFinish=" + Com.Public.SqlEncStr(ustat); } else { strwhere += " and IsFinish=0"; } if (!string.IsNullOrEmpty(gradeCode)) { strwhere += " and GradeId='" + Com.Public.SqlEncStr(gradeCode) + "'"; } if (!string.IsNullOrEmpty(classid)) { strwhere += " and ClassId='" + Com.Public.SqlEncStr(classid) + "'"; } if (!string.IsNullOrEmpty(subcode)) { strwhere += " and ClassId in (select ClassId from SchClassUser where SubCode='" + Com.Public.SqlEncStr(subcode) + "' and schid='" + Com.Public.SqlEncStr(schid) + "')"; } if (!string.IsNullOrEmpty(txtname)) { strwhere += " and ClassId in (select ClassId from SchClassUser where UserTname like '%" + Com.Public.SqlEncStr(txtname) + "%' and schid='" + Com.Public.SqlEncStr(schid) + "')"; } int rowc = 0; int pc = 0; //DataTable dt = userbll.GetListCols("*", strwhere, "SchName", "ASC", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0]; DataTable ClassDt = sciBll.GetListV(strwhere + " order by GradeCode,ClassName").Tables[0];//得到班级数据列表 //pages.PageCount = pc; if (ClassDt.Rows.Count > 0) { ClassDt.Columns.Add("Ustat"); ClassDt.Columns.Add("Ucity"); ClassDt.Columns.Add("TeacherClass"); //班主任 //ClassDt.Columns.Add("Teacher");//任课老师 ClassDt.Columns.Add("TeacherSub"); //任课老师科目 SchSystem.BLL.SchClassUser scuBLL = new SchSystem.BLL.SchClassUser(); for (int i = 0; i < ClassDt.Rows.Count; i++) { ClassDt.Rows[i]["Ustat"] = ClassDt.Rows[i]["IsFinish"].ToString() == "0" ? "正常" : "停用"; string ClassId = ClassDt.Rows[i]["ClassId"].ToString(); //班级教师(班主任) ClassDt.Rows[i]["TeacherClass"] = scuBLL.GetNames("ClassId='" + ClassId + "' and IsMs=1"); //任课老师 ClassDt.Rows[i]["TeacherSub"] = scuBLL.GetNames("ClassId='" + ClassId + "' and IsMs=0"); } //pages.list = ClassDt; } //Newtonsoft.Json.JsonConvert(); //string ddd = Newtonsoft.Json.JsonConvert.SerializeObject(pages); //string ddd = Newtonsoft.Json.JsonConvert.SerializeObject(ClassDt); ret = Newtonsoft.Json.JsonConvert.SerializeObject(ClassDt); } return(ret); }
public static string page(string txtname, string ustat, string cotycode, string schid, string gradeCode, string classid, string subcode) { string ret = ""; if (Com.Session.userid == null) { ret = "expire"; } else { SchSystem.BLL.SchClassInfo sciBll = new SchSystem.BLL.SchClassInfo(); //Stat:0废弃,1正常,2被删除,正常界面不显示删除,超管界面可以考虑 string strwhere = "ClassStat=0 and SchId = '" + Com.Public.SqlEncStr(schid) + "'"; if (!string.IsNullOrEmpty(ustat)) { strwhere += " and IsFinish=" + Com.Public.SqlEncStr(ustat); } else { strwhere += " and IsFinish=0"; } if (!string.IsNullOrEmpty(gradeCode)) { strwhere += " and GradeId='" + Com.Public.SqlEncStr(gradeCode) + "'"; } if (!string.IsNullOrEmpty(classid)) { strwhere += " and ClassId='" + Com.Public.SqlEncStr(classid) + "'"; } if (!string.IsNullOrEmpty(subcode) && !string.IsNullOrEmpty(txtname)) { strwhere += " and ClassId in (select ClassId from SchClassUser where SubCode='" + Com.Public.SqlEncStr(subcode) + "' and schid='" + Com.Public.SqlEncStr(schid) + "' and UserTname like '%" + Com.Public.SqlEncStr(txtname) + "%')"; } else if (!string.IsNullOrEmpty(txtname) || !string.IsNullOrEmpty(subcode)) { if (!string.IsNullOrEmpty(txtname)) { strwhere += " and ClassId in (select ClassId from SchClassUser where UserTname like '%" + Com.Public.SqlEncStr(txtname) + "%' and schid='" + Com.Public.SqlEncStr(schid) + "')"; } else { strwhere += " and ClassId in (select ClassId from SchClassUser where SubCode='" + Com.Public.SqlEncStr(subcode) + "' and schid='" + Com.Public.SqlEncStr(schid) + "')"; } } int rowc = 0; int pc = 0; //DataTable dt = userbll.GetListCols("*", strwhere, "SchName", "ASC", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0]; DataTable ClassDt = sciBll.GetListV(strwhere + " order by GradeCode,ClassName").Tables[0];//得到班级数据列表 //pages.PageCount = pc; if (ClassDt.Rows.Count > 0) { ClassDt.Columns.Add("Ustat"); ClassDt.Columns.Add("Ucity"); ClassDt.Columns.Add("TeacherClass"); //班主任 //ClassDt.Columns.Add("Teacher");//任课老师 ClassDt.Columns.Add("TeacherSub"); //任课老师科目 SchSystem.BLL.SchClassUser scuBLL = new SchSystem.BLL.SchClassUser(); string sqlstr = ""; string sqlstrn = ""; if (!string.IsNullOrEmpty(txtname)) { sqlstrn = " UserTname like '%" + Com.Public.SqlEncStr(txtname) + "%'"; } string sqlstrs = ""; if (!string.IsNullOrEmpty(subcode)) { sqlstrs = " SubCode='" + Com.Public.SqlEncStr(subcode) + "'"; } if (sqlstrn != "" && sqlstrs != "") { sqlstr = " and ( " + sqlstrn + " or " + sqlstrs + ")"; } else if (sqlstrn != "" || sqlstrs != "") { sqlstr = " and " + sqlstrn + sqlstrs; } for (int i = 0; i < ClassDt.Rows.Count; i++) { ClassDt.Rows[i]["Ustat"] = ClassDt.Rows[i]["IsFinish"].ToString() == "0" ? "正常" : "毕业"; string ClassId = ClassDt.Rows[i]["ClassId"].ToString(); string sss = scuBLL.GetNames("ClassId='" + ClassId + "'and IsMs=1"); //班级教师(班主任) ClassDt.Rows[i]["TeacherClass"] = scuBLL.GetNames("ClassId='" + ClassId + "' and IsMs=1 " + sqlstr); //任课老师 ClassDt.Rows[i]["TeacherSub"] = scuBLL.GetNames("ClassId='" + ClassId + "' and IsMs=0 " + sqlstr); } //pages.list = ClassDt; } ret = Newtonsoft.Json.JsonConvert.SerializeObject(ClassDt); } return(ret); }