/// <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);
}
}
