public ActionResult GetAllExcelDataPengVersion(string search_input, string dropdown_selected, string sortby)
{
var data = repo.資料篩選邏輯寫在repo類別內(search_input, dropdown_selected, sortby).ToList();
var exportSpource = this.GetExportData(data);
var dt = JsonConvert.DeserializeObject <DataTable>(exportSpource.ToString());
var exportFileName = string.Concat(
"客戶資料_",
DateTime.Now.ToString("yyyyMMddHHmmss"),
".xlsx");
ExportExcelPeng nv = new ExportExcelPeng("客戶資料", exportFileName, dt);
return(nv.取得FileStreamResult());
}
public ActionResult GetAllExcelDataPengVersion(string search_input)
{
var data = db.客戶銀行資訊.Include(path => path.客戶資料).Where(p => !p.IsDeleted).ToList();
if (!string.IsNullOrEmpty(search_input))
{
data = data.Where(p => p.銀行名稱.Contains(search_input)).ToList();
}
var exportSpource = this.GetExportData(data);
var dt = JsonConvert.DeserializeObject <DataTable>(exportSpource.ToString());
var exportFileName = string.Concat(
"客戶銀行資訊_",
DateTime.Now.ToString("yyyyMMddHHmmss"),
".xlsx");
ExportExcelPeng nv = new ExportExcelPeng("客戶銀行資料", exportFileName, dt);
return(nv.取得FileStreamResult());
}
public ActionResult GetAllExcelDataPengVersion(string search_input, string dropdown_selected, string sortby)
{
var data = db.客戶聯絡人.Where(p => !p.IsDeleted).ToList();
if (!string.IsNullOrEmpty(search_input))
{
data = data.Where(p =>
p.職稱.Contains(search_input) || p.姓名.Contains(search_input) || p.Email.Contains(search_input) ||
p.手機.Contains(search_input) || p.電話.Contains(search_input)).ToList();
}
if (!string.IsNullOrEmpty(dropdown_selected))
{
data = data.Where(p => p.職稱 == dropdown_selected).ToList();
}
if (!string.IsNullOrEmpty(sortby))
{
if ("1asc".Equals(sortby))
{
data = data.OrderBy(p => p.職稱).ToList();
}
if ("1desc".Equals(sortby))
{
data = data.OrderByDescending(p => p.職稱).ToList();
}
if ("2asc".Equals(sortby))
{
data = data.OrderBy(p => p.姓名).ToList();
}
if ("2desc".Equals(sortby))
{
data = data.OrderByDescending(p => p.姓名).ToList();
}
if ("3asc".Equals(sortby))
{
data = data.OrderBy(p => p.Email).ToList();
}
if ("3desc".Equals(sortby))
{
data = data.OrderByDescending(p => p.Email).ToList();
}
if ("4asc".Equals(sortby))
{
data = data.OrderBy(p => p.手機).ToList();
}
if ("4desc".Equals(sortby))
{
data = data.OrderByDescending(p => p.手機).ToList();
}
if ("5asc".Equals(sortby))
{
data = data.OrderBy(p => p.電話).ToList();
}
if ("5desc".Equals(sortby))
{
data = data.OrderByDescending(p => p.電話).ToList();
}
if ("6asc".Equals(sortby))
{
data = data.OrderBy(p => p.客戶資料.客戶名稱).ToList();
}
if ("6desc".Equals(sortby))
{
data = data.OrderByDescending(p => p.客戶資料.客戶名稱).ToList();
}
}
var exportSpource = this.GetExportData(data);
var dt = JsonConvert.DeserializeObject <DataTable>(exportSpource.ToString());
var exportFileName = string.Concat(
"客戶聯絡人_",
DateTime.Now.ToString("yyyyMMddHHmmss"),
".xlsx");
ExportExcelPeng nv = new ExportExcelPeng("客戶聯絡人", exportFileName, dt);
return(nv.取得FileStreamResult());
}