public async Task <IHttpActionResult> GetNewParameter() { var unitCode = _serviceKK.GetCurrentUnitCode(); var currentDate = DateTime.Now.Date; var datelock = CurrentSetting.GetNgayKhoaSo(unitCode); var result = new ParameterKiemKe() { ToDate = datelock, FromDate = datelock, MaxDate = currentDate, UnitCode = unitCode, GroupBy = TypeGroupKiemKe.WAREHOUSE, ReportType = TypeReportKiemKe.BAOCAODAYDU }; return(Ok(result)); }
public async Task <IHttpActionResult> GetExternalCode(ParameterKiemKe para) { string unitCode = _service.GetCurrentUnitCode(); MdPeriod curentDate = CurrentSetting.GetKhoaSo(unitCode); if (para.WareHouseCodes == null) { para.WareHouseCodes = unitCode + "-K2"; } string tableName = curentDate.GetTableName(); List <NvKiemKeVm.ExternalCodeInInventory> result = new List <NvKiemKeVm.ExternalCodeInInventory>(); result = ProcedureCollection.GetExternalCodeInventory(unitCode, tableName, para); if (result != null) { return(Ok(result)); } else { return(NotFound()); } }
public HttpResponseMessage PostExportExcelChiTiet(ParameterKiemKe para) { HttpResponseMessage response = Request.CreateResponse(); try { MemoryStream streamData = new MemoryStream(); streamData = _serviceKK.ExportExcelDetail(para); response.StatusCode = HttpStatusCode.OK; streamData.Seek(0, SeekOrigin.Begin); response.Content = new StreamContent(streamData); switch (para.GroupBy) { case TypeGroupKiemKe.GROUP: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BCChiTiet_TheoNhomVatTu.xlsx" }; break; case TypeGroupKiemKe.TYPE: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BCChiTiet_TheoLoaiVatTu.xlsx" }; break; case TypeGroupKiemKe.NHACUNGCAP: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BCChiTiet_TheoNhaCungCap.xlsx" }; break; case TypeGroupKiemKe.MERCHANDISE: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BCChiTiet_TheoVatTu.xlsx" }; break; case TypeGroupKiemKe.WAREHOUSE: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BCChiTiet_TheoKho.xlsx" }; break; case TypeGroupKiemKe.KEHANG: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BCChiTiet_TheoKe.xlsx" }; break; default: response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BCChiTiet.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 async Task <IHttpActionResult> PostReportTongHop(ParameterKiemKe para) { NvKiemKeVm.ReportTongHop reporter = new NvKiemKeVm.ReportTongHop(); List <NvKiemKeVm.ObjectReport> result = new List <NvKiemKeVm.ObjectReport>(); try { var unitCode = _serviceKK.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); switch (para.GroupBy) { case TypeGroupKiemKe.WAREHOUSE: reporter.NameGroupBy = "Kho hàng"; break; case TypeGroupKiemKe.TYPE: reporter.NameGroupBy = "Loại vật tư"; break; case TypeGroupKiemKe.GROUP: reporter.NameGroupBy = "Nhóm vật tư"; break; case TypeGroupKiemKe.MERCHANDISE: reporter.NameGroupBy = "Vật tư"; break; case TypeGroupKiemKe.NHACUNGCAP: reporter.NameGroupBy = "Nhà cung cấp"; break; case TypeGroupKiemKe.KEHANG: reporter.NameGroupBy = "Kệ hàng"; break; default: reporter.NameGroupBy = "Vật tư"; break; } //GetNhanVien if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal) { var currentUser = (HttpContext.Current.User as ClaimsPrincipal); var name = currentUser.Identity.Name; var nhanVien = _serviceKK.UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault(); if (nhanVien != null) { reporter.Username = nhanVien.TenNhanVien; } else { reporter.Username = "******"; } } reporter.DataDetails.AddRange(_serviceKK.ReportKiemKe(para)); } catch (Exception ex) { } return(Ok(reporter)); }