public EMAccountDetailWithCount GetAccountDetailBalance(AccountDetailParam param)
{
EMAccountDetailWithCount model = new EMAccountDetailWithCount();
IEMTenantAccountDetailService service = new EMTenantAccountDetailService();
decimal balance = decimal.Zero;
IList<EMTenantAccountDetail> list = service.Select(param.TenantCode, param.PageSize, out balance);
model.Balance = balance;
IList<EMAccountDetailViewModel> viewList = new List<EMAccountDetailViewModel>();
for (int i = 0; i < list.Count; i++)
{
EMAccountDetailViewModel em = new EMAccountDetailViewModel();
em.Index = i + 1;
em.ConsumeMoney = list[i].ConsumeMoney;
em.ConsumeType = list[i].ConsumeType;
em.CreateTime = list[i].CreateTime;
em.OperateType = list[i].OperateType;
em.Remark = list[i].Remark;
em.TargetTenantCode = list[i].TargetTenantCode;
em.TargetTenantName = list[i].TargetTenantName;
em.TenantCode = list[i].TenantCode;
viewList.Add(em);
}
model.listModel = viewList;
return model;
}
public JsonResult GetAccontDetail(string tenantCode, string ConsumeType, string BeginTime, string EndTime, string rows, string pageSize)
{
AccountDetailParam model = new AccountDetailParam();
model.TenantCode = tenantCode;
model.consumeType = Convert.ToInt32(ConsumeType);
model.beginDate = Convert.ToDateTime(BeginTime);
model.endDate = Convert.ToDateTime(EndTime + " 23:59:59");
model.PageSize = Convert.ToInt32(pageSize);
model.RowIndex = (Convert.ToInt32(rows) - 1) * Convert.ToInt32(pageSize);
EMAccountDetailWithCount list = _SysSettingService.SearchAccountDetail(model);
if (list == null)
return null;
return Json(list, JsonRequestBehavior.AllowGet);
}
public EMAccountDetailWithCount SearchAccountDetail(AccountDetailParam param)
{
EMAccountDetailWithCount model = new EMAccountDetailWithCount();
EMTenantAccountDetailService service = new EMTenantAccountDetailService();
int rowcount = 0;
IList<EMTenantAccountDetail> list = service.Select(param.TenantCode, param.beginDate, param.endDate, param.consumeType, param.RowIndex, param.PageSize, ref rowcount);
IList<EMAccountDetailViewModel> viewList = new List<EMAccountDetailViewModel>();
for(int i = 0;i<list.Count;i++)
{
EMAccountDetailViewModel em = new EMAccountDetailViewModel();
em.Index = i + 1;
em.ConsumeMoney = list[i].ConsumeMoney;
em.ConsumeType = list[i].ConsumeType;
em.CreateTime = list[i].CreateTime;
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;
}
/// <summary>
/// 获取消费记录列表
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="page">页索引</param>
/// <param name="rows"></param>
/// <returns></returns>
public JsonResult GetAccountDetailList(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);
AccountDetailParam param = new AccountDetailParam();
param.beginDate = beginDate;
param.endDate = endDate;
param.TenantCode = tenantCode;
param.PageSize = pageSize;
param.RowIndex = rowIndex;
param.consumeType = consumeType;
EMAccountDetailWithCount edwc = _ISysSettingWCFService.SearchAccountDetail(param);
int totalRowCount = edwc.RowCount;
IList<EMAccountDetailViewModel> edwcList = edwc.listModel;
if (edwc == 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.ToString()),
u.OperateType == PES.GPS.Entity.Enum.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 Json(res, JsonRequestBehavior.AllowGet);
}
