/// <summary>
/// 消费记录
/// </summary>
public Object GetAccountDetailLis(string bDate, string eDate, string tenantCode, string csType, string page, string rows)
{
rows = "10";
if (string.IsNullOrEmpty(page) || string.IsNullOrEmpty(rows))
{
page = "1";
bDate = "1900-01-01";
eDate = "2090-01-01";
}
if (string.IsNullOrEmpty(bDate))
{
bDate = "1900-01-01";
}
if (string.IsNullOrEmpty(eDate))
{
eDate = "2090-01-01";
}
int consumeType = -1;
if (string.IsNullOrEmpty(csType))
consumeType = -1;
else
consumeType = Convert.ToInt32(csType);
int pageIndex = Convert.ToInt32(page);
int pageSize = Convert.ToInt32(rows);
int rowIndex = (pageIndex - 1) * pageSize;
DateTime beginDate = Convert.ToDateTime(bDate + " 00:00:00");
DateTime endDate = Convert.ToDateTime(eDate + " 23:59:59");
int rowNumber = Convert.ToInt32(rows);
int total = 0;
VAccountDetail model = new VAccountDetail();
IList<ETenantAccountDetail> list = DACFacade.Movo.TenantAccountDetailDAC.SelectList(tenantCode, beginDate, endDate, consumeType, rowIndex, pageSize, out total);
IList<EAccountDetailView> viewList = new List<EAccountDetailView>();
for (int h = 0; h < list.Count; h++)
{
EAccountDetailView em = new EAccountDetailView();
em.Index = h + 1;
em.ConsumeMoney = list[h].ConsumeMoney;
em.ConsumeType = list[h].ConsumeType;
em.CreateTime = list[h].CreateTime.Value;
em.OperateType = list[h].OperateType;
em.Remark = list[h].Remark;
em.TargetTenantCode = list[h].TargetTenantCode;
em.TenantCode = list[h].TenantCode;
viewList.Add(em);
}
model.RowCount = total;
model.listModel = viewList;
int totalRowCount = model.RowCount;
IList<EAccountDetailView> edwcList = model.listModel;
if (model == null || totalRowCount == 0)
return null;
int i = 1;
int r = totalRowCount % pageSize == 0 ? 0 : 1;
var query = from u in edwcList
select new
{
index = i++,
cell = new string[]{
u.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
GetConsumeType(u.ConsumeType),
u.OperateType == EnumOperateType.Income?"+"+u.ConsumeMoney.ToString():"-"+u.ConsumeMoney.ToString(),
u.Remark.ToString()
}
};
var res = new
{
total = totalRowCount / pageSize + r,
page = pageIndex,
records = totalRowCount,
rows = query.Take(totalRowCount)
};
return res;
}
/// <summary>
/// 充值消费记录
/// </summary>
public VAccountDetail AccountDetailQuerySearch(string bDate, string eDate, string consumeType, int pageSize, int rowIndex, string tenantCode)
{
DateTime beginDate = DateTime.Today.AddDays(-30);
DateTime endDate = DateTime.Today;
int type = -1;
int rowcount = 0;
if (!string.IsNullOrEmpty(bDate) && !string.IsNullOrEmpty(eDate) && !string.IsNullOrEmpty(consumeType))
{
beginDate = DateTime.Parse(bDate);
endDate = DateTime.Parse(eDate);
type = int.Parse(consumeType);
}
VAccountDetail model = new VAccountDetail();
IList<ETenantAccountDetail> list = DACFacade.Movo.TenantAccountDetailDAC.SelectList(tenantCode, beginDate, endDate, type, rowIndex, pageSize,out rowcount);
IList<EAccountDetailView> viewList = new List<EAccountDetailView>();
for (int i = 0; i < list.Count; i++)
{
EAccountDetailView em = new EAccountDetailView();
em.Index = i + 1;
em.ConsumeMoney = list[i].ConsumeMoney;
em.ConsumeType = list[i].ConsumeType;
em.CreateTime = list[i].CreateTime.Value;
em.OperateType = list[i].OperateType;
em.Remark = list[i].Remark;
em.TargetTenantCode = list[i].TargetTenantCode;
em.TenantCode = list[i].TenantCode;
viewList.Add(em);
}
model.RowCount = rowcount;
model.listModel = viewList;
return model;
}
