public ExpressDeliveryFeeListModel() { Filter = new ExpressDeliveryFeeListFilterModel(); PagedList = new PagedList <ExpressDeliveryFeeModel>(); SearchWhereTypes = new List <SelectListItem>(); StatusList = new List <SelectListItem>(); }
public ActionResult ExpressImportWaitAduit(ExpressDeliveryFeeListFilterModel filter) { var model = ExpressDeliveryFeeListInit(); model.Filter = filter; model.PagedList = _financialService.ExpressImportWait2Audit(new DeliveryReviewParam() { Page = filter.Page, PageSize = filter.PageSize, UserName = _workContext.User.UserUame, Status = filter.Status }).ToModelAsPageCollection <DeliveryFeeExpressExt, ExpressDeliveryFeeModel>(); return(View("ExpressDeliveryImportWaitAduitPartList", model)); }
public ActionResult SearchExpressAjax(ExpressDeliveryFeeListFilterModel filter) { var model = ExpressDeliveryFeeListInit(); model.Filter = filter; var list = GetShippingMethods(filter.VenderCode, filter.ShippingType); if (list != null && list.Any()) { string _shippingmethodid = filter.SearchContext.IsNullOrWhiteSpace() ? filter.ShippingMethodId : string.Empty; model.PagedList = _financialService.ExpressDeliveryFeeSearch(new DeliveryReviewParam() { EndTime = filter.EndTime, Page = filter.Page, PageSize = filter.PageSize, SearchContext = filter.SearchContext, SearchWhere = filter.SearchWhere, ShippingMethodId = _shippingmethodid, StartTime = filter.StartTime, Status = filter.Status, VenderCode = filter.VenderCode, ShippingMethodIds = _shippingmethodid.IsNullOrWhiteSpace()? list.Select(p => p.ShippingMethodId).ToArray():new int[1] { Int32.Parse(_shippingmethodid) } }).ToModelAsPageCollection <DeliveryFeeExt, ExpressDeliveryFeeModel>(); } else { model.PagedList = new PagedList <ExpressDeliveryFeeModel>(); } return(View("ExpressDeliveryFeePartialList", model)); }
public ActionResult ExpressExportExcel(ExpressDeliveryFeeListFilterModel filter) { HttpContext.Server.ScriptTimeout = 100 * 60; //10 minutes Log.Info("开始导出快递发货费用"); string fileName = "ExpressDeliveryFeeList-" + filter.VenderCode + "-" + DateTime.Now.ToString("yyyy-dd-MM-hh-mm-ss") + "1"; var list = new List <ExpressDeliveryFeeModel>(); Log.Info("开始获取快递的运输方式"); var shippingMethods = GetShippingMethods(filter.VenderCode, filter.ShippingType); Log.Info("完成获取快递的运输方式"); if (shippingMethods != null && shippingMethods.Any()) { Log.Info("开始查询快递发货费用列表"); _financialService.ExportExcel(new DeliveryReviewParam() { EndTime = filter.EndTime, Page = filter.Page, PageSize = filter.PageSize, SearchContext = filter.SearchContext, SearchWhere = filter.SearchWhere, ShippingMethodId = filter.ShippingMethodId, StartTime = filter.StartTime, Status = filter.Status, VenderCode = filter.VenderCode, IsExportExcel = true, ShippingMethodIds = shippingMethods.Select(p => p.ShippingMethodId).ToArray(), }, false, true).ForEach(d => list.Add(new ExpressDeliveryFeeModel() { AprroveWeight = d.AprroveWeight, Auditor = d.Auditor, AuditorDate = d.AuditorDate, CountryChineseName = d.CountryChineseName, CountryCode = d.CountryCode, CustomerName = d.CustomerName, CreatedBy = d.CreatedBy, CreatedOn = d.CreatedOn, CustomerOrderNumber = d.CustomerOrderNumber, DeliveryFeeID = d.DeliveryFeeID, Freight = d.Freight, FuelCharge = d.FuelCharge, LastUpdatedBy = d.LastUpdatedBy, LastUpdatedOn = d.LastUpdatedOn, OutStorageCreatedOn = d.OutStorageCreatedOn, Register = d.Register, Remark = d.Remark, SetWeight = d.SetWeight, ShippingmethodID = d.ShippingmethodID, ShippingmethodName = d.ShippingmethodName, Status = d.Status, StatusStr = ConvertStatusToString(d.Status), Surcharge = d.Surcharge, TariffPrepayFee = d.TariffPrepayFee, OverWeightLengthGirthFee = d.OverWeightLengthGirthFee, SecurityAppendFee = d.SecurityAppendFee, AddedTaxFee = d.AddedTaxFee, OtherFee = d.OtherFee, OtherFeeRemark = d.OtherFeeRemark, TotalFee = d.TotalFee, TotalFeeFinal = d.TotalFeeFinal, Trackingnumber = d.Trackingnumber, VenderCode = d.VenderCode, VenderId = d.VenderId, VenderName = d.VenderName, WayBillNumber = d.WayBillNumber, Weight = d.Weight, })); Log.Info("完成查询快递发货费用列表"); } Log.Info("开始生成快递execl"); var titleList = new List <string> { "WayBillNumber-运单号", "CustomerOrderNumber-客户订单号", "CustomerName-客户名称", "Trackingnumber-跟踪号", "VenderName-服务商", "OutStorageCreatedOn-发货时间", "CountryCode-发货国家", "ShippingmethodName-运输方式", "SetWeight-计费重量", "Weight-称重重量", "AprroveWeight-最终重量", "Freight-运费", "Register-挂号费", "FuelCharge-燃油费", "Surcharge-附加费", "TariffPrepayFee-关税服务费用", "OverWeightLengthGirthFee-超长超重超周长费", "SecurityAppendFee-安全附加费", "AddedTaxFee-增值税费", "OtherFee-杂费", "OtherFeeRemark-杂费备注", "TotalFee-系统总费用", "TotalFeeFinal-最终总费用", "StatusStr-状态", "Auditor-审核人", "AuditorDate-审核时间" }; ExportExcelByWeb.ListExcel(fileName, list, titleList); Log.Info("完成生成快递execl"); Log.Info("完成导出快递发货费用"); return(new EmptyResult()); }