public ActionResult InvoiceV2(int PageSize, int CurrentPage, Model.M.M2Params m2params)
{
m2params.Years = Request.QueryString.Get("Years"); //Years 多条
string Filter = U.BuildFilter(m2params);
int Count = 0;
List<Invoice> TL = new List<Model.M.Invoice>();
//第一行
var TM = new Invoice();
TM.ID = "序号";
//TM.MID = "学员号";
//TM.Year = "年份";
//TM.IDSN = "报名序号";
TM.IDCARD = "身份证号";
TM.Name = "学员";
TM.NameContact = "收件人";
TM.Amount = "金额";
TM.Title = "发票抬头";
TM.Tel = "电话";
//TM.City = "城市";
TM.Address = "地址";
TM.Zip = "邮编";
TM.CreateDate = "申请时间";
TL.Add(TM);
//数据行
var L = DAL.M.Get.M2(PageSize, CurrentPage, Filter, out Count);
foreach (var m in L)
{
TM = new Invoice();
TM.ID = m.ID.ToString();
//TM.MID = m.MID.ToString();
//TM.Year = m.Year.ToString();
//TM.IDSN = "'" + m.IDSN;
TM.IDCARD = "'" + m.IDCARD;
TM.Name = m.Name;
TM.NameContact = m.NameContact;
TM.Amount = m.Amount;
TM.Title = m.Title;
TM.Tel = m.Tel;
//TM.City = m.City;
TM.Address = m.Address;
TM.Zip = m.Zip;
TM.CreateDate = m.CreateDate;
TL.Add(TM);
}
string CSV = U.ConvertToCSV<Invoice>(TL);
U.ExportCSV(CSV);
return Content(string.Empty);
}
public ActionResult Invoice(int PageSize, int CurrentPage)
{
int Count = 0;
List<Invoice> TL = new List<Model.M.Invoice>();
//第一行
var TM = new Invoice();
TM.ID = "序号";
TM.MID = "学员号";
TM.Year = "年份";
TM.IDSN = "报名序号";
TM.IDCARD = "身份证号";
TM.Name = "学员姓名";
TM.NameContact = "收件人";
TM.Amount = "发票金额";
TM.Title = "发票抬头";
TM.Tel = "电话";
TM.City = "城市";
TM.Address = "邮件地址";
TM.Zip = "邮编";
TM.CreateDate = "申请时间";
TL.Add(TM);
//数据行
var L = DAL.M.Get.M2(PageSize, CurrentPage, out Count);
foreach (var m in L)
{
TM = new Invoice();
TM.ID = m.ID.ToString();
TM.MID = m.MID.ToString();
TM.Year = m.Year.ToString();
TM.IDSN = "'" + m.IDSN;
TM.IDCARD = "'" + m.IDCARD;
TM.Name = m.Name;
TM.NameContact = m.NameContact;
TM.Amount = m.Amount;
TM.Title = m.Title;
TM.Tel = m.Tel;
TM.City = m.City;
TM.Address = m.Address;
TM.Zip = m.Zip;
TM.CreateDate = m.CreateDate;
TL.Add(TM);
}
string CSV = U.ConvertToCSV<Invoice>(TL);
U.ExportCSV(CSV);
return Content(string.Empty);
}
