/// <summary>
/// 财务列表
/// </summary>
/// <returns></returns>
public JsonResult GetFinanceList()
{
try
{
int page = !string.IsNullOrEmpty(Request["page"]) ? Convert.ToInt32(Request["page"]) : 1;
int limit = !string.IsNullOrEmpty(Request["limit"]) ? Convert.ToInt32(Request["limit"]) : 10;
var startTime = !string.IsNullOrEmpty(Request["startTime"]) ? Request["startTime"] : "";
var endTime = !string.IsNullOrEmpty(Request["endTime"]) ? Request["endTime"] : "";
var paramRequest = new FinanceInfoRequest
{
UserName = base.UserInfo != null ? base.UserInfo.UserName : "******",
BussinessID = base.UserInfo != null ? base.UserInfo.BusinessID : "-",
StartTime = startTime,
EndTime = endTime,
PageIndex = page,
PageSize = limit
};
if (paramRequest.PageIndex == 0)
{
paramRequest.PageIndex = 1;
}
else
{
paramRequest.PageIndex = (paramRequest.PageIndex / 10) + 1;
}
var result = financeLogic.QueryFinanceListPage(paramRequest);
if (result != null && result.count > 0)
{
result.msg = "SUCCESS";
result.code = 0;
}
else
{
result.msg = "无数据";
result.code = -1;
}
return(Json(result));
}
catch (Exception ex)
{
LogWriter.error($"GetUserManageList=>获取财务信息的异常：{ex.ToString() + ex.Message}");
return(Json(new FinanceInfoPageResponse()
{
code = 9
}));
}
}
/// <summary>
/// 获取财务分页数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public FinanceInfoPageResponse QueryFinanceListPage(FinanceInfoRequest request)
{
int total = 0;
var pageList = financeQuery.QueryUserMangeList(request, out total);
FinanceInfoPageResponse page = new FinanceInfoPageResponse();
if (pageList != null && pageList.Count > 0)
{
page.count = total;
page.data = pageList;
return(page);
}
return(page);
}
/// <summary>
/// 财务信息分页查询
/// </summary>
/// <returns></returns>
public List <FinanceInfoEntity> QueryUserMangeList(FinanceInfoRequest request, out int total)
{
total = 0;
List <FinanceInfoEntity> list = new List <FinanceInfoEntity>();
StringBuilder sq = new StringBuilder();
sq.Append(" select * from ( ");
sq.Append(" select {2} ");
sq.Append(" from dbo.tblFinanceInfo a with(nolock) ");
sq.Append(" where {0} ");
sq.Append(" ) c where {1} ");
DynamicParameters dp = new DynamicParameters();
string where_1 = " 1=1 ";
if (!string.IsNullOrWhiteSpace(request.UserName))
{
where_1 += " and a.UserName=@UserName";
dp.Add("UserName", request.UserName, DbType.String);
}
if (!string.IsNullOrWhiteSpace(request.BussinessID))
{
where_1 += " and a.BusinessID=@BusinessID";
dp.Add("BusinessID", request.BussinessID, DbType.String);
}
if (!string.IsNullOrWhiteSpace(request.StartTime))
{
where_1 += " and a.DayDate>=@StartTime";
dp.Add("StartTime", Convert.ToDateTime(request.StartTime), DbType.DateTime);
}
if (!string.IsNullOrWhiteSpace(request.EndTime))
{
where_1 += " and a.DayDate<@EndTime";
dp.Add("EndTime", Convert.ToDateTime(request.EndTime).AddDays(1), DbType.String);
}
dp.Add("PageIndex", request.PageIndex, DbType.Int32, ParameterDirection.Input);
dp.Add("PageSize", request.PageSize, DbType.Int32, ParameterDirection.Input);
string sql_list = string.Format(sq.ToString(), where_1, " c.Num > (@PageIndex - 1) * @PageSize and c.Num <= @PageIndex * @PageSize", "ROW_NUMBER() over(order by a.CreateTime desc) as Num,* ");
string sql_count = string.Format(sq.ToString(), where_1, "1=1", "count(0) as nums");
using (IDbConnection conn = new SqlConnection(DBConnectionStringConfig.Default.JMGGConnectionString))
{
total = conn.Query <int>(sql_count, dp).FirstOrDefault();
list = conn.Query <FinanceInfoEntity>(sql_list, dp).ToList();
}
return(list);
}
