/// <summary>
/// 收入信息表导出
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="list"></param>
/// <param name="sheet"></param>
/// <returns></returns>
private static IWorkbook shourupirent <T>(List <T> list, ISheet sheet)
{
int rowIndex = 0;
IRow row = sheet.CreateRow(rowIndex);
#region MyRegion//表头
row.CreateCell(0).SetCellValue("收入名称");
row.CreateCell(1).SetCellValue("收入日期");
row.CreateCell(2).SetCellValue("金额");
row.CreateCell(3).SetCellValue("业务员");
row.CreateCell(4).SetCellValue("店铺名称");
rowIndex++;
#endregion
foreach (T item in list)
{
TJBBSR model = item as TJBBSR;
//每遍历一条数据创建一行
row = sheet.CreateRow(rowIndex);
//创建行中的单元格
row.CreateCell(0).SetCellValue(model.Name);
row.CreateCell(1).SetCellValue(model.Date);
row.CreateCell(2).SetCellValue(model.Money);
row.CreateCell(3).SetCellValue(model.SaleMan);
row.CreateCell(4).SetCellValue(model.DianPu);
rowIndex++;
}
return(sheet.Workbook);
}
//此处应该是收入的统计 纯现金
public List <TJBBSR> selectTJBB(string begindate, string enddate, string yginfo, string lbtype, string name)
{
List <TJBBSR> list = new List <TJBBSR>();
List <TJBBSR> list1 = new List <TJBBSR>();
TJBBSR model;
//充值的钱
List <memberToUpModel> listcz = czdal.selectTJ(begindate, enddate, yginfo, name);
//办卡的钱
List <memberInfoModel> listbk = hybkdal.tjbbOfbk(begindate, enddate, name);
//取走寄存的时候给的钱
//改为查询历史检查记录，将有应付金额的加进来
List <JCInfoModel> listjc = jcdal.selectQZTJ(begindate, enddate, yginfo, lbtype, name);
//还要统计，在收活处，点了付款之后的当时就付了先进的应付金额
List <LiShiConsumption> listls = lidal.selectTJMoney(begindate, enddate, yginfo, name);
#region//将数据首先存放在list1中
foreach (var iteam in listcz)
{
if (iteam.czMoney.Trim() == "0")
{
continue;
}
model = new TJBBSR();
model.Name = "会员充值，姓名[" + iteam.czName.Trim() + "],卡号[" + iteam.czNo.Trim() + "]";
model.Date = iteam.czDate;
model.Money = iteam.czMoney;
model.SaleMan = iteam.czSaleman;
model.DianPu = iteam.dianpu;
list1.Add(model);
}
foreach (var iteam in listbk)
{
if (iteam.cardMoney.Trim() == "0")
{
continue;
}
model = new TJBBSR();
model.Name = "会员办卡，姓名[" + iteam.memberName.Trim() + "],卡号[" + iteam.memberCardNo.Trim() + "]";
model.Date = iteam.cardDate;
model.Money = iteam.cardMoney;
model.SaleMan = iteam.saleMan;
model.DianPu = iteam.dianName;
list1.Add(model);
}
foreach (var iteam in listjc)
{
if (iteam.jcQMoney.Trim() == "0")
{
continue;
}
model = new TJBBSR();
model.Name = iteam.jcName.Trim() + "," + iteam.jcCardNumber.Trim() + "," + iteam.jcStaff.Trim();
model.Date = iteam.jcBeginDate;
model.Money = iteam.jcQMoney;
model.SaleMan = iteam.jcPression;
model.DianPu = iteam.lsdm;
list1.Add(model);
}
foreach (var iteam in listls)
{
if (iteam.LSYMoney.Trim() == "0")
{
continue;
}
model = new TJBBSR();
model.Name = iteam.LSName.Trim() + "," + iteam.LSCardNumber.Trim() + "," + iteam.LSStaff.Trim();
model.Date = iteam.LSDate;
model.Money = iteam.LSYMoney;
model.SaleMan = iteam.LSSalesman;
model.DianPu = iteam.LSMultipleName;
list1.Add(model);
}
#endregion
#region//时间过滤
//string pattern = @"[\d]+";
//int i = 1;
//Regex regex = new Regex(pattern, RegexOptions.None);
//int dyear = Convert.ToInt32(regex.Matches(enddate)[0].Value);
//int dmonth = Convert.ToInt32(regex.Matches(enddate)[1].Value);
//int dday = Convert.ToInt32(regex.Matches(enddate)[2].Value);
//int xyear = Convert.ToInt32(regex.Matches(begindate)[0].Value);
//int xmonth = Convert.ToInt32(regex.Matches(begindate)[1].Value);
//int xday = Convert.ToInt32(regex.Matches(begindate)[2].Value);
//DateTime bigdate = new DateTime(dyear, dmonth, dday);
//DateTime smalldate = new DateTime(xyear, xmonth, xday);
//foreach (var iteam in list1)
//{
// iteam.No = i.ToString();
// int year = Convert.ToInt32(regex.Matches(iteam.Date.Trim())[0].Value);
// int month = Convert.ToInt32(regex.Matches(iteam.Date.Trim())[1].Value);
// int day = Convert.ToInt32(regex.Matches(iteam.Date.Trim())[2].Value);
// DateTime nowdate = new DateTime(year, month, day);
// if (DateTime.Compare(smalldate, nowdate) <= 0 && DateTime.Compare(bigdate, nowdate) >= 0)
// {
// list.Add(iteam);
// }
// i++;
//}
#endregion
return(list1);
}
