/// <summary>
/// 历史消费记录
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="list"></param>
/// <param name="sheet"></param>
/// <returns></returns>
private static IWorkbook lishiinfopirent <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("消费金额");
row.CreateCell(5).SetCellValue("所属店铺");
rowIndex++;
#endregion
foreach (T item in list)
{
CardExitMoney model = item as CardExitMoney;
//每遍历一条数据创建一行
row = sheet.CreateRow(rowIndex);
//创建行中的单元格
row.CreateCell(0).SetCellValue(model.membername);
row.CreateCell(1).SetCellValue(model.membernum);
row.CreateCell(2).SetCellValue(model.cardname);
row.CreateCell(3).SetCellValue(model.cardtype);
row.CreateCell(4).SetCellValue(model.cardmoney);
row.CreateCell(5).SetCellValue(model.dpname);
rowIndex++;
}
return(sheet.Workbook);
}
//在统计报表中显示的 查询卡的消费信息
public List <CardExitMoney> selectTJ(string begindate, string enddate, string name)
{
List <CardExitMoney> list = new List <CardExitMoney>();
CardExitMoney model;
string dpnam = FilterClass.DianPu1.UserName;
string str = "";
//SqlParameter[] pms;
if (name == "")
{
str = "select * from CardExitMoney" + ID + " where DateTime between '" + begindate + "' and '" + enddate + "'";
//pms = new SqlParameter[] {
//new SqlParameter("@dpname",dpnam)
//};
}
else if (name == "全部")
{
foreach (KeyValuePair <string, int> iteam in FilterClass.dic)
{
str += "select * from ";
str += "CardExitMoney" + iteam.Value + "";
str += " where DateTime between '" + begindate + "' and '" + enddate + "'";
str += " union all ";
}
str = str.Substring(0, str.Length - 10);
//str += " where " + wherestr;
//str = str.Substring(0,str.Length-4);
//pms = new SqlParameter[] {
//};
}
else
{
int id = FilterClass.dic[name];
str = "select * from CardExitMoney" + id + " where DateTime between '" + begindate + "' and '" + enddate + "'";
//pms = new SqlParameter[] {
//new SqlParameter("@dpname",name)
//};
}
SqlDataReader read = SqlHelper.ExecuteReader(str);
while (read.Read())
{
if (read.HasRows)
{
model = new CardExitMoney();
model.ID = Convert.ToInt32(read["ID"]);
model.membername = read["membername"].ToString();
model.membernum = read["membernum"].ToString();
model.cardname = read["cardname"].ToString();
model.cardtype = read["cardtype"].ToString();
model.cardmoney = read["cardmoney"].ToString();
model.dpname = read["dpname"].ToString();
model.LSStaff = read["LSStaff"].ToString();
model.ExitDate = read["DateTime"].ToString();
list.Add(model);
}
}
return(list);
}
public void AddList(List <shInfoList> list, string membername, string membernum, string cardname, string cardtype, string date)
{
List <CardExitMoney> list1 = new List <CardExitMoney>();
CardExitMoney model;
foreach (var iteam in list)
{
model = new CardExitMoney();
model.cardname = cardname;
model.cardtype = cardtype;
model.dpname = FilterClass.DianPu1.UserName;
model.membername = membername;
model.membernum = membernum;
model.LSStaff = iteam.Type + ":" + iteam.FuWuName;
model.cardmoney = (Convert.ToDouble(iteam.CountMoney) - Convert.ToDouble(iteam.YMoney)).ToString();
if (model.cardmoney.Trim() != "0")
{
list1.Add(model);
}
}
dal.AddList(list1, date);
}