public ActionResult Edit(TemplatePrintViewModel model) { if (ModelState.IsValid) { if (Request["Submit"] == "Save") { var TemplatePrint = TemplatePrintRepository.GetTemplatePrintById(model.Id); AutoMapper.Mapper.Map(model, TemplatePrint); TemplatePrint.ModifiedUserId = WebSecurity.CurrentUserId; TemplatePrint.ModifiedDate = DateTime.Now; TemplatePrintRepository.UpdateTemplatePrint(TemplatePrint); TempData[Globals.SuccessMessageKey] = App_GlobalResources.Wording.UpdateSuccess; return(RedirectToAction("Index")); } return(View(model)); } return(View(model)); //if (Request.UrlReferrer != null) // return Redirect(Request.UrlReferrer.AbsoluteUri); //return RedirectToAction("Index"); }
public ActionResult Print(int Id, bool ExportExcel = false) { var model = new TemplatePrintViewModel(); //lấy logo công ty var logo = Erp.BackOffice.Helpers.Common.GetSetting("LogoCompany"); var company = Erp.BackOffice.Helpers.Common.GetSetting("companyName"); var address = Erp.BackOffice.Helpers.Common.GetSetting("addresscompany"); var phone = Erp.BackOffice.Helpers.Common.GetSetting("phonecompany"); var fax = Erp.BackOffice.Helpers.Common.GetSetting("faxcompany"); var bankcode = Erp.BackOffice.Helpers.Common.GetSetting("bankcode"); var bankname = Erp.BackOffice.Helpers.Common.GetSetting("bankname"); var ImgLogo = "<div class=\"logo\"><img src=" + logo + " height=\"73\" /></div>"; //lấy hóa đơn. var aa = WelfareProgramsRepository.GetWelfareProgramsById(Id); var user = userRepository.GetUserById(aa.CreatedUserId.Value); //lấy thông tin khách hàng var staff = WelfareProgramsDetailRepository.GetAllvwWelfareProgramsDetail().Where(x => x.WelfareProgramsId == aa.Id).ToList(); var ProvideDate = aa.ProvideStartDate.Value.ToString("dd/MM/yyyy HH:mm") + " - " + aa.ProvideEndDate.Value.ToString("dd/MM/yyyy HH:mm"); var RegistrationDate = aa.RegistrationStartDate.Value.ToString("dd/MM/yyyy HH:mm") + " - " + aa.RegistrationEndDate.Value.ToString("dd/MM/yyyy HH:mm"); //lấy template phiếu xuất. var template = templatePrintRepository.GetAllTemplatePrint().Where(x => x.Code.Contains("WelfarePrograms")).OrderByDescending(x => x.CreatedDate).FirstOrDefault(); //truyền dữ liệu vào template. model.Content = template.Content; model.Content = model.Content.Replace("{WelfareCode}", aa.Code); model.Content = model.Content.Replace("{WelfareName}", aa.Name); model.Content = model.Content.Replace("{ProvideDate}", ProvideDate); model.Content = model.Content.Replace("{RegistrationDate}", RegistrationDate); model.Content = model.Content.Replace("{Address}", aa.Address); model.Content = model.Content.Replace("{Category}", aa.Category); model.Content = model.Content.Replace("{StaffCreateName}", user.FullName); model.Content = model.Content.Replace("{DataTable}", buildHtmlDetailList(staff)); model.Content = model.Content.Replace("{System.Logo}", ImgLogo); model.Content = model.Content.Replace("{System.CompanyName}", company); model.Content = model.Content.Replace("{System.AddressCompany}", address); model.Content = model.Content.Replace("{System.PhoneCompany}", phone); model.Content = model.Content.Replace("{System.Fax}", fax); model.Content = model.Content.Replace("{System.BankCodeCompany}", bankcode); model.Content = model.Content.Replace("{System.BankNameCompany}", bankname); //Tạo barcode //Image barcode = Code128Rendering.MakeBarcodeImage(productInvoice.Code, 1, true); //model.Content = model.Content.Replace("{BarcodeImgSource}", ImageToBase64(barcode, System.Drawing.Imaging.ImageFormat.Png)); if (ExportExcel) { Response.AppendHeader("content-disposition", "attachment;filename=" + "KeHoachPhucLoi_" + aa.Code + ".xls"); Response.Charset = ""; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.Write(model.Content); Response.End(); } return(View(model)); }
public ActionResult Print(int?Id, int?TargetId, int?Month, int?Year) { var model = new TemplatePrintViewModel(); //lấy logo công ty //var logo = Erp.BackOffice.Helpers.Common.GetSetting("LogoCompany"); var company = Erp.BackOffice.Helpers.Common.GetSetting("companyName"); var address = Erp.BackOffice.Helpers.Common.GetSetting("addresscompany"); var phone = Erp.BackOffice.Helpers.Common.GetSetting("phonecompany"); var fax = Erp.BackOffice.Helpers.Common.GetSetting("faxcompany"); var bankcode = Erp.BackOffice.Helpers.Common.GetSetting("bankcode"); var bankname = Erp.BackOffice.Helpers.Common.GetSetting("bankname"); //var ImgLogo = "<div class=\"logo\"><img src=" + logo + " height=\"73\" /></div>"; //lấy phiếu chi. vwPayment payment = new vwPayment(); if (Id != null) { payment = paymentRepository.GetvwPaymentById(Id.Value); } else { payment = paymentRepository.GetAllvwPayment().Where(x => x.TargetId == TargetId && x.TargetName == "Staffs" && x.Name == "Chi trả lương tháng " + Month + "/" + Year).FirstOrDefault(); } //lấy template phiếu xuất. var template = templatePrintRepository.GetAllTemplatePrint().Where(x => x.Code.Contains("Payment")).OrderByDescending(x => x.CreatedDate).FirstOrDefault(); //truyền dữ liệu vào template. model.Content = template.Content; model.Content = model.Content.Replace("{Code}", payment.Code); model.Content = model.Content.Replace("{Company}", payment.ReceiverUserName); model.Content = model.Content.Replace("{Customer}", payment.Receiver); model.Content = model.Content.Replace("{Address}", payment.Address); model.Content = model.Content.Replace("{Reason}", payment.Name); model.Content = model.Content.Replace("{Money}", payment.Amount.ToCurrencyStr(null)); model.Content = model.Content.Replace("{VoucherDate}", payment.VoucherDate != null?payment.VoucherDate.Value.ToShortDateString():"chưa có"); model.Content = model.Content.Replace("{CreatedDate}", payment.CreatedDate.Value.ToString("dd/MM/yyyy HH:mm")); model.Content = model.Content.Replace("{SalerName}", payment.SalerName); model.Content = model.Content.Replace("{MoneyText}", Erp.BackOffice.Helpers.Common.ChuyenSoThanhChu_2(payment.Amount.ToString())); model.Content = model.Content.Replace("{Note}", payment.Note); model.Content = model.Content.Replace("{System.CompanyName}", company); model.Content = model.Content.Replace("{System.AddressCompany}", address); model.Content = model.Content.Replace("{System.PhoneCompany}", phone); model.Content = model.Content.Replace("{System.Fax}", fax); model.Content = model.Content.Replace("{System.BankCodeCompany}", bankcode); model.Content = model.Content.Replace("{System.BankNameCompany}", bankname); //Mid model.Content = model.Content.Replace("{DetailList}", buildHtmlDetailList(payment.Id, payment.Amount)); return(View(model)); }
public ActionResult Create(TemplatePrintViewModel model) { if (ModelState.IsValid) { var TemplatePrint = new TemplatePrint(); AutoMapper.Mapper.Map(model, TemplatePrint); TemplatePrint.IsDeleted = false; TemplatePrint.CreatedUserId = WebSecurity.CurrentUserId; TemplatePrint.ModifiedUserId = WebSecurity.CurrentUserId; TemplatePrint.AssignedUserId = WebSecurity.CurrentUserId; TemplatePrint.CreatedDate = DateTime.Now; TemplatePrint.ModifiedDate = DateTime.Now; TemplatePrint.ContentDefault = model.Content; TemplatePrintRepository.InsertTemplatePrint(TemplatePrint); TempData[Globals.SuccessMessageKey] = App_GlobalResources.Wording.InsertSuccess; return(RedirectToAction("Index")); } return(View(model)); }
public ActionResult Edit(int? Id) { var TemplatePrint = TemplatePrintRepository.GetTemplatePrintById(Id.Value); if (TemplatePrint != null && TemplatePrint.IsDeleted != true) { var model = new TemplatePrintViewModel(); AutoMapper.Mapper.Map(TemplatePrint, model); //if (model.CreatedUserId != Helpers.Common.CurrentUser.Id && Helpers.Common.CurrentUser.UserTypeId != 1) //{ // TempData["FailedMessage"] = "NotOwner"; // return RedirectToAction("Index"); //} return View(model); } if (Request.UrlReferrer != null) return Redirect(Request.UrlReferrer.AbsoluteUri); return RedirectToAction("Index"); }
public ActionResult Print(int Id) { var model = new TemplatePrintViewModel(); //lấy logo công ty //var logo = Erp.BackOffice.Helpers.Common.GetSetting("LogoCompany"); var company = Erp.BackOffice.Helpers.Common.GetSetting("companyName"); var address = Erp.BackOffice.Helpers.Common.GetSetting("addresscompany"); var phone = Erp.BackOffice.Helpers.Common.GetSetting("phonecompany"); var fax = Erp.BackOffice.Helpers.Common.GetSetting("faxcompany"); var bankcode = Erp.BackOffice.Helpers.Common.GetSetting("bankcode"); var bankname = Erp.BackOffice.Helpers.Common.GetSetting("bankname"); //var ImgLogo = "<div class=\"logo\"><img src=" + logo + " height=\"73\" /></div>"; //lấy phiếu chi. var payment = paymentRepository.GetvwPaymentById(Id); //lấy template phiếu xuất. var template = templatePrintRepository.GetAllTemplatePrint().Where(x => x.Code.Contains("Payment")).OrderByDescending(x => x.CreatedDate).FirstOrDefault(); //truyền dữ liệu vào template. model.Content = template.Content; model.Content = model.Content.Replace("{Code}", payment.Code); model.Content = model.Content.Replace("{Company}", payment.ReceiverUserName); model.Content = model.Content.Replace("{Customer}", payment.Receiver); model.Content = model.Content.Replace("{Address}", payment.Address); model.Content = model.Content.Replace("{Reason}", payment.Name); model.Content = model.Content.Replace("{Money}", Erp.BackOffice.Helpers.Common.PhanCachHangNgan2(payment.Amount).ToString()); model.Content = model.Content.Replace("{VoucherDate}", payment.VoucherDate.Value.ToShortDateString()); model.Content = model.Content.Replace("{CreatedDate}", payment.CreatedDate.Value.ToString("dd/MM/yyyy HH:mm")); model.Content = model.Content.Replace("{SalerName}", payment.SalerName); model.Content = model.Content.Replace("{MoneyText}", Erp.BackOffice.Helpers.Common.ChuyenSoThanhChu_2(Convert.ToInt32(payment.Amount.Value))); model.Content = model.Content.Replace("{Note}", payment.Note); model.Content = model.Content.Replace("{System.CompanyName}", company); model.Content = model.Content.Replace("{System.AddressCompany}", address); model.Content = model.Content.Replace("{System.PhoneCompany}", phone); model.Content = model.Content.Replace("{System.Fax}", fax); model.Content = model.Content.Replace("{System.BankCodeCompany}", bankcode); model.Content = model.Content.Replace("{System.BankNameCompany}", bankname); return(View(model)); }
public ActionResult Print(int?Id) { var PhysicalInventory = PhysicalInventoryRepository.GetAllvwPhysicalInventory() .Where(item => item.Id == Id).FirstOrDefault(); //lấy logo công ty var logo = Erp.BackOffice.Helpers.Common.GetSetting("LogoCompany"); var company = Erp.BackOffice.Helpers.Common.GetSetting("companyName"); var address = Erp.BackOffice.Helpers.Common.GetSetting("addresscompany"); var phone = Erp.BackOffice.Helpers.Common.GetSetting("phonecompany"); var fax = Erp.BackOffice.Helpers.Common.GetSetting("faxcompany"); var bankcode = Erp.BackOffice.Helpers.Common.GetSetting("bankcode"); var bankname = Erp.BackOffice.Helpers.Common.GetSetting("bankname"); var ImgLogo = "<div class=\"logo\"><img src=" + logo + " height=\"73\" /></div>"; if (PhysicalInventory != null && PhysicalInventory.IsDeleted != true) { var model = new TemplatePrintViewModel(); //lấy danh sách sản phẩm var user = userRepository.GetUserById(PhysicalInventory.CreatedUserId.Value); var detailList = PhysicalInventoryRepository.GetAllvwPhysicalInventoryDetail(Id.Value).AsEnumerable() .Select(item => new PhysicalInventoryDetailViewModel { Note = item.Note, ProductId = item.ProductId, ProductCode = item.ProductCode, ProductName = item.ProductName, PhysicalInventoryId = item.PhysicalInventoryId, QuantityInInventory = item.QuantityInInventory, QuantityRemaining = item.QuantityRemaining, QuantityDiff = item.QuantityDiff, CategoryCode = item.CategoryCode }) .OrderBy(item => item.CategoryCode) .ThenBy(item => item.ProductCode) .ToList(); var groupList = detailList.GroupBy(x => new { x.CategoryCode }, (key, group) => new { CategoryCode = key.CategoryCode, ProductList = group.ToList() }); var ListRow = ""; int n = 1; foreach (var item in groupList) { var Row = "<tr style=\"background:#eee\"><td colspan=\"5\"><b>" + item.CategoryCode + "</b></td></tr>"; foreach (var g in item.ProductList) { Row += "<tr>" + "<td class=\"text-center\">" + n++ + "</td>" + "<td class=\"text-left\">" + g.ProductCode + "-" + g.ProductName + "</td>" + "<td>" + Erp.BackOffice.Helpers.Common.PhanCachHangNgan(g.QuantityInInventory) + "</td>" + "<td>" + Erp.BackOffice.Helpers.Common.PhanCachHangNgan(g.QuantityRemaining) + "</td>" + "<td>" + Erp.BackOffice.Helpers.Common.PhanCachHangNgan(g.QuantityDiff) + "</td></tr>"; } ListRow += Row; } var style = "<style>.invoice-detail{ width:100%;margin-top: 10px;border-spacing: 0px;}" + ".invoice-detail th{border: 1px solid #000;border-right: none;padding: 5px;}" + " .invoice-detail tr th:last-child {border-right: 1px solid #000;}" + " .invoice-detail td{padding: 5px 5px; border-bottom: 1px solid #000; border-left: 1px solid #000; height: 15px;font-size: 12px;}" + " .invoice-detail tr td:last-child {border-right: 1px solid #000;}" + ".invoice-detail tbody tr:last-child td {border-bottom: 1px solid #000;}" + " .invoice-detail tfoot td{font-weight:bold;border-bottom: 1px solid #000;}" + " .invoice-detail tfoot tr:first-child td{border-top: 1px solid #000;}" + ".text-center{text-align:center;}" + ".text-right{text-align:right;}" + ".text-left{text-align:left;}" + " .logo{ width: 100px;float: left; margin: 0 20px;height: 100px;line-height: 100px;}" + ".logo img{ width:100%;vertical-align: middle;}" + "</style>"; var table = style + "<table class=\"invoice-detail\"><thead><tr> <th>STT</th> <th>Tên sản phẩm</th><th>SL hệ thống</th><th>SL thực tế</th><th>SL chênh lệch</th></tr></thead><tbody>" + ListRow + "</tbody></table>"; //lấy template phiếu xuất. var template = templatePrintRepository.GetAllTemplatePrint().Where(x => x.Code.Contains("PhysicalInventory")).OrderByDescending(x => x.CreatedDate).FirstOrDefault(); model.Content = template.Content; model.Content = model.Content.Replace("{Note}", PhysicalInventory.Note); model.Content = model.Content.Replace("{WarehouseName}", PhysicalInventory.WarehouseName); model.Content = model.Content.Replace("{ProductInboundCode}", PhysicalInventory.ProductInboundCode); model.Content = model.Content.Replace("{ProductOutboundCode}", PhysicalInventory.ProductOutboundCode); model.Content = model.Content.Replace("{Code}", PhysicalInventory.Code); model.Content = model.Content.Replace("{Day}", PhysicalInventory.CreatedDate.Value.Day.ToString()); model.Content = model.Content.Replace("{Month}", PhysicalInventory.CreatedDate.Value.Month.ToString()); model.Content = model.Content.Replace("{Year}", PhysicalInventory.CreatedDate.Value.Year.ToString()); model.Content = model.Content.Replace("{DataTable}", table); model.Content = model.Content.Replace("{Logo}", ImgLogo); model.Content = model.Content.Replace("{System.CompanyName}", company); model.Content = model.Content.Replace("{System.AddressCompany}", address); model.Content = model.Content.Replace("{System.PhoneCompany}", phone); model.Content = model.Content.Replace("{System.Fax}", fax); model.Content = model.Content.Replace("{System.BankCodeCompany}", bankcode); model.Content = model.Content.Replace("{System.BankNameCompany}", bankname); return(View(model)); } if (Request.UrlReferrer != null) { return(Redirect(Request.UrlReferrer.AbsoluteUri)); } return(RedirectToAction("Index")); }
public ViewResult Create() { var model = new TemplatePrintViewModel(); return(View(model)); }
public ActionResult Print(int Id, bool ExportExcel = false) { try { var model = new TemplatePrintViewModel(); //lấy logo công ty var logo = Erp.BackOffice.Helpers.Common.GetSetting("LogoCompany"); var company = Erp.BackOffice.Helpers.Common.GetSetting("companyName"); var address = Erp.BackOffice.Helpers.Common.GetSetting("addresscompany"); var phone = Erp.BackOffice.Helpers.Common.GetSetting("phonecompany"); var fax = Erp.BackOffice.Helpers.Common.GetSetting("faxcompany"); var bankcode = Erp.BackOffice.Helpers.Common.GetSetting("bankcode"); var bankname = Erp.BackOffice.Helpers.Common.GetSetting("bankname"); var ImgLogo = "<div class=\"logo\"><img src=" + logo + " height=\"73\" /></div>"; List <vwProductInvoiceDetail> detailList = new List <vwProductInvoiceDetail>(); var TotalDiscountMoneyNT = TotalDiscountMoneyNTRepository.GetvwTotalDiscountMoneyNTById(Id); if (TotalDiscountMoneyNT != null && TotalDiscountMoneyNT.IsDeleted != true) { detailList = productInvoiceRepository.GetAllvwInvoiceDetails() .Where(x => x.IsArchive == true && x.BranchId == TotalDiscountMoneyNT.DrugStoreId && x.Month == TotalDiscountMoneyNT.Month && x.Year == TotalDiscountMoneyNT.Year).ToList(); } //lấy template phiếu xuất. var template = templatePrintRepository.GetAllTemplatePrint().Where(x => x.Code.Contains("TotalDiscountMoneyNT")).OrderByDescending(x => x.CreatedDate).FirstOrDefault(); //truyền dữ liệu vào template. model.Content = template.Content; model.Content = model.Content.Replace("{DrugStoreName}", TotalDiscountMoneyNT.DrugStoreName); model.Content = model.Content.Replace("{MonthYear}", TotalDiscountMoneyNT.Month + " NĂM " + TotalDiscountMoneyNT.Year); model.Content = model.Content.Replace("{PrintDate}", DateTime.Now.ToString("dd/MM/yyyy HH:mm")); model.Content = model.Content.Replace("{QuantityDay}", Erp.BackOffice.Helpers.Common.PhanCachHangNgan2(TotalDiscountMoneyNT.QuantityDay)); model.Content = model.Content.Replace("{PercentDecrease}", Erp.BackOffice.Helpers.CommonSatic.ToCurrencyStr(TotalDiscountMoneyNT.PercentDecrease, null)); model.Content = model.Content.Replace("{DecreaseAmount}", Erp.BackOffice.Helpers.CommonSatic.ToCurrencyStr(TotalDiscountMoneyNT.DecreaseAmount, null)); model.Content = model.Content.Replace("{DiscountAmount}", Erp.BackOffice.Helpers.CommonSatic.ToCurrencyStr(TotalDiscountMoneyNT.DiscountAmount, null)); model.Content = model.Content.Replace("{RemainingAmount}", Erp.BackOffice.Helpers.CommonSatic.ToCurrencyStr(TotalDiscountMoneyNT.RemainingAmount, null)); model.Content = model.Content.Replace("{Amount}", Erp.BackOffice.Helpers.CommonSatic.ToCurrencyStr(detailList.Sum(x => x.Amount), null)); model.Content = model.Content.Replace("{DataTable}", buildHtmlDetailList(detailList)); model.Content = model.Content.Replace("{System.Logo}", ImgLogo); model.Content = model.Content.Replace("{System.CompanyName}", company); model.Content = model.Content.Replace("{System.AddressCompany}", address); model.Content = model.Content.Replace("{System.PhoneCompany}", phone); model.Content = model.Content.Replace("{System.Fax}", fax); model.Content = model.Content.Replace("{System.BankCodeCompany}", bankcode); model.Content = model.Content.Replace("{System.BankNameCompany}", bankname); model.Content = model.Content.Replace("{PrintDate}", DateTime.Now.ToString("dd/MM/yyyy HH:mm")); if (ExportExcel) { Response.AppendHeader("content-disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMdd") + "ChietKhauNhaThuoc" + ".xls"); Response.Charset = ""; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.Write(model.Content); Response.End(); } return(View(model)); } catch (Exception ex) { throw ex; } }
public ActionResult Print(int Id, bool ExportExcel = false) { var model = new TemplatePrintViewModel(); //lấy logo công ty var logo = Erp.BackOffice.Helpers.Common.GetSetting("LogoCompany"); var company = Erp.BackOffice.Helpers.Common.GetSetting("companyName"); var address = Erp.BackOffice.Helpers.Common.GetSetting("addresscompany"); var phone = Erp.BackOffice.Helpers.Common.GetSetting("phonecompany"); var fax = Erp.BackOffice.Helpers.Common.GetSetting("faxcompany"); var bankcode = Erp.BackOffice.Helpers.Common.GetSetting("bankcode"); var bankname = Erp.BackOffice.Helpers.Common.GetSetting("bankname"); var ImgLogo = "<div class=\"logo\"><img src=" + logo + " height=\"73\" /></div>"; //lấy template phiếu xuất. var template = templatePrintRepository.GetAllTemplatePrint().Where(x => x.Code == "RePayPoints").OrderByDescending(x => x.CreatedDate).FirstOrDefault(); if (template != null) { //lấy hóa đơn. var RePayPoints = vwRePayPointsService.Get(Id); //lấy thông tin khách hàng var customer = customerRepository.GetvwCustomerById(RePayPoints.CustomerId.Value); List <RePayPointsDetailViewModel> detailList = new List <RePayPointsDetailViewModel>(); //lấy danh sách sản phẩm xuất kho detailList = vwRePayPointsDetailService.GetAllvwRePayPointsDetailByRePayPointId(Id) .Select(x => new RePayPointsDetailViewModel { Id = x.Id, Point = x.Point, GiftId = x.GiftId, GiftName = x.GiftName, GiftCode = x.GiftCode, Quantity = x.Quantity, Unit = x.Unit, TotalPoint = x.TotalPoint, CategoryCode = x.CategoryCode }).ToList(); //tạo dòng của table html danh sách sản phẩm. var ListRow = ""; int index = 1; foreach (var item in detailList) { var Row = "<tr>" + "<td class=\"text-center\">" + index + "</td>" + "<td class=\"text-left\">" + item.GiftCode + "</td>" + "<td class=\"text-left\">" + item.GiftName + "</td>" + "<td class=\"text-center\">" + item.Unit + "</td>" + "<td class=\"text-right\">" + item.Quantity.Value + "</td>" + "<td class=\"text-right\">" + Helpers.Common.PhanCachHangNgan(item.Point).Replace(".", ",") + "</td>" + "<td class=\"text-right\">" + Helpers.Common.PhanCachHangNgan(item.TotalPoint).Replace(".", ",") + "</td></tr>"; ListRow += Row; index++; } //khởi tạo table html. var table = "<table class=\"invoice-detail\"><thead><tr> <th style=\"width: 30px;\">STT</th><th style=\"width: 100px;\">Mã quà tặng</th><th>Tên quà tặng</th><th style=\"width: 80px;\">ĐVT</th><th style=\"width: 80px;\">Số lượng</th><th style=\"width: 100px;\">Điểm quy đổi</th><th style=\"width: 100px;\">Tổng điểm</th></tr></thead><tbody>" + ListRow + "</tbody><tfoot>" + "</td><td colspan=\"4\" class=\"text-right\">Tổng cộng</td><td class=\"text-right\">" + Erp.BackOffice.Helpers.Common.PhanCachHangNgan(detailList.Sum(x => x.Quantity)).Replace(".", ",") + "</td><td></td><td class=\"text-right\">" + Erp.BackOffice.Helpers.Common.PhanCachHangNgan(RePayPoints.TotalPoint).Replace(".", ",") + "</td></tr>" + "</tfoot></table>"; //truyền dữ liệu vào template. string replacement = template.Content; Helpers.Common.DienDuLieu(ref replacement, RePayPoints, true, true); replacement = replacement.Replace("{Day}", RePayPoints.CreatedDate.Value.Day.ToString()); replacement = replacement.Replace("{Month}", RePayPoints.CreatedDate.Value.Month.ToString()); replacement = replacement.Replace("{Year}", RePayPoints.CreatedDate.Value.Year.ToString()); replacement = replacement.Replace("{CustomerPhone}", customer.Phone); replacement = replacement.Replace("{DataTable}", table); replacement = replacement.Replace("{System.Logo}", ImgLogo); replacement = replacement.Replace("{System.CompanyName}", company); replacement = replacement.Replace("{System.AddressCompany}", address); replacement = replacement.Replace("{System.PhoneCompany}", phone); replacement = replacement.Replace("{System.Fax}", fax); replacement = replacement.Replace("{System.BankCodeCompany}", bankcode); replacement = replacement.Replace("{System.BankNameCompany}", bankname); model.Content = replacement; if (ExportExcel) { Response.AppendHeader("content-disposition", "attachment;filename=" + RePayPoints.CreatedDate.Value.ToString("yyyyMMdd") + RePayPoints.Code + ".xlsx"); Response.Charset = "iso-8859-1"; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.Write(model.Content); Response.End(); } } return(View(model)); }
public ActionResult Print(int?month, int?year, string Status, bool ExportExcel = false) { var model = new TemplatePrintViewModel(); //lấy logo công ty var logo = Erp.BackOffice.Helpers.Common.GetSetting("LogoCompany"); var company = Erp.BackOffice.Helpers.Common.GetSetting("companyName"); var address = Erp.BackOffice.Helpers.Common.GetSetting("addresscompany"); var phone = Erp.BackOffice.Helpers.Common.GetSetting("phonecompany"); var fax = Erp.BackOffice.Helpers.Common.GetSetting("faxcompany"); var bankcode = Erp.BackOffice.Helpers.Common.GetSetting("bankcode"); var bankname = Erp.BackOffice.Helpers.Common.GetSetting("bankname"); var ImgLogo = "<div class=\"logo\"><img src=" + logo + " height=\"73\" /></div>"; List <HistoryCommissionStaffViewModel> q = HistoryCommissionStaffRepository.GetAllHistoryCommissionStaffFull() .Select(item => new HistoryCommissionStaffViewModel { Id = item.Id, CreatedUserId = item.CreatedUserId, //CreatedUserName = item.CreatedUserName, CreatedDate = item.CreatedDate, ModifiedUserId = item.ModifiedUserId, //ModifiedUserName = item.ModifiedUserName, ModifiedDate = item.ModifiedDate, Month = item.Month, Year = item.Year, AmountCommission = item.AmountCommission, CommissionPercent = item.CommissionPercent, MinimumRevenue = item.MinimumRevenue, PositionName = item.PositionName, RevenueDS = item.RevenueDS, StaffId = item.StaffId, StaffName = item.StaffName, IsDeleted = item.IsDeleted }).OrderByDescending(m => m.ModifiedDate).ToList(); if (month != null && month.Value > 0) { q = q.Where(x => x.Month == month).ToList(); } else { q = q.Where(x => x.Month == DateTime.Now.Month).ToList(); } if (year != null && year.Value > 0) { q = q.Where(x => x.Year == year).ToList(); } else { q = q.Where(x => x.Year == DateTime.Now.Year).ToList(); } if (!string.IsNullOrEmpty(Status)) { if (Status == "unsuccess") { q = q.Where(x => x.IsDeleted == null || x.IsDeleted == true).ToList(); } if (Status == "success") { q = q.Where(x => x.IsDeleted == false).ToList(); } } if (Erp.BackOffice.Filters.SecurityFilter.IsTrinhDuocVien()) { var staff = staffRepository.GetvwStaffsByUser(WebSecurity.CurrentUserId); if (staff != null) { q = q.Where(x => x.StaffId == staff.Id).ToList(); } else { q = null; } } if (Erp.BackOffice.Filters.SecurityFilter.IsAdminSystemManager()) { var staff = staffRepository.GetvwStaffsByUser(WebSecurity.CurrentUserId); var item_staff = q.Where(x => x.StaffId == staff.Id).ToList(); q = q.Where(x => x.StaffParentId != null && x.StaffParentId == staff.Id).ToList(); q = q.Union(item_staff).OrderByDescending(x => x.ModifiedDate).ToList(); } //lấy template phiếu xuất. var template = templatePrintRepository.GetAllTemplatePrint().Where(x => x.Code.Contains("PrintHistoryCommissionStaff")).OrderByDescending(x => x.CreatedDate).FirstOrDefault(); //truyền dữ liệu vào template. model.Content = template.Content; model.Content = model.Content.Replace("{DataTable}", buildHtmlDetailList_PrintBCNXT(q)); model.Content = model.Content.Replace("{System.Logo}", ImgLogo); model.Content = model.Content.Replace("{System.CompanyName}", company); model.Content = model.Content.Replace("{System.AddressCompany}", address); model.Content = model.Content.Replace("{System.PhoneCompany}", phone); model.Content = model.Content.Replace("{System.Fax}", fax); model.Content = model.Content.Replace("{System.BankCodeCompany}", bankcode); model.Content = model.Content.Replace("{System.BankNameCompany}", bankname); model.Content = model.Content.Replace("{PrintDate}", DateTime.Now.ToString("dd/MM/yyyy HH:mm")); model.Content = model.Content.Replace("{Title.month}", "Tháng " + month + " năm " + year); if (ExportExcel) { Response.AppendHeader("content-disposition", "attachment;filename=" + "BaoCaoHoaHongNhanVien" + DateTime.Now.ToString("yyyyMMdd") + ".xls"); Response.Charset = ""; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.Write(model.Content); Response.End(); } return(View(model)); }