/// <summary>
/// 定额加载
/// </summary>
/// <param name="queryQuota"></param>
/// <returns></returns>
public ResultQuotaInfo GetQuotaInfo(QueryQuotaContact queryQuota)
{
#region 定义变量
ResultQuotaInfo quotaInfo = new ResultQuotaInfo();
List<Model.TB_Quota> currentQuota = new List<TB_Quota>();
string currentWhere = string.Empty;
#endregion
#region 组织查询条件
//月定额
if (queryQuota.QuotaType == 1)
{
currentWhere = " and OBJECTID=" + queryQuota.ObjectId;
currentWhere += " and ItemCode='" + queryQuota.ItemCode + "' ";
currentWhere += " and QuotaType=" + queryQuota.QuotaType;
if (queryQuota.Date != null && !string.IsNullOrEmpty(queryQuota.Date.ToString()))
{
currentWhere += string.Format(" and ( DATEPART(year,QUOTATIME)={0} and DATEPART(month,QUOTATIME) ={1})", queryQuota.Date.Year, queryQuota.Date.Month);
}
}
else if (queryQuota.QuotaType == 2)
{
currentWhere = " and OBJECTID=" + queryQuota.ObjectId;
currentWhere += " and ItemCode='" + queryQuota.ItemCode + "' ";
currentWhere += " and QuotaType=" + queryQuota.QuotaType;
if (queryQuota.Date != null && !string.IsNullOrEmpty(queryQuota.Date.ToString()))
{
currentWhere += string.Format(" and DATEPART(year,QUOTATIME)={0}", queryQuota.Date.Year);
}
}
#endregion
#region 组织数据
currentQuota = quotaOperator.GetQuota(currentWhere);
if (currentQuota != null && currentQuota.Count > 0)
{
QueryQuotaLogContract queryQuotaLog = new QueryQuotaLogContract { QuotaId = currentQuota.First().QuotaId, PageCurrent = 1, PageSize = queryQuota.PageSize };
var quotaLogList = GetQuotaLogs(queryQuotaLog);
quotaInfo.QuotaLogList = quotaLogList.QuotaLogList;
quotaInfo.Page = quotaLogList.Page;
quotaInfo.QuotaData = currentQuota.Select(p => new Quota
{
ObjectDesc = p.ObjectDesc,
ObjectId = p.ObjectId,
ObjectType = p.ObjectType,
QuotaId = p.QuotaId,
QuotaTime = p.QuotaTime,
QuotaType = (QuotaType)p.QuotaType,
QuotaValue = (float)p.QuotaValue,
ItemCode = p.ItemCode,
Reserved = p.Reserved
}).First();
}
#endregion
return quotaInfo;
}
/// <summary>
/// 定额日志查询
/// </summary>
/// <param name="queryQuotaLog"></param>
/// <returns></returns>
public ResultQuotaLogs GetQuotaLogs(QueryQuotaLogContract queryQuotaLog)
{
#region 定义变量
ResultQuotaLogs resultQuotaLogs = new ResultQuotaLogs();
string whereStr = string.Empty;
#endregion
#region 组织条件
whereStr += " and QUOTAID=" + queryQuotaLog.QuotaId;
if (queryQuotaLog.StartTime != null && queryQuotaLog.StartTime.ToShortDateString() != "1900-1-1" && !queryQuotaLog.StartTime.Equals(DateTime.MaxValue) && !queryQuotaLog.StartTime.Equals(DateTime.MinValue))
{
whereStr += " and LOGTIME >='" + queryQuotaLog.StartTime + "'";
}
if (queryQuotaLog.EndTime != null && queryQuotaLog.EndTime.ToShortDateString() != "1900-1-1" && !queryQuotaLog.EndTime.Equals(DateTime.MaxValue) && !queryQuotaLog.EndTime.Equals(DateTime.MinValue))
{
whereStr += " and LOGTIME <='" + queryQuotaLog.EndTime.AddDays(1) + "'";
}
#endregion
#region 组织数据
var currentQuota = quotaOperator.GetQuota(" and QUOTAID=" + queryQuotaLog.QuotaId);
resultQuotaLogs.QuotaLogList = quotaOperator.GetQuotaLogList(whereStr).Select(p =>
new QuotaLog
{
LogTime = p.LogTime,
QuotaId = p.QuotaId,
QuotaValue = (float)p.QuotaValue,
Reserved = p.Reserved,
UserName = p.UserName,
QuotaTimeStr = currentQuota[0].QuotaType == 1 ? string.Format("{0}-{1}", currentQuota[0].QuotaTime.Year, currentQuota[0].QuotaTime.Month) : currentQuota[0].QuotaTime.Year.ToString(),
ObjectDesc = currentQuota.First().ObjectDesc
}).Skip((queryQuotaLog.PageCurrent - 1) * queryQuotaLog.PageSize).Take(queryQuotaLog.PageSize).ToList();
resultQuotaLogs.Page = new Padding();
resultQuotaLogs.Page.Current = queryQuotaLog.PageCurrent;
resultQuotaLogs.Page.Total = quotaOperator.GetQuotaLogList(whereStr).Count();
return resultQuotaLogs;
#endregion
}
/// <summary>
/// 获取单个的Quota
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ResultQuotaInfo GetQuotaInfoById(int id)
{
ResultQuotaInfo quotaInfo = new ResultQuotaInfo();
quotaInfo.QuotaData = new Quota();
quotaInfo.QuotaLogList = new List<QuotaLog>();
quotaInfo.Page = new Padding();
List<Model.TB_Quota> currentQuota = new List<TB_Quota>();
currentQuota = quotaOperator.GetQuota(" and QUOTAID=" + id);
if (currentQuota != null && currentQuota.Count > 0)
{
QueryQuotaLogContract queryQuotaLog = new QueryQuotaLogContract { QuotaId = currentQuota.First().QuotaId, PageCurrent = 1, PageSize = 100 };
var quotaLogList = GetQuotaLogs(queryQuotaLog);
quotaInfo.QuotaLogList = quotaLogList.QuotaLogList;
quotaInfo.Page = quotaLogList.Page;
quotaInfo.QuotaData = currentQuota.Select(p => new Quota
{
ObjectDesc = p.ObjectDesc,
ObjectId = p.ObjectId,
ObjectType = p.ObjectType,
QuotaId = p.QuotaId,
QuotaTime = p.QuotaTime,
QuotaType = (QuotaType)p.QuotaType,
QuotaValue = (float)p.QuotaValue,
ItemCode = p.ItemCode,
Reserved = p.Reserved
}).First();
}
return quotaInfo;
}