//分组列表
public ActionResult ClassGroup(string classId, int groupId = 0, int pageIndex = 1)
{
var param_classId = Dianda.Common.QueryString.Decrypt(classId).ToInt();
IList<Member_ClassRegister> list = new List<Member_ClassRegister>();
int totalPage = 0;
string where = " mb.ClassId = " + param_classId + " and cg.ClassId= " + param_classId + " AND cgm.Delflag=0 AND mb.Delflag=0";
if (groupId == 0)//全部组
{
list = DataTableToListHelper<Dianda.AP.Model.Member_ClassRegister>
.ConvertToModel(PagingQueryBll.GetPagingDataTable(@"dbo.Class_GroupMember cgm
LEFT JOIN dbo.Class_Group cg ON cgm.GroupId=cg.Id
LEFT JOIN dbo.Member_ClassRegister mb ON cgm.AccountId=mb.AccountId", where, "cgm.CreateDate", pageIndex, out totalPage, "mb.*,CONVERT(VARCHAR,cg.ClassId)+'|'+CONVERT(VARCHAR,cg.id) AS ClassId_GroupId", 15));
}
if (groupId > 0)//单组
{
where += " and cgm.GroupId=" + groupId;
list = DataTableToListHelper<Dianda.AP.Model.Member_ClassRegister>
.ConvertToModel(PagingQueryBll.GetPagingDataTable(@"dbo.Class_GroupMember cgm
LEFT JOIN dbo.Class_Group cg ON cgm.GroupId=cg.Id
LEFT JOIN dbo.Member_ClassRegister mb ON cgm.AccountId=mb.AccountId", where, "cgm.CreateDate", pageIndex, out totalPage, "mb.*,CONVERT(VARCHAR,cg.ClassId)+'|'+CONVERT(VARCHAR,cg.id) AS ClassId_GroupId", 15));
}
if (groupId < 0)//无组
{
where = @" NOT EXISTS ( SELECT 1
FROM dbo.Class_Group cg
JOIN dbo.Class_GroupMember cgm ON cg.Id = cgm.GroupId
WHERE cg.ClassId = t.ClassId AND t.AccountId=cgm.AccountId
AND t.Status=4 AND t.ClassId=" + param_classId + " AND cg.Delflag=0 AND cgm.Delflag=0)" + " AND t.Status=4 AND t.ClassId=" + param_classId;
list = DataTableToListHelper<Dianda.AP.Model.Member_ClassRegister>
.ConvertToModel(PagingQueryBll.GetPagingDataTable(@"dbo.Member_ClassRegister t
LEFT JOIN dbo.Member_Account m ON t.AccountId=m.id
", where, "t.CreateDate", pageIndex, out totalPage, "t.*,'' AS ClassId_GroupId", 15));
}
var gBll = new Dianda.AP.BLL.Class_GroupBLL();
var allGroup = gBll.GetList(" ClassId=" + param_classId + " and Delflag=0 AND Display=1", "");
//无组人员
// where = @" NOT EXISTS ( SELECT 1
// FROM dbo.Class_Group cg
// JOIN dbo.Class_GroupMember cgm ON cg.Id = cgm.GroupId
// WHERE cg.ClassId = t.ClassId AND t.AccountId=cgm.AccountId
// AND t.Status=4 AND t.ClassId=" + classId + ")" + " AND t.Status=4 AND t.ClassId=" + classId;
// var noGrouper = DataTableToListHelper<Dianda.AP.Model.Member_BaseInfo>
// .ConvertToModel(PagingQueryBll.GetPagingDataTable(@"dbo.Member_ClassRegister t
//LEFT JOIN dbo.Member_Account m ON t.AccountId=m.id
//LEFT JOIN dbo.Member_BaseInfo mb ON m.Id=mb.AccountId", where, "mb.CreateDate", pageIndex, out totalPage, "mb.*,'' AS ClassId_GroupId"));
var noGrouper = DataTableToListHelper<Dianda.AP.Model.Member_ClassRegister>
.ConvertToModel(new Member_ClassRegisterBLL().GetNoGroupper(param_classId));
ViewBag.noGrouper = noGrouper;
ViewBag.GroupList = allGroup;
ViewBag.classId = classId;
ViewBag.pageIndex = pageIndex;
ViewBag.totalPage = totalPage;
ViewBag.basecount = 15;
var classModel = new Class_DetailBLL().GetModel(param_classId);
if (classModel != null)
{
ViewBag.CourseName = new Traning_DetailBLL().GetModel(classModel.TraningId, "").Title;
ViewBag.ClassName = classModel.Title;
var traningTeacher = new Traning_TeacherBLL().GetList(" Delflag=0 AND TraningId=" + classModel.TraningId, "");
var teacherAccount = (traningTeacher != null && traningTeacher.Count > 0) ? new PlatformManager_DetailBLL().GetModel(traningTeacher.First().PlatformManagerId.Value, "").AccountId : 0;
ViewBag.TraningTeacher = teacherAccount;
}
ViewBag.ManagerId = SiteCache.Instance.ManagerId;
return View(list);
}
