//需要根据不同情况建立或修改的不同学校用户和不同类型的用户,本学校用户唯一,不需要全系统唯一
protected void Page_Load(object sender, EventArgs e)
{
//if (true)//如果没对应权限,及判断用户类型是否跨界,主要防止非法篡改数据出现
//{
// Response.Write("无对应权限");
// Response.End();
//}
if (!IsPostBack)
{
//先得到操作类型
dotype = Com.Public.SqlEncStr(Request.Params["dotype"].ToString());
schid = Com.Public.SqlEncStr(Request.Params["schid"].ToString());
gradecode = Com.Public.SqlEncStr(Request.Params["gradecode"].ToString());
if (string.IsNullOrEmpty(schid) || string.IsNullOrEmpty(gradecode))//如果没有对应参数中任意一个
{
Response.Write("参数错误!");
Response.End();
}
if (dotype == "a")
{
}
else if (dotype == "e")//修改,不能修改用户的类型及学校参数
{
btnname = "保存";
classid = Com.Public.SqlEncStr(Request.Params["classid"].ToString());
if (string.IsNullOrEmpty(classid))
{
Response.Write("无对应修改的记录!");
Response.End();
}
//获取修改的对应用户的
SchSystem.BLL.SchClassInfo sgibll = new SchSystem.BLL.SchClassInfo();
SchSystem.Model.SchClassInfo sgimodel = sgibll.GetModel(int.Parse(classid));
if (sgimodel != null && sgimodel.ClassId > 0)
{
umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(sgimodel);
}
else
{
Response.Write("无该记录!");
Response.End();
}
}
else//不在添加及修改之内,则返回
{
Response.Write("没有可供确认的操作类型!");
Response.End();
}
/*//判断跨界操作的可能性
* if (!Com.Public.isVa(schid, systype))
* {
* Response.Write("出错,用户非法跨界操作!");
* Response.End();
* }*/
SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo();
schname = schbll.GetSchName(int.Parse(schid));
#region 获取当前学校的老师
//当前班级任课老师及班主任
SchSystem.BLL.SchClassUser userclassbll = new SchSystem.BLL.SchClassUser();
DataTable dtclassuser = userclassbll.GetList("UserName id,SubCode subcode,UserTname name,IsMs isms", "ClassId=" + Com.Public.SqlEncStr(classid)).Tables[0];
//当前学校老师
SchSystem.BLL.SchUserDeptV userbll = new SchSystem.BLL.SchUserDeptV();
DataTable dtuser = userbll.GetList("DeptId,DepartName,UserId,UserTname", "Stat=1 and Ustat=1 and SchId=" + Com.Public.SqlEncStr(schid)).Tables[0];
//DataRow[] dtRow = dtuser.Select();
StringBuilder sb = new StringBuilder();
//DataView dv = dtuser.DefaultView;
//DataTable datadpt = dv.ToTable(true, "Pid,DeptId,DepartName");
SchSystem.BLL.SchDepartInfo dptbll = new SchSystem.BLL.SchDepartInfo();
DataTable dt = dptbll.GetList(" 'd_'+convert(varchar(20),Pid) pId,'d_'+convert(varchar(20),DepartId) id,DepartName name,'0' isms,'' subcode,'false' checked,'true' nochecks", "SchId=" + schid + " and Stat=1 Order by OrderId,DepartName").Tables[0];
DataTable dtdptuser = dt.Clone();
dtdptuser.Columns["nochecks"].ColumnName = "nocheck";
if (dt.Rows.Count > 0)
{
//合并人员到部门表
for (int i = 0; i < dt.Rows.Count; i++)
{
dtdptuser.Rows.Add(dt.Rows[i].ItemArray);
//获取该部门下的人员
DataRow[] drss = dtuser.Select("DeptId='" + dt.Rows[i]["id"].ToString().Replace("d_", "") + "'");
if (drss.Length > 0)
{
foreach (DataRow item in drss)
{
DataRow dr = dtdptuser.NewRow();
dr["id"] = item["UserId"].ToString();
dr["name"] = item["UserTname"].ToString();
dr["pId"] = "d_" + item["DeptId"].ToString();
dtdptuser.Rows.Add(dr);
}
}
}
deptusers = Newtonsoft.Json.JsonConvert.SerializeObject(dtdptuser);
//DataRow[] drs = dt.Select("Pid=0");
//foreach (DataRow dr in drs)
//{
// string nodeID = dr["ID"].ToString();
// string nodeText = dr["Name"].ToString();
// nodeText = "├" + nodeText;
// string blank = " ";
// sb.Append("<option value=\"p_" + nodeID + "\">" + nodeText + "</option>");
// DataRow[] drusers = dtuser.Select("DeptId='" + nodeID + "'");
// if (drusers != null && drusers.Length > 0)
// {
// foreach (DataRow druser in drusers)
// {
// sb.Append("<option style=\"color:blue\" value=\"u_" + druser["UserId"].ToString() + "\">" + blank + " " + druser["UserTname"].ToString() + "</option>");
// }
// }
// BindSon(sb, nodeID, dt, blank, dtuser);
//}
}
//depts = sb.ToString();
deptss = Newtonsoft.Json.JsonConvert.SerializeObject(dtclassuser);
subsdrp = Com.Public.GetDrp("sub", schid, "1", false, "", "");
#endregion
#region 获取年级领导
SchSystem.BLL.SchGradeUsers usergradebll = new SchSystem.BLL.SchGradeUsers();
gradeboss = usergradebll.GetNames("GradeId='" + Com.Public.SqlEncStr(gradecode) + "'");
gradesdrp = Com.Public.GetDrp("grade", schid, "0", false, "", "");
#endregion
}
}
//需要根据不同情况建立或修改的不同学校用户和不同类型的用户,本学校用户唯一,不需要全系统唯一
protected void Page_Load(object sender, EventArgs e)
{
//if (true)//如果没对应权限,及判断用户类型是否跨界,主要防止非法篡改数据出现
//{
// Response.Write("无对应权限");
// Response.End();
//}
if (!IsPostBack)
{
//先得到操作类型
dotype = Com.Public.SqlEncStr(Request.Params["dotype"].ToString());
schid = Com.Public.SqlEncStr(Request.Params["schid"].ToString());
gradecode = Com.Public.SqlEncStr(Request.Params["gradecode"].ToString());
if (string.IsNullOrEmpty(schid) || string.IsNullOrEmpty(gradecode))//如果没有对应参数中任意一个
{
Response.Write("参数错误!");
Response.End();
}
if (dotype == "a")
{
}
else if (dotype == "e")//修改,不能修改用户的类型及学校参数
{
btnname = "修改";
classid = Com.Public.SqlEncStr(Request.Params["classid"].ToString());
if (string.IsNullOrEmpty(classid))
{
Response.Write("无对应修改的记录!");
Response.End();
}
//获取修改的对应用户的
SchSystem.BLL.SchClassInfo sgibll = new SchSystem.BLL.SchClassInfo();
SchSystem.Model.SchClassInfo sgimodel = sgibll.GetModel(int.Parse(classid));
if (sgimodel != null && sgimodel.ClassId > 0)
{
umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(sgimodel);
}
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.SchGradeUsers usergradebll = new SchSystem.BLL.SchGradeUsers();
gradeboss = usergradebll.GetNames("GradeId in ( select GradeId from SchGradeInfo where GradeCode=" + Com.Public.SqlEncStr(gradecode) + " and schid=" + schid + ")");
gradesdrp = Com.Public.GetDrp("grade", schid, "0", false, "", "");
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,'0' isms,'' subcode", "SchId=" + Com.Public.SqlEncStr(schid) + " and Stat=1 Order by OrderId").Tables[0];
dtdpt.Columns["nochecks"].ColumnName = "nocheck";
DataTable dtdptuser = dtdpt.Clone();
StringBuilder sb = new StringBuilder();
if (dtdpt.Rows.Count > 0)
{
SchSystem.BLL.SchClassUser userclassbll = new SchSystem.BLL.SchClassUser();
DataTable dtclassuser = userclassbll.GetList("UserName,SubCode,IsMs", "ClassId=" + Com.Public.SqlEncStr(classid)).Tables[0];
//获取该学校的所有人员
SchSystem.BLL.SchUserDeptV userbll = new SchSystem.BLL.SchUserDeptV();
DataTable dtuser = userbll.GetList("DeptId ,UserName,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 dr = dtdptuser.NewRow();
dr["id"] = "u_" + item["UserName"].ToString();
dr["name"] = item["UserTname"].ToString();
dr["pId"] = item["DeptId"].ToString();
//如果是被绑定了,则勾选
DataRow[] drsclassuser = dtclassuser.Select("UserName='******'");
if (drsclassuser.Length > 0)
{
dr["isms"] = drsclassuser[0]["IsMs"].ToString();
dr["subcode"] = drsclassuser[0]["SubCode"].ToString();
dr["checked"] = "true";
}
dtdptuser.Rows.Add(dr);
}
}
}
}
SchSystem.BLL.SchUserInfo sui = new SchSystem.BLL.SchUserInfo();
DataTable dtsui = sui.GetList("*", "Stat=1 and SchId=" + Com.Public.SqlEncStr(schid)).Tables[0];
DataRow[] drsui = dtsui.Select();
foreach (DataRow item in drsui)
{
sb.Append("<option value=\"u_" + item["UserName"].ToString() + "\">" + item["UserTname"].ToString() + "</option>");
}
tec = sb.ToString();
depts = Newtonsoft.Json.JsonConvert.SerializeObject(dtdptuser);
subsdrp = Com.Public.GetDrp("sub", schid, "1", false, "", "");
#endregion
#region 获取部门人员列表
/*SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo();
* schname = schbll.GetSchName(int.Parse(schid));
* //获取年级领导
* SchSystem.BLL.SchGradeUsers usergradebll = new SchSystem.BLL.SchGradeUsers();
* gradeboss = usergradebll.GetNames("GradeId in ( select GradeId from SchGradeInfo where GradeCode=" + Com.Public.SqlEncStr(gradecode) + " and schid=" + schid + ")");
* gradesdrp = Com.Public.GetDrp("grade", schid, "0", false, "", "");
* SchSystem.BLL.SchDepartInfo sdiBll = new SchSystem.BLL.SchDepartInfo();
* //获取部门列表
* DataTable dtdpt = sdiBll.GetList("Pid pId,convert(varchar(20),DepartId) id,DepartName name,'false' checked,'false' checked,'true' nochecks,'0' isms,'' subcode", "SchId=" + Com.Public.SqlEncStr(schid) + " and Stat=1 Order by OrderId").Tables[0];
* dtdpt.Columns["nochecks"].ColumnName = "nocheck";
* DataTable dtdptuser = dtdpt.Clone();
* StringBuilder sb = new StringBuilder();
* if (dtdpt.Rows.Count > 0)
* {
* SchSystem.BLL.SchClassUser userclassbll = new SchSystem.BLL.SchClassUser();
* DataTable dtclassuser = userclassbll.GetList("UserName,SubCode,IsMs", "ClassId=" + Com.Public.SqlEncStr(classid)).Tables[0];
* //获取该学校的所有人员
* SchSystem.BLL.SchUserDeptV userbll = new SchSystem.BLL.SchUserDeptV();
* DataTable dtuser = userbll.GetList("DeptId ,UserName,UserTname", "Stat=1 and Ustat=1 and SchId=" + Com.Public.SqlEncStr(schid)).Tables[0];
* //合并人员到部门表
* int z = 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)
* {
* sb.Append("<option value=\"u_"+z+"_" + item["UserName"].ToString() + "\">" + item["UserTname"].ToString() + "</option>");
* DataRow dr = dtdptuser.NewRow();
* dr["id"] = "u_" + z + "_" + item["UserName"].ToString();
* dr["name"] = item["UserTname"].ToString();
* dr["pId"] = item["DeptId"].ToString();
* //如果是被绑定了,则勾选
* DataRow[] drsclassuser = dtclassuser.Select("UserName='******'");
* if (drsclassuser.Length > 0)
* {
* dr["isms"] = drsclassuser[0]["IsMs"].ToString();
* dr["subcode"] = drsclassuser[0]["SubCode"].ToString();
* dr["checked"] = "true";
* }z++;
* dtdptuser.Rows.Add(dr);
*
* }
* }
* }
*
* }
* tec = sb.ToString();
* depts = Newtonsoft.Json.JsonConvert.SerializeObject(dtdptuser);
* subsdrp = Com.Public.GetDrp("sub", schid, "1", false, "", "");*/
#endregion
}
}
