public ActionResult MemberV2(int PageSize, int CurrentPage, Model.M.M1Params m1params)
{
m1params.Years = Request.QueryString.Get("Years"); //Years 多条
string Filter = U.BuildFilter(m1params);
int Count = 0;
List<Member> TL = new List<Model.M.Member>();
//第一行
var TM = new Member();
TM.ID = "序号";
//TM.MID = "学员号";
//TM.IDSN = "报名序号";
TM.IDCard = "身份证号";
TM.Name = "学员姓名";
//TM.Phone = "手机";
//TM.Type = "类型";
TM.Year = "年份";
TM.Minutes = "课时";
//TM.IID = "发票";
TM.Score = "考试";
//TM.Status = "结业";
//TM.RegDate = "注册时间";
TM.PayDate = "缴费时间";
TM.CommitDate = "结业时间";
TM.RegionCode = "区域代码";
TL.Add(TM);
//数据行
var L = DAL.M.Get.M1(PageSize, CurrentPage, Filter, out Count);
foreach (var m in L)
{
TM = new Member();
TM.ID = m.ID.ToString();
//TM.MID = m.MID.ToString();
//TM.IDSN = "'" + m.IDSN;
TM.IDCard = "'" + m.IDCard;
TM.Name = m.Name;
//TM.Phone = m.Phone;
//TM.Type = m.Type == 0 ? "行政" : "企业";
TM.Year = m.Year.ToString();
TM.Minutes = string.Format("{0}", m.Minutes.ToString("0.#"));
//TM.IID = m.IID > 0 ? "发票" : "-";
TM.Score = m.Score.ToString();
//TM.Status = m.Status == 1 ? "已结业" : "-";
//TM.RegDate = m.RegDate.ToString();
if (m.PayDate > DateTime.MinValue)
{
TM.PayDate = m.PayDate.ToString();
}
if (m.CommitDate > DateTime.MinValue)
{
TM.CommitDate = m.CommitDate.ToString();
}
TM.RegionCode = m.RegionCode.ToString();
TL.Add(TM);
}
string CSV = U.ConvertToCSV<Member>(TL);
U.ExportCSV(CSV);
return Content(string.Empty);
}
public ActionResult Member(int PageSize, int CurrentPage)
{
int Count = 0;
List<Member> TL = new List<Model.M.Member>();
//第一行
var TM = new Member();
TM.ID = "序号";
TM.MID = "学员号";
TM.IDSN = "报名序号";
TM.IDCard = "身份证号";
TM.Name = "学员姓名";
TM.Type = "类型";
TM.Year = "年份";
TM.Minutes = "课时(分钟)";
TM.IID = "发票";
TM.Score = "考试";
TM.Status = "结业";
TM.RegDate = "注册时间";
TL.Add(TM);
//数据行
var L = DAL.M.Get.M1(PageSize, CurrentPage, out Count);
foreach (var m in L)
{
TM = new Member();
TM.ID = m.ID.ToString();
TM.MID = m.MID.ToString();
TM.IDSN = "'" + m.IDSN;
TM.IDCard = "'" + m.IDCard;
TM.Name = m.Name;
TM.Type = m.Type == 0 ? "行政" : "企业";
TM.Year = m.Year.ToString();
TM.Minutes = string.Format("{0}", m.Minutes.ToString("0.#"));
TM.IID = m.IID > 0 ? "发票" : "-";
TM.Score = m.Score > 0 ? m.Score.ToString() : "-";
TM.Status = m.Status == 1 ? "结业" : "-";
TM.RegDate = m.RegDate.ToString();
TL.Add(TM);
}
string CSV = U.ConvertToCSV<Member>(TL);
U.ExportCSV(CSV);
return Content(string.Empty);
}