protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dotype = Request.Params["dotype"].ToString();
schid = Com.Session.schid;
#region 编辑绑定查询
if (dotype == "e")
{
stuid = Request.Params["id"].ToString();//
SchSystem.BLL.SchStuInfoV bll_stu = new SchSystem.BLL.SchStuInfoV();
DataTable dt = bll_stu.GetList("GradeId,GradeName,ClassId,ClassName,StuId,StuName,CardNo,StuNo,Sex,OldClassId,TestNo,TelNo,StudyType,Addr", "StuId=" + Com.Public.SqlEncStr(stuid)).Tables[0];
stugradeid = dt.Rows[0]["GradeId"].ToString();
stuclassid = dt.Rows[0]["ClassId"].ToString();
stuname = dt.Rows[0]["StuName"].ToString();
stugrade = dt.Rows[0]["GradeName"].ToString();
stuclass = dt.Rows[0]["ClassName"].ToString();
stucode = dt.Rows[0]["TestNo"].ToString();
stusex = dt.Rows[0]["Sex"].ToString();
stucard = dt.Rows[0]["CardNo"].ToString();
stutel = dt.Rows[0]["TelNo"].ToString();
stuaddr = dt.Rows[0]["Addr"].ToString();
stustp = dt.Rows[0]["StudyType"].ToString();
stuocls = dt.Rows[0]["OldClassId"].ToString();
SchSystem.BLL.SchStuGenUV bll_stugen = new SchSystem.BLL.SchStuGenUV();
DataTable dtgen = bll_stugen.GetList("Relation,GenName,TelNo", "StuId=" + Com.Public.SqlEncStr(stuid)).Tables[0];
if (dtgen != null && dtgen.Rows.Count > 0)
{
stug1name = dtgen.Rows[0]["GenName"].ToString();
stug1rl = dtgen.Rows[0]["Relation"].ToString();
stug1rt = dtgen.Rows[0]["TelNo"].ToString();
if (dtgen.Rows.Count > 1)
{
stug2name = dtgen.Rows[1]["GenName"].ToString();
stug2rl = dtgen.Rows[1]["Relation"].ToString();
stug2rt = dtgen.Rows[1]["TelNo"].ToString();
}
}
stuno = "00000000".Substring(0, 8 - stuid.Length) + stuid;
}
else
{
stugradeid = Request.Params["gradecode"].ToString();
stuclassid = Request.Params["classid"].ToString();
}
drpgrade = Com.Public.GetDrpAreaClassMaster("4", Com.Session.schid, ref stugradeid, false);
drpclass = Com.Public.GetDrpAreaClassMaster("5", stugradeid, ref stuclassid, false);
StudentList.namepack npgrade = (StudentList.namepack)Newtonsoft.Json.JsonConvert.DeserializeObject <StudentList.namepack>(getusers("1", stugradeid));
stugradeboss = npgrade.gradeboss;
StudentList.namepack np = (StudentList.namepack)Newtonsoft.Json.JsonConvert.DeserializeObject <StudentList.namepack>(getusers("2", stuclassid));
stuclassms = np.classms;
stuclasstec = np.classtec;
#endregion
}
}
public static string page(string PageIndex, string PageSize, string ClassId, string SchId, string Stuname, string GradeId)
{
Com.Public.PageModelResp pages = new Com.Public.PageModelResp();
pages.PageIndex = int.Parse(PageIndex);
pages.PageSize = int.Parse(PageSize);
SchSystem.BLL.SchClassUser bllclassuser = new SchSystem.BLL.SchClassUser();
SchSystem.BLL.SchGradeUsers bllgradeuser = new SchSystem.BLL.SchGradeUsers();
string strWhere = "StuStat=1 and SchId=" + Com.Public.SqlEncStr(SchId);
if (!string.IsNullOrEmpty(Stuname))
{
strWhere += " and stuname LIKE '%" + Com.Public.SqlEncStr(Stuname) + "%'";
}
if (GradeId != "-1" && GradeId != "")//获取当前用户的所有年级
{
strWhere += " and GradeId=" + Com.Public.SqlEncStr(GradeId);
}
if (ClassId != "-1" && ClassId != "")//获取当前用户的所有班级
{
strWhere += " and ClassId=" + Com.Public.SqlEncStr(ClassId);
}
int RowCount = 0; int PageCount = 0;//left('00000000',8-len(StuId))+convert(varchar(10),StuId)
string cols = " GradeId,ClassId,GradeName,ClassName,StuId,TestNo,StuName,CardNo,Sex,StuNo,TelNo,StudyType,LoginName,'' GenNameO,'' GenLoginNameO ,'' GenTelO,'' GenNameT,'' GenLoginNameT ,'' GenTelT,'0' isdel,'0' isedit,'0' islook";
SchSystem.BLL.SchStuInfoV bllstuv = new SchSystem.BLL.SchStuInfoV();
DataTable dtstuv = bllstuv.GetListCols(cols, strWhere, "StuName", "ASC", pages.PageIndex, pages.PageSize, ref RowCount, ref PageCount).Tables[0];
pages.PageCount = PageCount;
pages.RowCount = RowCount;
if (dtstuv != null && dtstuv.Rows.Count > 0)
{
SchSystem.BLL.SchStuGenUV bllstugenv = new SchSystem.BLL.SchStuGenUV();
for (int i = 0; i < dtstuv.Rows.Count; i++)//将家长添加上,并且把权限加上
{
//获取家长
DataTable dtgenv = bllstugenv.GetList("GenName,LoginName,TelNo,Relation", "Stat=1 and StuId=" + dtstuv.Rows[i]["StuId"].ToString()).Tables[0];
if (dtgenv != null && dtgenv.Rows.Count > 0)
{
dtstuv.Rows[i]["GenNameO"] = dtgenv.Rows[0]["GenName"].ToString();
dtstuv.Rows[i]["GenTelO"] = dtgenv.Rows[0]["TelNo"].ToString();
dtstuv.Rows[i]["GenLoginNameO"] = dtgenv.Rows[0]["LoginName"].ToString();
if (dtgenv.Rows.Count > 1)
{
dtstuv.Rows[i]["GenNameT"] = dtgenv.Rows[1]["GenName"].ToString();
dtstuv.Rows[i]["GenTelT"] = dtgenv.Rows[1]["TelNo"].ToString();
dtstuv.Rows[i]["GenLoginNameT"] = dtgenv.Rows[1]["LoginName"].ToString();
}
}
pages.list = dtstuv;
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(pages));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
stuid = Request.Params["id"].ToString();//
SchSystem.BLL.SchStuInfoV bll_stu = new SchSystem.BLL.SchStuInfoV();
DataTable dt = bll_stu.GetList("GradeId,GradeName,ClassId,ClassName,StuId,StuName,CardNo,StuNo,Sex,OldClassId,TestNo,TelNo,StudyType,Addr", "StuId=" + Com.Public.SqlEncStr(stuid)).Tables[0];
string gradeid = dt.Rows[0]["GradeId"].ToString();
string classid = dt.Rows[0]["ClassId"].ToString();
stuname = dt.Rows[0]["StuName"].ToString();
stugrade = dt.Rows[0]["GradeName"].ToString();
stuclass = dt.Rows[0]["ClassName"].ToString();
stucode = dt.Rows[0]["TestNo"].ToString();
stusex = dt.Rows[0]["Sex"].ToString() == "0"?"女":"男";
stucard = dt.Rows[0]["CardNo"].ToString();
stutel = dt.Rows[0]["TelNo"].ToString();
stuaddr = dt.Rows[0]["Addr"].ToString();
stustp = dt.Rows[0]["StudyType"].ToString() == "0" ? "否" : "是";;
stuocls = dt.Rows[0]["OldClassId"].ToString();
SchSystem.BLL.SchStuGenUV bll_stugen = new SchSystem.BLL.SchStuGenUV();
DataTable dtgen = bll_stugen.GetList("Relation,GenName,TelNo", "StuId=" + Com.Public.SqlEncStr(stuid)).Tables[0];
if (dtgen != null && dtgen.Rows.Count > 0)
{
stug1name = dtgen.Rows[0]["GenName"].ToString();
stug1rl = dtgen.Rows[0]["Relation"].ToString();
stug1rt = dtgen.Rows[0]["TelNo"].ToString();
if (dtgen.Rows.Count > 1)
{
stug2name = dtgen.Rows[1]["GenName"].ToString();
stug2rl = dtgen.Rows[1]["Relation"].ToString();
stug2rt = dtgen.Rows[1]["TelNo"].ToString();
}
}
StudentList.namepack npgrade = (StudentList.namepack)Newtonsoft.Json.JsonConvert.DeserializeObject <StudentList.namepack>(getusers("1", gradeid));
stugradeboss = npgrade.gradeboss;
StudentList.namepack np = (StudentList.namepack)Newtonsoft.Json.JsonConvert.DeserializeObject <StudentList.namepack>(getusers("2", classid));
stuclassms = np.classms;
stuclasstec = np.classtec;
stuid = "00000000".Substring(0, 8 - stuid.Length) + stuid;
}
}
public static string page(string PageIndex, string PageSize, string ClassId, string SchId, string Stuname, string GradeId)
{
bool islist = false;
Com.Public.PageModelResp pages = new Com.Public.PageModelResp();
pages.PageIndex = int.Parse(PageIndex);
pages.PageSize = int.Parse(PageSize);
SchSystem.BLL.SchClassUser bllclassuser = new SchSystem.BLL.SchClassUser();
SchSystem.BLL.SchGradeUsers bllgradeuser = new SchSystem.BLL.SchGradeUsers();
#region 添加按钮和列表显示权限
pages.isadd = false;
if (Com.SoureSession.Souresystype == "1")//学校超管
{
islist = true;
if (GradeId == "-1" || ClassId == "-1" || GradeId == "" || ClassId == "") //系统编辑状态为0,或者年级,班级其中一个选择了全部,则不允许出现添加按钮
{
pages.isadd = false;
}
else
{
pages.isadd = true;
}
}
else//普通老师账号
{
if (bllclassuser.ExistsIsMs(Com.Public.SqlEncStr(ClassId), Com.SoureSession.Soureuserid, Com.SoureSession.Soureschid, 1) == true)//班主任
{
if (Com.Session.appeditstat == "1")
{
pages.isadd = true;
}
islist = true;
}
else
{
pages.isadd = false;
if (bllgradeuser.ExistsGrade(Com.Public.SqlEncStr(GradeId), Com.SoureSession.Soureschid, Com.SoureSession.Soureuserid) == true)//年级主任
{
islist = true;
}
if (bllclassuser.ExistsIsMs(Com.Public.SqlEncStr(ClassId), Com.SoureSession.Soureuserid, Com.SoureSession.Soureschid, 0) == true)//任课老师
{
islist = true;
}
}
if (Com.Public.IsUserVal(Com.Session.userrolestr, 2))
{
islist = true;
}
;
}
#endregion
if (islist)
{
string strWhere = "StuStat=1 ";
if (!string.IsNullOrEmpty(Stuname))
{
strWhere += " and stuname LIKE '%" + Com.Public.SqlEncStr(Stuname) + "%'";
}
if (GradeId == "-1" || GradeId == "")//获取当前用户的所有年级
{
strWhere += " and GradeId in (" + Com.Public.GetIdsAllStu("4", Com.SoureSession.Soureschid) + ")";
}
else
{
strWhere += " and GradeId=" + Com.Public.SqlEncStr(GradeId);
}
if (ClassId == "-1" || ClassId == "")//获取当前用户的所有班级
{
if (GradeId == "")
{
GradeId = "-1";
}
strWhere += " and ClassId in (" + Com.Public.GetIdsAllStu("5", Com.Public.SqlEncStr(GradeId)) + ")";
}
else
{
strWhere += " and ClassId=" + Com.Public.SqlEncStr(ClassId);
}
int RowCount = 0; int PageCount = 0;//left('00000000',8-len(StuId))+convert(varchar(10),StuId)
string cols = " GradeId,ClassId,GradeName,ClassName,StuId,TestNo,StuName,CardNo,Sex,StuNo,TelNo,StudyType,LoginName,'' GenNameO,'' GenLoginNameO ,'' GenTelO,'' GenNameT,'' GenLoginNameT ,'' GenTelT,'0' isdel,'0' isedit,'0' islook";
SchSystem.BLL.SchStuInfoV bllstuv = new SchSystem.BLL.SchStuInfoV();
DataTable dtstuv = bllstuv.GetListCols(cols, strWhere, "StuName", "ASC", pages.PageIndex, pages.PageSize, ref RowCount, ref PageCount).Tables[0];
pages.PageCount = PageCount;
pages.RowCount = RowCount;
if (dtstuv != null && dtstuv.Rows.Count > 0)
{
SchSystem.BLL.SchStuGenUV bllstugenv = new SchSystem.BLL.SchStuGenUV();
for (int i = 0; i < dtstuv.Rows.Count; i++)//将家长添加上,并且把权限加上
{
//获取家长
DataTable dtgenv = bllstugenv.GetList("GenName,LoginName,TelNo,Relation", "Stat=1 and StuId=" + dtstuv.Rows[i]["StuId"].ToString()).Tables[0];
if (dtgenv != null && dtgenv.Rows.Count > 0)
{
dtstuv.Rows[i]["GenNameO"] = dtgenv.Rows[0]["GenName"].ToString();
dtstuv.Rows[i]["GenTelO"] = dtgenv.Rows[0]["TelNo"].ToString();
dtstuv.Rows[i]["GenLoginNameO"] = dtgenv.Rows[0]["LoginName"].ToString();
if (dtgenv.Rows.Count > 1)
{
dtstuv.Rows[i]["GenNameT"] = dtgenv.Rows[1]["GenName"].ToString();
dtstuv.Rows[i]["GenTelT"] = dtgenv.Rows[1]["TelNo"].ToString();
dtstuv.Rows[i]["GenLoginNameT"] = dtgenv.Rows[1]["LoginName"].ToString();
}
}
//权限
if (Com.SoureSession.Souresystype == "1") //学校超管,可看
{
if (Com.Session.appeditstat == "1") //系统未被屏蔽编辑功能,则可编辑和删除
{
dtstuv.Rows[i]["isdel"] = "1";
dtstuv.Rows[i]["isedit"] = "1";
}
dtstuv.Rows[i]["islook"] = "1";
}
else//普通老师账号
{
if (bllclassuser.ExistsIsMs(dtstuv.Rows[i]["ClassId"].ToString(), Com.SoureSession.Soureuserid, Com.SoureSession.Soureschid, 1) == true)//班主任可查看
{
dtstuv.Rows[i]["islook"] = "1";
if (Com.Session.appeditstat == "1")
{
dtstuv.Rows[i]["isdel"] = "1";
dtstuv.Rows[i]["isedit"] = "1";
}
}
else
{
if (bllgradeuser.ExistsGrade(dtstuv.Rows[i]["GradeId"].ToString(), Com.SoureSession.Soureschid, Com.SoureSession.Soureuserid) == true)//年级主任
{
islist = true;
dtstuv.Rows[i]["islook"] = "1";
}
}
if (Com.Public.IsUserVal(Com.Session.userrolestr, 2))
{
dtstuv.Rows[i]["islook"] = "1";
islist = true;
}
}
}
pages.list = dtstuv;
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(pages));
}
