private static IWorkbook XMoneyLS <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 iteam in list)
{
XMoneyLS model = iteam as XMoneyLS;
//每遍历一条数据创建一行
row = sheet.CreateRow(rowIndex);
//创建行中的单元格
row.CreateCell(0).SetCellValue(model.NameXM);
row.CreateCell(1).SetCellValue(model.MoneyXM);
row.CreateCell(2).SetCellValue(model.CardNumXM);
row.CreateCell(3).SetCellValue(model.DanNumberXM);
row.CreateCell(4).SetCellValue(model.DateXM);
rowIndex++;
}
return(sheet.Workbook);
}
//将现金消费的记录添加进来
public List <XMoneyLS> SelectXMoney(string begindate, string enddate, string dpname)
{
int i = 1;
List <XMoneyLS> list = new List <XMoneyLS>();
XMoneyLS model;
string str = "";
if (dpname == "")
{
str = "select LSName,LSMoney,LSCardNumber,LSDanNumber,LSDate from LSConsumption" + ID + " where LSDate between '" + begindate + "' and '" + enddate + "'";
}
else if (dpname == "全部")
{
foreach (KeyValuePair <string, int> iteam in FilterClass.dic)
{
str += "select LSName,LSMoney,LSCardNumber,LSDanNumber,LSDate ";
str += "from LSConsumption" + iteam.Value + "";
str += " where LSDate between '" + begindate + "' and '" + enddate + "'";
str += " union all ";
}
str = str.Substring(0, str.Length - 10);
}
else
{
int id = FilterClass.dic[dpname];
str = "select LSName,LSMoney,LSCardNumber,LSDanNumber,LSDate from LSConsumption" + id + " where LSDate between '" + begindate + "' and '" + enddate + "'";
}
SqlDataReader read = SqlHelper.ExecuteReader(str);
while (read.Read())
{
if (read.HasRows)
{
model = new XMoneyLS();
model.DanNumberXM = read["LSDanNumber"].ToString();
model.CardNumXM = read["LSCardNumber"].ToString();
model.DateXM = read["LSDate"].ToString();
model.MoneyXM = read["LSMoney"].ToString();
model.NameXM = read["LSName"].ToString();
model.NOXM = i++;
list.Add(model);
}
}
return(list);
}
