private SyncResponse GetUserFinallyOperationRecord(SyncRequest request)
{
PageInit submitData = JsonHelper.DecodeJson <PageInit>(request.Data);
using (var db = new fz_wisdomcampusEntities())
{
clr_pageInit page = db.clr_pageInit.FirstOrDefault(p => p.UserID == submitData.UserID && p.AspxName == "Common");
return(SyncResponse.GetResponse(request, page));
}
}
public PageInit GET(string UserID, int SubjectID, int GradeID)
{
PageInit m = new PageInit();
clr_electronic_book eb = null;
List <r_resource> lRes = null;
using (var db = new fz_wisdomcampusEntities())
{
eb = db.clr_electronic_book.Where(w => w.UserID == UserID && w.SubjectID == SubjectID && w.GradeID == GradeID).FirstOrDefault();
}
//using (var db1 = new fz_resourceEntities())
//{
// lRes = db1.r_resource.Where(w => w.ResourceCreaterID == UserID && w.SubjectID == SubjectID && w.GradeID == eb.GradeID).ToList();
//}
//foreach (var ds in eb)
//{
// m.Add(new PageInit
// {
// BookID = ds.BookID,
// BookName = ds.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)ds.BookID),
// UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)ds.BookID).Select(s => new UnitInfo
// {
// UnitID = s.Id,
// UnitName = s.Name
// }).ToList(),
// UserID = ds.UserID
// });
//}
m.UserID = UserID;
m.BookID = eb.BookID;
m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID);
//m.UnitInfo = lRes.Select(s => new UnitInfo
//{
// UnitID = s.Catalog,
// UnitName = s.KeyWords
//}).ToList();
m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo
{
UnitID = s.Id,
UnitName = s.Name
}).ToList();
return(m);
}
/// <summary>
/// 学生端获取目录信息
/// </summary>
/// <param name="UserID">131b1f49-7064-4fba-a380-9c169701a818</param>
/// <param name="SubjectID"></param>
/// <returns></returns>
public PageInit GET(string UserID, int SubjectID, int GradeID)
{
string tid = "";
int? grade = null;
List <r_resource> lRes = null;
using (var db1 = new FzDatabase.Basic.fz_basicEntities())
{
var stu = db1.sy_student.Where(w => w.UserId == UserID.Trim()).FirstOrDefault();
grade = stu.sy_grade.SGradeId + 1;
tid = db1.sy_teacher_and_class_and_subject.Where(w => w.ClassId == stu.Class && w.Subject == SubjectID).Select(s => s.sy_teacher.UserId).FirstOrDefault();
}
using (var db2 = new fz_resourceEntities())
{
lRes = db2.r_resource.Where(w => w.ResourceCreaterID == tid && w.SubjectID == SubjectID && w.GradeID == GradeID).ToList();
}
PageInit m = new PageInit();
clr_electronic_book eb = null;
using (var db = new fz_wisdomcampusEntities())
{
eb = db.clr_electronic_book.Where(w => w.UserID == tid && w.GradeID == GradeID && w.SubjectID == SubjectID).FirstOrDefault();
}
m.UserID = tid;
m.BookID = eb.BookID;
m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID);
List <UnitInfo> nonDuplicateList1 = lRes.Select(s => new UnitInfo
{
UnitID = s.Catalog,
UnitName = GetUnitNameStu(s.Catalog)
}).Distinct().ToList();
List <UnitInfo> nonDuplicateList2 = nonDuplicateList1.Where((x, i) => nonDuplicateList1.FindIndex(z => z.UnitID == x.UnitID) == i).ToList();//Lambda表达式去重
m.UnitInfo = nonDuplicateList2;
//m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo
//{
// UnitID = s.Id,
// UnitName = s.Name
//}).ToList();
return(m);
}
/// <summary>
/// 老师端获取目录信息
/// </summary>
/// <param name="UserID"></param>
/// <param name="SubjectID"></param>
/// <param name="GradeID"></param>
/// <returns></returns>
public PageInit GET(string UserID, int SubjectID, int GradeID)
{
PageInit m = new PageInit();
clr_electronic_book eb = null;
List <r_resource> lRes = null;
using (var db = new fz_wisdomcampusEntities())
{
eb = db.clr_electronic_book.Where(w => w.UserID == UserID && w.SubjectID == SubjectID && w.GradeID == GradeID).FirstOrDefault();
}
using (var db1 = new fz_resourceEntities())
{
lRes = db1.r_resource.Where(w => w.ResourceCreaterID == UserID && w.SubjectID == SubjectID && w.GradeID == eb.GradeID).ToList();
}
m.UserID = UserID;
m.BookID = eb.BookID;
m.BookName = GetBookName(eb.BookID);
List <UnitInfo> nonDuplicateList1 = lRes.Select(s => new UnitInfo
{
UnitID = s.Catalog,
UnitName = GetUnitNameTech(s.Catalog)
}).Distinct().ToList();
List <UnitInfo> nonDuplicateList2 = nonDuplicateList1.Where((x, i) => nonDuplicateList1.FindIndex(z => z.UnitID == x.UnitID) == i).ToList();//Lambda表达式去重
m.UnitInfo = nonDuplicateList2;
//m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo
//{
// UnitID = s.Id,
// UnitName = s.Name
//}).ToList();
//string UnitID = null;
//foreach (UnitInfo un in m.UnitInfo)
//{
// if (un.UnitID == UnitID)
// {
// }
// UnitID=
//}
return(m);
}
/// <summary>
/// 老师获取单元目录
/// </summary>
/// <param name="UserID"></param>
/// <param name="SubjectID"></param>
/// <returns></returns>
public PageInit GET(string UserID, int SubjectID, int GradeID)
{
string tid = UserID;
PageInit m = new PageInit();
clr_electronic_book eb = null;
using (var db = new fz_wisdomcampusEntities())
{
eb = db.clr_electronic_book.Where(w => w.UserID == tid && w.GradeID == GradeID).FirstOrDefault();
}
m.UserID = tid;
m.BookID = eb.BookID;
m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID);
m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo
{
UnitID = s.Id,
UnitName = s.Name
}).ToList();
return(m);
}
public override void Startup(IService service)
{
ContentRepository = new ContentRepository();
CategoryClassRepository = new CategoryClassRepository();
CategoryRepository = new CategoryRepository();
DepartmentRepository = new DepartmentRepository();
IdentifierRuleRepository = new IdentifierRuleRepository();
IdentifierSeqRepository = new IdentifierSeqRepository();
service
.AddContentModel(ContentRepository.TableName, ContentRepository.TableColumns, ContentRepository.InputStyles)
.AddDatabaseTable(CategoryClassRepository.TableName, CategoryClassRepository.TableColumns)
.AddDatabaseTable(CategoryRepository.TableName, CategoryRepository.TableColumns)
.AddDatabaseTable(DepartmentRepository.TableName, DepartmentRepository.TableColumns)
.AddDatabaseTable(IdentifierRuleRepository.TableName, IdentifierRuleRepository.TableColumns)
.AddDatabaseTable(IdentifierSeqRepository.TableName, IdentifierSeqRepository.TableColumns)
.AddSiteMenu(siteId => new Menu
{
Text = "主动信息公开",
IconClass = "ion-ios-book",
Menus = new List <Menu>
{
new Menu
{
Text = "信息采集",
Href = PageMain.GetRedirectUrl(siteId, Context.UtilsApi.GetAdminUrl($"cms/pageContentAdd.aspx?siteId={siteId}"))
},
new Menu
{
Text = "信息管理",
Href = PageMain.GetRedirectUrl(siteId, Context.UtilsApi.GetAdminUrl($"cms/contents.cshtml?siteId={siteId}"))
},
new Menu
{
Text = "信息审核",
Href = PageMain.GetRedirectUrl(siteId, Context.UtilsApi.GetAdminUrl($"cms/pageContentSearch.aspx?isCheckOnly=true&siteId={siteId}"))
},
new Menu
{
Text = "分类法管理",
Href = PageInit.GetRedirectUrl(siteId, PageCategoryMain.GetRedirectUrl(siteId))
},
new Menu
{
Text = "索引号生成规则",
Href = PageInit.GetRedirectUrl(siteId, PageIdentifierRule.GetRedirectUrl(siteId))
},
new Menu
{
Text = "重新生成索引号",
Href = PageInit.GetRedirectUrl(siteId, PageIdentifierCreate.GetRedirectUrl(siteId))
},
new Menu
{
Text = "部门设置",
Href = "pages/departments.html"
},
new Menu
{
Text = "信息公开设置",
Href = PageInit.GetRedirectUrl(siteId, PageSettings.GetRedirectUrl(siteId))
},
new Menu
{
Text = "数据统计分析",
Href = PageInit.GetRedirectUrl(siteId, PageAnalysis.GetRedirectUrl(siteId))
}
}
});
service.ContentFormSubmit += Service_ContentFormSubmited; // 页面提交处理函数
service.ContentFormLoad += Service_ContentFormLoad; // // 页面加载处理函数
}
// 插件被激活时初始化工作
public override void Startup(IService service)
{
PluginId = Id;
service.AddContentModel(ContentDao.TableName, ContentDao.Columns) // 插件对应的内容模型表
.AddDatabaseTable(ChannelDao.TableName, ChannelDao.Columns) // 插件需要用到的其他表结构
.AddDatabaseTable(LogDao.TableName, LogDao.Columns)
.AddDatabaseTable(PermissionsDao.TableName, PermissionsDao.Columns)
.AddDatabaseTable(RemarkDao.TableName, RemarkDao.Columns)
.AddDatabaseTable(ReplyDao.TableName, ReplyDao.Columns)
.AddDatabaseTable(TypeDao.TableName, TypeDao.Columns)
.AddSiteMenu(siteId => new Menu
{
Text = "互动交流",
IconClass = "ion-chatbox-working",
Menus = new List <Menu>
{
new Menu
{
Text = "待受理办件",
Href = PageMain.GetRedirectUrl(siteId, PageListAccept.GetRedirectUrl(siteId, 0))
},
new Menu
{
Text = "待办理办件",
Href = PageMain.GetRedirectUrl(siteId, PageListReply.GetRedirectUrl(siteId, 0))
},
new Menu
{
Text = "待审核办件",
Href = PageMain.GetRedirectUrl(siteId, PageListCheck.GetRedirectUrl(siteId, 0))
},
new Menu
{
Text = "所有办件",
Href = PageMain.GetRedirectUrl(siteId, PageListAll.GetRedirectUrl(siteId, 0))
},
new Menu
{
Text = "新增办件",
Href = PageMain.GetRedirectUrl(siteId, $"@/cms/pageContentAdd.aspx?siteId={siteId}")
},
new Menu
{
Text = "互动交流设置",
Href = PageInit.GetRedirectUrl(siteId, PageConfiguration.GetRedirectUrl(siteId))
},
new Menu
{
Text = "前台页面标签",
Href = PageInit.GetRedirectUrl(siteId, PageFormStyle.GetRedirectUrl(siteId))
},
new Menu
{
Text = "数据统计分析",
Href = PageInit.GetRedirectUrl(siteId, PageAnalysis.GetRedirectUrl(siteId))
}
}
}); // 插件站点菜单
service.ContentFormSubmit += Service_ContentFormSubmited; // 页面提交处理函数
service.ContentFormLoad += Service_ContentFormLoad; // 页面加载处理函数
}
