/// <summary> /// 查询一页数据 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="subject"></param> /// <param name="userId"></param> /// <param name="date1"></param> /// <param name="date2"></param> /// <param name="order"></param> /// <returns></returns> public System.Data.DataTable GetPagerList(out int count, int size, int number, Guid currentUserId, string subject, string userId, string date1, string date2, string order) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetMailDeletedBoxSql(currentUserId, subject, userId, date1, date2); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 查询一页已发送消息阅读人员 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="messageId"></param> /// <param name="order"></param> /// <returns></returns> public System.Data.DataTable GetReadUserList(out int count, int size, int number, string messageId, string order) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetMessageReadUserListSql(messageId, order); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 查询一页我收到的数据 /// </summary> /// <returns></returns> public System.Data.DataTable GetShareMyPagerList(out int count, int size, int number, Guid userId, string fileName, string order) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetUserFileShareMySql(userId, fileName, order); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 查询一页数据 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="flowId">可管理的流程ID</param> /// <param name="whereLambda"></param> /// <param name="orderbyLambda"></param> /// <param name="isAsc"></param> /// <returns></returns> public System.Data.DataTable GetPagerList(out int count, int size, int number, List <Guid> flowIdList, string name, string type, string order, int status = -1) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetFlowSql(flowIdList, name, type, order, status); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 查询一页数据 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="whereLambda"></param> /// <param name="orderbyLambda"></param> /// <param name="isAsc"></param> /// <returns></returns> public System.Data.DataTable GetPagerList(out int count, int size, int number, string title, string address, string typeId, string order) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetApplibrarySql(title, address, typeId, order); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 根据组ID查询最新的一条 /// </summary> /// <param name="groupId"></param> /// <returns></returns> public Model.FlowTask GetMaxByGroupId(Guid groupId) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetQueryGroupMaxTaskSql(groupId); using (var db = new DataContext()) { return(db.QueryOne <Model.FlowTask>(sql, parameter)); } }
/// <summary> /// 查询一页设置 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="name"></param> /// <param name="title"></param> /// <param name="type"></param> /// <param name="order"></param> /// <returns></returns> public System.Data.DataTable GetPagerData(out int count, int size, int number, string name, string title, string type, string order) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetHomeSetSql(name, title, type, order); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 查询一页参与人员数据 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="name"></param> /// <param name="org"></param> /// <param name="order"></param> /// <returns></returns> public System.Data.DataTable GetPartakeUserPagerList(out int count, int size, int number, Guid voteId, string name, string org, string order) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetPartakeUserSql(voteId, name, org); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 查询一页数据 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="userId"></param> /// <param name="title"></param> /// <param name="dirId"></param> /// <param name="date1"></param> /// <param name="date2"></param> /// <param name="order"></param> /// <returns></returns> public System.Data.DataTable GetPagerList(out int count, int size, int number, Guid userId, string title, string dirId, string date1, string date2, string order, int read) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetDocSql(userId, title, dirId, date1, date2, order, read); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 查询一页已发送消息阅读人员 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="messageId"></param> /// <param name="status">0发送记录 1未读 2已读</param> /// <param name="order"></param> /// <returns></returns> public System.Data.DataTable GetSendList(out int count, int size, int number, string userId, string contents, string date1, string date2, string status, string order) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetMessageSendListSql(userId, contents, date1, date2, status, order); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 查询归档 /// </summary> /// <param name="count"></param> /// <param name="size"></param> /// <param name="number"></param> /// <param name="flowId"></param> /// <param name="stepName"></param> /// <param name="title"></param> /// <param name="date1"></param> /// <param name="date2"></param> /// <param name="order"></param> /// <returns></returns> public System.Data.DataTable GetPagerData(out int count, int size, int number, string flowId, string stepName, string title, string date1, string date2, string order) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetFlowArchiveSql(flowId, stepName, title, date1, date2, order); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, size, number, out count, parameter, order); return(db.GetDataTable(pagerSql, parameter)); } }
/// <summary> /// 得到一个用户的未读消息 /// </summary> /// <param name="userId"></param> /// <returns>(消息实体,未读消息条数)</returns> public (Model.Message, int count) GetNoRead(Guid userId) { using (var db = new DataContext()) { DbconnnectionSql dbconnnectionSql = new DbconnnectionSql(Utility.Config.DatabaseType); var(sql, parameter) = dbconnnectionSql.SqlInstance.GetMessageSendListSql(userId.ToString(), "", "", "", "1", "SendTime DESC"); string pagerSql = dbconnnectionSql.SqlInstance.GetPaerSql(sql, 1, 1, out int count, parameter, "SendTime DESC"); var dt = db.GetDataTable(pagerSql, parameter); Model.Message messageModel = null; if (dt.Rows.Count > 0) { messageModel = Get(dt.Rows[0]["Id"].ToString().ToGuid()); } return(messageModel, count); } }