public async Task <IHttpActionResult> PostReportGDQTongHop(ParameterCashier para) { NvGiaoDichQuayVm.ReportGDQTongHopNew reporter = new NvGiaoDichQuayVm.ReportGDQTongHopNew(); try { var unitCode = _service.GetCurrentUnitCode(); reporter.CreateDateNow(); reporter.FromDay = para.FromDate.Day; reporter.FromMonth = para.FromDate.Month; reporter.FromYear = para.FromDate.Year; reporter.ToDay = para.ToDate.Day; reporter.ToMonth = para.ToDate.Month; reporter.ToYear = para.ToDate.Year; reporter.ToDate = para.ToDate; reporter.FromDate = para.FromDate; reporter.TenDonVi = CurrentSetting.GetUnitName(unitCode); reporter.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode); //GetNhanVien if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal) { var currentUser = (HttpContext.Current.User as ClaimsPrincipal); var name = currentUser.Identity.Name; var nhanVien = _service.UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault(); if (nhanVien != null) { reporter.Username = nhanVien.Username; } else { reporter.Username = "******"; } } switch (para.LoaiGiaoDich) { case TypeGiaoDich.NHAPBANLETRALAI: reporter.DataDetails.AddRange(_service.ReportNhapBLeTraLai(para)); break; default: reporter.DataDetails.AddRange(_service.ReportGiaoDichQuay(para)); break; } } catch (Exception ex) { } return(Ok(reporter)); }
public async Task <IHttpActionResult> GetNewParameter() { var unitCode = _service.GetCurrentUnitCode(); var currentDate = DateTime.Now.Date; var datelock = CurrentSetting.GetNgayKhoaSo(unitCode); var result = new ParameterCashier() { ToDate = datelock, FromDate = datelock, MaxDate = currentDate, UnitCode = unitCode, GroupBy = TypeGroupInventoryCashier.MALOAIVATTU, LoaiGiaoDich = TypeGiaoDich.XUATBANLE }; return(Ok(result)); }
public async Task <IHttpActionResult> PostPrintTranferCashieer(ParameterCashier para) { NvGiaoDichQuayVm.ReportGDQ reporter = new NvGiaoDichQuayVm.ReportGDQ(); List <NvGiaoDichQuayVm.ReportGDQDetailLevel2> result = new List <NvGiaoDichQuayVm.ReportGDQDetailLevel2>(); try { //for (int i = 0; i < nv.Count();i++ ) //{ var unitCode = _service.GetCurrentUnitCode(); reporter.CreateDateNow(); reporter.FromDay = para.FromDate.Day; reporter.FromMonth = para.FromDate.Month; reporter.FromYear = para.FromDate.Year; reporter.ToDay = para.ToDate.Day; reporter.ToMonth = para.ToDate.Month; reporter.ToYear = para.ToDate.Year; reporter.ToDate = para.ToDate; reporter.FromDate = para.FromDate; reporter.TenDonVi = CurrentSetting.GetUnitName(unitCode); reporter.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode); //GetNhanVien if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal) { var currentUser = (HttpContext.Current.User as ClaimsPrincipal); var name = currentUser.Identity.Name; var nhanVien = _service.UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault(); if (nhanVien != null) { reporter.Username = nhanVien.TenNhanVien; } else { reporter.Username = "******"; } } reporter.DataDetails.AddRange(_service.CreatePrintTranferCashieer(para.FromDate, para.ToDate, para.UnitCode, para.SellingMachineCodes, para.CashieerCodes)); //} } catch (Exception ex) { } return(Ok(reporter)); }
public async Task <IHttpActionResult> CreateReportCashierByStaff(ParameterCashier para) { var result = new TransferObj <ReportCashier>(); try { var report = new ReportCashier(); var data = _service.CreateReportCashierByStaff(para.FromDate, para.ToDate, para.UnitCode); report.Data = data; report.CreateDate(); var userName = ControllerContext.RequestContext.Principal.Identity.Name; report.SetWhoCreateThis(userName); result.Data = report; result.Data.CreateDate(); result.Status = true; return(Ok(result)); } catch (Exception e) { return(InternalServerError()); } }
public HttpResponseMessage PostExportExcelGDQTongHop(ParameterCashier para) { HttpResponseMessage response = Request.CreateResponse(); try { MemoryStream streamData = new MemoryStream(); switch (para.LoaiGiaoDich) { case TypeGiaoDich.NHAPBANLETRALAI: streamData = _service.ExportExcelNhapBLeTraLaiTongHop(para); //switch (para.GroupBy) //{ // case TypeGroupInventoryCashier.TYPE: // case TypeGroupInventoryCashier.GROUP: // case TypeGroupInventoryCashier.NHACUNGCAP: // case TypeGroupInventoryCashier.WAREHOUSE: // case TypeGroupInventoryCashier.MERCHANDISE: // case TypeGroupInventoryCashier.GIAODICH: // break; //} break; default: streamData = _service.ExportExcelGDQTongHop(para); //switch (para.GroupBy) //{ // case TypeGroupInventoryCashier.TYPE: // case TypeGroupInventoryCashier.GROUP: // case TypeGroupInventoryCashier.NHACUNGCAP: // case TypeGroupInventoryCashier.WAREHOUSE: // case TypeGroupInventoryCashier.MERCHANDISE: // case TypeGroupInventoryCashier.GIAODICH: // break; //} break; } response.StatusCode = HttpStatusCode.OK; streamData.Seek(0, SeekOrigin.Begin); response.Content = new StreamContent(streamData); switch (para.GroupBy) { case TypeGroupInventoryCashier.MANHOMVATTU: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCao_GDQ_TongHop_TheoNhomVatTu.xlsx" }; break; case TypeGroupInventoryCashier.MALOAIVATTU: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCao_GDQ_TongHop_TheoLoaiVatTu.xlsx" }; break; case TypeGroupInventoryCashier.MAKHACHHANG: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCao_GDQ_TongHop_TheoNhaCungCap.xlsx" }; break; case TypeGroupInventoryCashier.MAVATTU: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCao_GDQ_TongHop_TheoVatTu.xlsx" }; break; case TypeGroupInventoryCashier.MAGIAODICH: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCao_GDQ_TongHop_TheoGiaoDich.xlsx" }; break; case TypeGroupInventoryCashier.MAKHO: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCao_GDQ_TongHop_TheoKho.xlsx" }; break; default: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCao_GDQ_TongHop.xlsx" }; break; } response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); return(response); } catch (Exception ex) { response.StatusCode = HttpStatusCode.InternalServerError; return(response); } }
public HttpResponseMessage ExportExcel(ParameterCashier para) { var _ParentUnitCode = _service.GetParentUnitCode(); NvGiaoDichQuayVm.ReportExcel result = null; var unitCode = _service.GetCurrentUnitCode(); //var instance = _service.Repository.DbSet.FirstOrDefault(x => x.MaVatTu.ToUpper() == code.ToUpper());//&& x.UnitCode == unitCode); var service = new ProcedureService <NvGiaoDichQuayVm.ReportExcel>(); var data = ProcedureCollection.GetReportGDQExcel(para.FromDate, para.ToDate, new BTS.API.ENTITY.ERPContext(), unitCode); using (ExcelPackage package = new ExcelPackage()) { var ms = new MemoryStream(); package.Workbook.Worksheets.Add("Data"); var worksheet = package.Workbook.Worksheets[1]; int index = 0; worksheet.Cells[1, 1, 1, 5].Merge = true; worksheet.Cells[1, 1].Value = "SIÊU THỊ TỪ SƠN "; worksheet.Cells[2, 1, 2, 5].Merge = true; worksheet.Cells[2, 1].Value = "Đường Lý Thái Tổ, P. Đình Bảng, TX Từ Sơn, Bắc Ninh "; worksheet.Cells[4, 4, 4, 7].Merge = true; worksheet.Cells[4, 4].Value = "BÁO CÁO GIAO DỊCH QUẦY "; worksheet.Cells[5, 4, 5, 8].Merge = true; worksheet.Cells[5, 4].Value = "Từ ngày: " + para.FromDate.Day + "/" + para.FromDate.Month + "/" + para.FromDate.Year + " Đến ngày:" + para.ToDate.Day + "/" + para.ToDate.Month + "/" + para.ToDate.Year; worksheet.Cells[7, 1].Value = "STT"; worksheet.Cells[7, 2].Value = "Nhân viên"; worksheet.Cells[7, 3].Value = "Máy bán"; worksheet.Cells[7, 4].Value = "Ngày phát sinh"; worksheet.Cells[7, 5].Value = "Loại giao dịch"; worksheet.Cells[7, 6].Value = "Mã hàng"; worksheet.Cells[7, 7].Value = "Tên hàng"; worksheet.Cells[7, 8].Value = "Số lượng"; worksheet.Cells[7, 9].Value = "Tổng tiền"; index = 8; if (data != null && data.Count() >= 1) { var item = data.ToList(); for (int i = 0; i < item.Count; i++) { var hanghoa = new MdMerchandiseVm.Dto(); var innerindex = item[i].MaVatTu; var hanghoatg = _merchandiseservice.UnitOfWork.Repository <MdMerchandise>().DbSet.FirstOrDefault(x => x.MaVatTu == innerindex && x.UnitCode.StartsWith(_ParentUnitCode)); hanghoa = Mapper.Map <MdMerchandise, MdMerchandiseVm.Dto>(hanghoatg); worksheet.Cells[index, 1].Value = index; worksheet.Cells[index, 2].Value = item[i].MaNguoiTao + "-" + item[i].NguoiTao; worksheet.Cells[index, 3].Value = item[i].MaQuayBan; worksheet.Cells[index, 4].Value = item[i].NgayPhatSinh.Date + "/" + item[i].NgayPhatSinh.Month + "/" + item[i].NgayPhatSinh.Year; worksheet.Cells[index, 6].Value = item[i].MaVatTu; if (hanghoa == null) { worksheet.Cells[index, 7].Value = " "; } worksheet.Cells[index, 7].Value = hanghoa.TenHang; worksheet.Cells[index, 8].Value = item[i].SoLuong; worksheet.Cells[index, 9].Value = CurrentSetting.FormatTienViet(item[i].TTienCoVat.ToString()); if (item[i].LoaiGiaoDich == 1) { worksheet.Cells[index, 5].Value = "xuất bán"; } else if (item[i].LoaiGiaoDich == 2) { worksheet.Cells[index, 5].Value = "bán trả lại"; } index++; } } else { //return null; } package.SaveAs(ms); HttpResponseMessage response = Request.CreateResponse(); response.StatusCode = HttpStatusCode.OK; ms.Seek(0, SeekOrigin.Begin); response.Content = new StreamContent(ms); response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCaoGiaoDichQuay.xlsx" }; response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); return(response); } }