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);
}
