/// <summary>
/// 获取协议操作历史记录
/// </summary>
/// <param name="searchParas"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResult GetRedPacketHistoryList(Search_RedPacketHistory searchParas, GridParams para)
{
para.pagenum = para.pagenum + 1;//页0，+1
var list = _redPacketLogic.GetRedPacketHistoryList(searchParas, para);
return(Json(list, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 根据搜索条件获取企业付款历史
/// </summary>
/// <param name="searchParas">搜索条件</param>
/// <param name="para">页码信息</param>
/// <returns></returns>
public JsonResultModel <v_Business_Redpacket_Push_Information> GetPaymentInfos(Search_RedPacketHistory searchParas, GridParams para)
{
var jsonResult = new JsonResultModel <v_Business_Redpacket_Push_Information>();
using (var db = SugarDao_MsSql.GetInstance())
{
var query = db.Queryable <Business_Enterprisepayment_Information>().JoinTable <Business_Personnel_Information>((s1, s2) => s1.UserID == s2.UserID);
if (!string.IsNullOrEmpty(searchParas.Name))
{
query.Where <Business_Personnel_Information>((s1, s2) => s2.Name.Contains(searchParas.Name));
}
if (!string.IsNullOrEmpty(searchParas.UserID))
{
query.Where(s1 => s1.UserID.Contains(searchParas.UserID));
}
if (searchParas.RedpacketStatus != null)
{
query.Where(s1 => s1.RedpacketStatus == searchParas.RedpacketStatus);
}
if (searchParas.ReceiveDateFrom != null && searchParas.ReceiveDateTo == null)
{
query.Where(s1 => s1.CreatedDate >= searchParas.ReceiveDateFrom);
}
if (searchParas.ReceiveDateFrom == null && searchParas.ReceiveDateTo != null)
{
query.Where(s1 => s1.CreatedDate <= searchParas.ReceiveDateTo);
}
if (searchParas.ReceiveDateFrom != null && searchParas.ReceiveDateTo != null)
{
query.Where(s1 => s1.CreatedDate >= searchParas.ReceiveDateFrom && s1.CreatedDate <= searchParas.ReceiveDateTo);
}
query.OrderBy(s1 => s1.CreatedDate, OrderByType.Desc);
jsonResult.TotalRows = query.Count();
jsonResult.Rows = query.Select <Business_Enterprisepayment_Information, Business_Personnel_Information, v_Business_Redpacket_Push_Information>
((s1, s3, s2) => new v_Business_Redpacket_Push_Information
{
UserID = s1.UserID,
Name = s2.Name,
RedpacketMoney = s1.RedpacketMoney,
RedpacketStatus = s1.RedpacketStatus,
CreatedDate = s1.CreatedDate,
Reson = s1.Reson,
VGUID = s1.VGUID
}).ToPageList(para.pagenum, para.pagesize);
}
return(jsonResult);
}
/// <summary>
/// 根据搜索条件获取红包领取记录历史
/// </summary>
/// <param name="searchParas"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <v_Business_Redpacket_Push_Information> GetRedPacketHistoryList(Search_RedPacketHistory searchParas, GridParams para)
{
GetRedPacketInfo();
var jsonResult = new JsonResultModel <v_Business_Redpacket_Push_Information>();
using (var db = SugarDao_MsSql.GetInstance())
{
var query = db.Queryable <v_Business_Redpacket_Push_Information>();
if (!string.IsNullOrEmpty(searchParas.Name))
{
query.Where(i => i.Name.Contains(searchParas.Name));
}
if (!string.IsNullOrEmpty(searchParas.UserID))
{
query.Where(i => i.UserID.Contains(searchParas.UserID));
}
if (searchParas.RedpacketStatus != null)
{
query.Where(i => i.RedpacketStatus == searchParas.RedpacketStatus);
}
if (searchParas.ReceiveDateFrom != null && searchParas.ReceiveDateTo == null)
{
query.Where(i => i.ReceiveDate >= searchParas.ReceiveDateFrom);
}
if (searchParas.ReceiveDateFrom == null && searchParas.ReceiveDateTo != null)
{
query.Where(i => i.ReceiveDate <= searchParas.ReceiveDateTo);
}
if (searchParas.ReceiveDateFrom != null && searchParas.ReceiveDateTo != null)
{
query.Where(i => i.ReceiveDate >= searchParas.ReceiveDateFrom && i.ReceiveDate <= searchParas.ReceiveDateTo);
}
query.OrderBy(i => i.CreatedDate, OrderByType.Desc);
int totalCount = 0;
jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize, ref totalCount);
jsonResult.TotalRows = totalCount;
var logData = JsonConverter.Serialize(jsonResult);
_ll.SaveLog(3, 51, CurrentUser.GetCurrentUser().LoginName, "红包领取历史", logData);
}
return(jsonResult);
}
/// <summary>
/// 根据搜索条件获取企业付款历史
/// </summary>
/// <param name="searchParas">搜索条件</param>
/// <param name="para">页码信息</param>
/// <returns></returns>
public JsonResultModel <v_Business_Redpacket_Push_Information> GetPaymentInfos(Search_RedPacketHistory searchParas, GridParams para)
{
return(_redPacketServer.GetPaymentInfos(searchParas, para));
}
