// GET: Sale
public ActionResult SaleList(SaleListAction CommandAction)
{
var result = CommandAction.Execute();
this.ViewBag.Result = result;
return(View());
}
//
public void ExportExcel(SaleListAction CommandAction)
{
this.ViewBag.Result = CommandAction.Execute();
ExcelPackage pck = new ExcelPackage();
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Report");
ws.Cells["A1"].Value = "Title";
ws.Cells["B1"].Value = "Title";
ws.Cells["A2"].Value = "Table";
ws.Cells["B2"].Value = "Sale";
ws.Cells["A3"].Value = "Date";
ws.Cells["B3"].Value = string.Format("{0:dd MMM yyyy} at {0:H: mm tt};", DateTimeOffset.Now);
ws.Cells["A6"].Value = "Mã";
ws.Cells["B6"].Value = "Ngày";
ws.Cells["C6"].Value = "Khách hàng";
ws.Cells["D6"].Value = "Nhân viên bán hàng";
ws.Cells["E6"].Value = "Số lượng";
ws.Cells["F6"].Value = "Tổng tiền";
ws.Cells["G6"].Value = "Ghi chú";
int rowStart = 7;
foreach (var item in this.ViewBag.Result)
{
ws.Cells[string.Format("A{0}", rowStart)].Value = item.SaleId;
ws.Cells[string.Format("B{0}", rowStart)].Value = Convert.ToDateTime(item.SaleDate).ToString("dd/MM/yyyy hh:mm:ss");
ws.Cells[string.Format("C{0}", rowStart)].Value = item.CustomerName;
ws.Cells[string.Format("D{0}", rowStart)].Value = item.EmployeeName;
ws.Cells[string.Format("E{0}", rowStart)].Value = Convert.ToInt32(item.Qty).ToString("#,##0");
ws.Cells[string.Format("F{0}", rowStart)].Value = Convert.ToInt32(item.Total).ToString("#,##0");
ws.Cells[string.Format("G{0}", rowStart)].Value = item.Note;
rowStart++;
}
ws.Cells["A:AZ"].AutoFitColumns();
Response.Clear();
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment: filename=" + "ExcelReport.xlsx");
Response.BinaryWrite(pck.GetAsByteArray());
Response.End();
}
// GET: Sale
public ActionResult SaleList(SaleListAction CommandAction)
{
var result = CommandAction.Execute();
foreach (var item in result)
{
if (item.Status != 1)
{
item.StatusShow = "Chưa xử lý";
}
else
{
item.StatusShow = "Đã hoàn thành";
}
item.SaleDate = Convert.ToDateTime(item.SaleDate).ToString("yyyy-MM-dd");
}
this.ViewBag.Result = result;
return(View());
}
public ActionResult SaleChart(SaleListAction CommandAction)
{
this.ViewBag.Result = JsonExpando(CommandAction.Execute());
return(View());
}
