public static string Empowers(string TeacherList, string ResourceFolder_Id)
{
try
{
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
BLL_PrpeLesson_Person bll = new BLL_PrpeLesson_Person();
List <Model_PrpeLesson_Person> listModel = new List <Model_PrpeLesson_Person>();
ResourceFolder_Id = ResourceFolder_Id.TrimEnd(',').Filter();
TeacherList = TeacherList.TrimEnd(',').Filter();
string _dSql = @"delete PrpeLesson_Person where ResourceFolder_Id = '" + ResourceFolder_Id + @"'
and ChargePerson in ('" + TeacherList.Replace(",", "','") + "')";
foreach (string item in TeacherList.Split(','))
{
if (!string.IsNullOrEmpty(item))
{
Model_PrpeLesson_Person model = new Model_PrpeLesson_Person();
model.PrpeLesson_Person_Id = Guid.NewGuid().ToString();
model.ResourceFolder_Id = ResourceFolder_Id;
model.ChargePerson = item;
model.CreateUser = loginUser.UserId;
model.CreateTime = DateTime.Now;
listModel.Add(model);
}
}
if (listModel.Count > 0)
{
//Rc.Common.DBUtility.DbHelperSQL.Query(_dSql);
if (bll.AddPerson(listModel))
{
return("1");
}
else
{
return("");
}
}
else
{
return("1");
}
}
catch (Exception ex)
{
return("2");
}
}
public static string GetList(string KeyName, string SubjectID, string GradeID, int PageIndex, int PageSize)
{
try
{
KeyName = KeyName.Filter();
SubjectID = SubjectID.Filter();
GradeID = GradeID.Filter();
string PpstWhere = string.Empty;
HttpContext.Current.Session["StatsClassSubject"] = SubjectID;
string strWhere = " where 1=1 ";
if (!string.IsNullOrEmpty(KeyName))
{
strWhere += " and ResourceFolder_Name like '%" + KeyName + "%'";
}
strWhere += " and pl.Subject = '" + SubjectID + "'";
strWhere += " and pl.Grade = '" + GradeID + "'";
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
if (loginUser.UserPost == UserPost.普通老师)
{
PpstWhere = "inner join PrpeLesson_Person pp on pp.ResourceFolder_Id=pl.ResourceFolder_Id and pp.ChargePerson='" + loginUser.UserId + @"'";
}
DataTable dt = new DataTable();
BLL_PrpeLesson bll = new BLL_PrpeLesson();
string sql = @" select * from (select ROW_NUMBER() over(ORDER BY pl.CreateTime DESC) row, pl.*,u.UserName,u.TrueName,dc.D_Name as SubjectName,ug.UserGroup_Name as GradeName,rf.ResourceFolder_Name
from PrpeLesson pl " + PpstWhere + @"
inner join ResourceFolder rf on rf.[ResourceFolder_Id]=pl.ResourceFolder_Id
left join Common_Dict dc on dc.Common_Dict_Id=pl.Subject
left join UserGroup ug on ug.UserGroup_Id=pl.Grade
left join f_user u on u.UserId=pl.CreateUser " + strWhere + ")t where row between " + ((PageIndex - 1) * PageSize + 1) + " and " + (PageIndex * PageSize) + "";
dt = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0];
string sqlFiles = @" select * from ResourceToResourceFolder rtrf where File_Suffix<>'' and Resource_Type='" + Resource_TypeConst.集体备课文件 + "'";
DataTable dtFiles = Rc.Common.DBUtility.DbHelperSQL.Query(sqlFiles).Tables[0];
string countsql = @"select count(*) from PrpeLesson pl " + PpstWhere + @"
inner join ResourceFolder rf on rf.[ResourceFolder_Id]=pl.ResourceFolder_Id
left join Common_Dict dc on dc.Common_Dict_Id=pl.Subject
left join UserGroup ug on ug.UserGroup_Id=pl.Grade" + strWhere;
int intRecordCount = Convert.ToInt32(Rc.Common.DBUtility.DbHelperSQL.GetSingle(countsql));
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
int PersonCount = new BLL_PrpeLesson_Person().GetRecordCount("ResourceFolder_Id='" + dt.Rows[i]["ResourceFolder_Id"] + "'");
DataRow[] dr = dtFiles.Select("Book_Id='" + dt.Rows[i]["ResourceFolder_Id"] + "'");
int FilesCount = dr.Length;
listReturn.Add(new
{
ResourceFolder_Id = dt.Rows[i]["ResourceFolder_Id"].ToString(),
ResourceFolder_Name = dt.Rows[i]["ResourceFolder_Name"].ToString(),
GradeName = dt.Rows[i]["GradeName"].ToString(),
Subject = dt.Rows[i]["SubjectName"].ToString(),
PersonCount = PersonCount,
FilesCount = FilesCount,
StartTime = pfunction.ToShortDate(dt.Rows[i]["StartTime"].ToString()),
EndTime = pfunction.ToShortDate(dt.Rows[i]["EndTime"].ToString()),
CreateTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["CreateTime"].ToString()),
UserName = !string.IsNullOrEmpty(dt.Rows[i]["TrueName"].ToString()) ? dt.Rows[i]["TrueName"].ToString() : dt.Rows[i]["UserName"].ToString(),
flag = dt.Rows[i]["CreateUser"].ToString() == loginUser.UserId ? "true" : "false",
stage = dt.Rows[i]["stage"].ToString()
});
inum++;
}
if (inum > 1)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = intRecordCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
