public IPagedList <Entities.ImportTrans_main_record> searchListBuyerSj(SysCustomizedListSearchArg arg, int page, int size, string buyer) { var query = _importTrans_main_recordRepository.Table.Where(o => o.IsDeleted != true && o.Buyer == buyer); if (arg != null) { if (!String.IsNullOrEmpty(arg.waybill)) { query = query.Where(o => o.Mbl.Contains(arg.waybill)); } if (!String.IsNullOrEmpty(arg.itemno)) { query = query.Where(o => o.Itemno.Contains(arg.itemno)); } if (!String.IsNullOrEmpty(arg.shipper)) { query = query.Where(o => o.Shipper.Contains(arg.shipper)); } if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.PoNo.Contains(arg.pono)); } if (!String.IsNullOrEmpty(arg.invcurr)) { query = query.Where(o => o.Invcurr.Contains(arg.invcurr)); } } query = query.OrderByDescending(o => o.Id); // query = query.OrderBy(o => o.CustomizedClassify).ThenBy(o => o.CustomizedValue).ThenByDescending(o => o.CreationTime); return(new PagedList <Entities.ImportTrans_main_record>(query, page, size)); }
public IPagedList <Entities.ImportTrans_main_record> searchListLogistics(SysCustomizedListSearchArg arg, int page, int size) { var query = _importTrans_main_recordRepository.Table.Where(o => o.IsDeleted != true && o.CheckAndPass != "是"); if (arg != null) { if (!String.IsNullOrEmpty(arg.waybill)) { query = query.Where(o => o.Mbl.Contains(arg.waybill)); } if (!String.IsNullOrEmpty(arg.itemno)) { query = query.Where(o => o.Id == Convert.ToInt32(arg.itemno)); } if (!String.IsNullOrEmpty(arg.shipper)) { query = query.Where(o => o.Shipper.Contains(arg.shipper)); } if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.PoNo.Contains(arg.pono)); } if (!String.IsNullOrEmpty(arg.invcurr)) { query = query.Where(o => o.Invcurr.Contains(arg.invcurr)); } } query = query.OrderByDescending(o => o.Id); return(new PagedList <Entities.ImportTrans_main_record>(query, page, size)); }
public IPagedList <Entities.ImportTrans_main_record> searchListYd(SysCustomizedListSearchArg arg, int page, int size, string port, string tran) { var query = _importTrans_main_recordRepository.Table.Where(o => o.IsDeleted != true); query = query.Where(o => (o.Forwarder == port && o.Forwarder != null) || (o.Transportation == tran && o.Transportation != null)); if (arg.invcurr != null || arg.itemno != null || arg.keyword != null || arg.materiel != null || arg.pono != null || arg.realreceivingdatestrat != null || arg.realreceivingdateend != null || arg.shipper != null) { if (port == null && tran == null) { query = query.Where(o => o.Id == 0); } else { if (!String.IsNullOrEmpty(arg.waybill)) { query = query.Where(o => o.Mbl.Contains(arg.waybill)); } if (!String.IsNullOrEmpty(arg.itemno)) { query = query.Where(o => o.Id == Convert.ToInt32(arg.itemno)); } if (!String.IsNullOrEmpty(arg.shipper)) { query = query.Where(o => o.Shipper.Contains(arg.shipper)); } if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.PoNo.Contains(arg.pono)); } if (!String.IsNullOrEmpty(arg.invcurr)) { query = query.Where(o => o.Invcurr.Contains(arg.invcurr)); } if (arg.realreceivingdateend != null) { query = query.Where(o => o.RealReceivingDate < arg.realreceivingdateend.Value.AddDays(1)); } if (arg.realreceivingdatestrat != null) { query = query.Where(o => o.RealReceivingDate > arg.realreceivingdatestrat); } } } else { if (port == null && tran == null) { query = query.Where(o => o.Id == 0); } else { // query = query.Where(o => o.CheckAndPass != "是"); } } query = query.OrderByDescending(o => o.Id); // query = query.OrderBy(o => o.CustomizedClassify).ThenBy(o => o.CustomizedValue).ThenByDescending(o => o.CreationTime); return(new PagedList <Entities.ImportTrans_main_record>(query, page, size)); }
public IActionResult ForwardChooseIndex(SysCustomizedListSearchArg arg, int page = 1, int size = 20) { var pageList = _sysForwardChooseService.searchForwardChoose(arg, page, size); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.ForwardChoose, SysCustomizedListSearchArg>("ForwardChooseIndex", arg); return(View(dataSource)); }
public IActionResult SupplierIndex(SysCustomizedListSearchArg arg, int page = 1, int size = 20) { var pageList = _sysSupplierService.searchSupplier(arg, page, size); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.Supplier, SysCustomizedListSearchArg>("SupplierIndex", arg); return(View(dataSource)); }
public IActionResult ITPorkCustomsAttachmentIndex(int id, SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); var pageList = _attachmentService.searchPorkAttachment(arg, page, size, id); ViewBag.Arg = arg;//传参数ITTransportAttachmentIndex var dataSource = pageList.toDataSourceResult <Entities.Attachment, SysCustomizedListSearchArg>("itPorkCustoms", arg); return(View(dataSource));//sysImport }
public IActionResult ITShipmentCreateIndex(SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); var pageList = _importTrans_main_recordService.searchList(arg, page, size); ViewBag.Arg = arg;//传参数 ViewBag.QX = WorkContext.CurrentUser.RoleName; var dataSource = pageList.toDataSourceResult <Entities.ImportTrans_main_record, SysCustomizedListSearchArg>("itShipmentCreate", arg); return(View(dataSource));//sysImport }
public IActionResult CCPaymentInvoiceIndex(SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); ViewBag.QX = WorkContext.CurrentUser.Name; var pageList = _sysInspectionMainService.searchInspecationMain(arg, page, size, WorkContext.CurrentUser.Name); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.InspecationMain, SysCustomizedListSearchArg>("inspection", arg); return(View(dataSource));//sysImport InvoiceSch }
public IActionResult ITShipmentCreateTranIndex(SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); string port = WorkContext.CurrentUser.Port; string tran = WorkContext.CurrentUser.Transport; var pageList = _importTrans_main_recordService.searchListYd(arg, page, size, port, tran); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.ImportTrans_main_record, SysCustomizedListSearchArg>("itShipmentCreatetran", arg); return(View(dataSource));//sysImport }
public IActionResult ITModeShippingGivenIndex(List <int> sysResource, SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); var customizedList = _sysCustomizedListService.getByAccount("货币类型"); ViewData["Companys"] = new SelectList(customizedList, "CustomizedValue", "CustomizedValue"); var pageList = _importTrans_main_recordService.searchList(arg, page, size); ViewBag.Arg = arg; //传参数 var dataSource = pageList.toDataSourceResult <Entities.ImportTrans_main_record, SysCustomizedListSearchArg>("iTModeShippingGiven", arg); return(View(dataSource)); //sysImport }
public IPagedList <Entities.InspecationMain> searchInspecationMainjy(SysCustomizedListSearchArg arg, int page, int size) { var query = _sysInspecationMainRepository.Table.Where(o => o.IsDeleted != true && o.flag > 3); if (arg != null) { if (!String.IsNullOrEmpty(arg.itemno)) { query = query.Where(o => o.InspecationMainId.Contains(arg.itemno)); } } query = query.OrderBy(o => o.CreationTime); return(new PagedList <Entities.InspecationMain>(query, page, size)); }
public IPagedList <Entities.Attachment> searchPorkAttachment(SysCustomizedListSearchArg arg, int page, int size, int id) { var query = _sysAttachmentRepository.Table.Where(o => o.ImportId == id && o.Type == "破损记录" && o.IsDelet != true); if (arg != null) { if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.ImportId == Convert.ToInt32(arg.pono)); } } query = query.OrderBy(o => o.ImportId); return(new PagedList <Entities.Attachment>(query, page, size)); }
/// <summary> /// 搜索数据 /// </summary> /// <param name="arg"></param> /// <param name="page"></param> /// <param name="size"></param> /// <returns></returns> public IPagedList <Entities.Material> searchMaterial(SysCustomizedListSearchArg arg, int page, int size) { var query = _sysMaterialRepository.Table; if (arg != null) { if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.MaterialCode.Contains(arg.pono)); } } query = query.OrderBy(o => o.MaterialCode); return(new PagedList <Entities.Material>(query, page, size)); }
public IPagedList <Entities.SysCustomizedList> searchList(SysCustomizedListSearchArg arg, int page, int size) { var query = _sysCustomizedListRepository.Table.Where(o => !o.IsDeleted); if (arg != null) { if (!String.IsNullOrEmpty(arg.keyword)) { query = query.Where(o => o.CustomizedClassify.Contains(arg.keyword) || o.CustomizedValue.Contains(arg.keyword) || o.Description.Contains(arg.keyword)); } } query = query.OrderBy(o => o.CustomizedClassify).ThenBy(o => o.CustomizedValue).ThenByDescending(o => o.CreationTime); return(new PagedList <Entities.SysCustomizedList>(query, page, size)); }
/// <summary> /// 搜索数据 /// </summary> /// <param name="arg"></param> /// <param name="page"></param> /// <param name="size"></param> /// <returns></returns> public IPagedList <Entities.Supplier> searchSupplier(SysCustomizedListSearchArg arg, int page, int size) { var query = _sysSupplierRepository.Table; if (arg != null) { if (!String.IsNullOrEmpty(arg.keyword)) { query = query.Where(o => o.SupplierCode.Contains(arg.keyword)); } } query = query.OrderBy(o => o.SupplierCode); return(new PagedList <Entities.Supplier>(query, page, size)); }
/// <summary> /// 搜索数据 /// </summary> /// <param name="arg"></param> /// <param name="page"></param> /// <param name="size"></param> /// <returns></returns> public IPagedList <Entities.ForwardChoose> searchForwardChoose(SysCustomizedListSearchArg arg, int page, int size) { var query = _sysForwardChooseRepository.Table; if (arg != null) { if (!String.IsNullOrEmpty(arg.keyword)) { query = query.Where(o => o.Forward == arg.keyword); } } query = query.OrderBy(o => o.Dest); return(new PagedList <Entities.ForwardChoose>(query, page, size)); }
public IActionResult ETCPAInventoryInputIndex(List <int> sysResource, SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); var customizedList = _sysCustomizedListService.getByAccount("付费方式"); ViewData["Companys"] = new SelectList(customizedList, "CustomizedValue", "CustomizedValue"); string flag = "综保区填写核注清单"; var pageList = _exportTransportationService.searchList(arg, page, size, flag); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.ExportTransportation, SysCustomizedListSearchArg>("etCPAInventoryInput", arg); return(View(dataSource));//sysImport }
public IActionResult ITScheduleImportIndex(SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); var customizedList = _sysCustomizedListService.getByAccount("货币类型"); ViewData["Companys"] = new SelectList(customizedList, "CustomizedValue", "CustomizedValue"); var pageList = _sysOrderService.searchOrder(arg, page, size); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.Order, SysCustomizedListSearchArg>("itScheduleImportIndex", arg); return(View(dataSource));//sysImport }
public IActionResult ITDetailIndex(SysCustomizedListSearchArg arg, int page = 1, int size = 20) { var customizedList = _sysCustomizedListService.getByAccount("货币类型"); ViewData["Companys"] = new SelectList(customizedList, "CustomizedValue", "CustomizedValue"); var USER = _sysUserRoleService.getById(WorkContext.CurrentUser.Id); ViewBag.Role = USER.RoleName; var pageList = _importTrans_main_recordService.searchList(arg, page, size); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.ImportTrans_main_record, SysCustomizedListSearchArg>("itDetail", arg); return(View(dataSource));//sysImport }
public IActionResult ITConfirmedCustomsIndex(List <int> sysResource, SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); var customizedList = _sysCustomizedListService.getByAccount("是否"); ViewData["CheckAndPass"] = new SelectList(customizedList, "CustomizedValue", "Description"); //var customizedList2 = _sysCustomizedListService.getByAccount("运输状态"); //ViewData["Status"] = new SelectList(customizedList2, "CustomizedValue", "CustomizedValue"); ViewBag.QX = WorkContext.CurrentUser.Co; var pageList = _importTrans_main_recordService.searchListLogistics(arg, page, size); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.ImportTrans_main_record, SysCustomizedListSearchArg>("itConfirmedCustoms", arg); return(View(dataSource));//sysImport }
public IPagedList <Entities.Schedule> searchList(SysCustomizedListSearchArg arg, int page, int size, int id) { var query = _scheduleRepository.Table.Where(o => o.MainId == id && !o.IsDeleted); if (arg != null) { if (!String.IsNullOrEmpty(arg.materiel)) { query = query.Where(o => o.MaterialCode.Contains(arg.materiel)); } // if (!String.IsNullOrEmpty(arg.shipper)) // query = query.Where(o => o.Shipper.Contains(arg.shipper)); // if (!String.IsNullOrEmpty(arg.pono)) // query = query.Where(o => o.PoNo.Contains(arg.pono)); // if (!String.IsNullOrEmpty(arg.invcurr)) // query = query.Where(o => o.Invcurr.Contains(arg.invcurr)); } query = query.OrderBy(o => o.CreationTime).ThenBy(o => o.OrderLine).ThenByDescending(o => o.CreationTime); return(new PagedList <Entities.Schedule>(query, page, size)); }
/// <summary> /// 搜索数据 /// </summary> /// <param name="arg"></param> /// <param name="page"></param> /// <param name="size"></param> /// <returns></returns> public IPagedList <Entities.Invoice> searchInvoice(SysCustomizedListSearchArg arg, int page, int size, int id) { var query = _sysInvoiceRepository.Table.Include(p => p.InvoiceMain).Where(o => o.UnPlaceQty != 0 && o.InvoiceMain.IsDeleted != true && o.InvoiceMain.Id == id); if (arg != null) { if (!String.IsNullOrEmpty(arg.itemno)) { query = query.Where(o => o.ContractNo.Contains(arg.itemno)); } if (!String.IsNullOrEmpty(arg.shipper)) { query = query.Where(o => o.Batch.Contains(arg.shipper)); } if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.MaterialCode.Contains(arg.pono)); } } // query = query.OrderBy(o => o.Cre); return(new PagedList <Entities.Invoice>(query, page, size)); }
public IPagedList <Entities.InspectionRecord> searchInspectionbg(SysCustomizedListSearchArg arg, int page, int size) { var query = _sysInspectionRecordRepository.Table.Where(o => o.Status == "保管员审批中"); if (arg != null) { if (!String.IsNullOrEmpty(arg.itemno)) { query = query.Where(o => o.ContractNo.Contains(arg.itemno)); } if (!String.IsNullOrEmpty(arg.shipper)) { query = query.Where(o => o.Batch.Contains(arg.shipper)); } if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.MaterialCode.Contains(arg.pono)); } } // query = query.OrderBy(o => o.Cre); return(new PagedList <Entities.InspectionRecord>(query, page, size)); }
public IActionResult InspectionjyyAttachmentIndex(int id, SysCustomizedListSearchArg arg, int page = 1, int size = 20) { string s = ""; int ida = 0; if (id != 0) { ida = id; } else { Request.Cookies.TryGetValue("Inspection", out s); ida = Convert.ToInt32(s); } RolePermissionViewModel model = new RolePermissionViewModel(); var pageList = _InspectionAttachmentService.searchInspectionAttachment(arg, page, size, id); ViewBag.Arg = arg;//传参数ITTransportAttachmentIndex var dataSource = pageList.toDataSourceResult <Entities.InspectionAttachment, SysCustomizedListSearchArg>("ZbdAttachment", arg); return(View(dataSource));//sysImport }
public IActionResult ITPorkCustomsIndex(List <int> sysResource, SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); var customizedList = _sysCustomizedListService.getByAccount("自行送货或外部提货"); ViewData["ChooseDelivery"] = new SelectList(customizedList, "CustomizedValue", "CustomizedValue"); var customizedList2 = _sysCustomizedListService.getByAccount("是否调用明细表生成二检明细"); ViewData["DeliveryReceipt"] = new SelectList(customizedList2, "CustomizedValue", "CustomizedValue"); var customizedList3 = _sysCustomizedListService.getByAccount("是否破损"); ViewData["BrokenRecord"] = new SelectList(customizedList3, "CustomizedValue", "CustomizedValue"); //var customizedList2 = _sysCustomizedListService.getByAccount("运输状态"); //ViewData["Status"] = new SelectList(customizedList2, "CustomizedValue", "CustomizedValue"); var pageList = _importTrans_main_recordService.searchListPortCustomerBroker(arg, page, size, WorkContext.CurrentUser.Port); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.ImportTrans_main_record, SysCustomizedListSearchArg>("itPorkCustoms", arg); return(View(dataSource));//sysImport }
public IPagedList <Entities.Order> searchOrderD(SysCustomizedListSearchArg arg, int page, int size, string orderno) { var query = _sysOrderRepository.Table.Include(p => p.Main).Where(o => o.Main.IsDeleted != true && o.Main.OrderNo == orderno && o.IsDeleted != true); if (arg != null) { if (!String.IsNullOrEmpty(arg.itemno)) { query = query.Where(o => o.Item.Contains(arg.itemno)); } if (!String.IsNullOrEmpty(arg.shipper)) { query = query.Where(o => o.PartNo.Contains(arg.shipper)); } if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.Specification.Contains(arg.pono)); } } query = query.OrderBy(o => o.Id); return(new PagedList <Entities.Order>(query, page, size)); }
/// <summary> /// 搜索数据 /// </summary> /// <param name="arg"></param> /// <param name="page"></param> /// <param name="size"></param> /// <returns></returns> public IPagedList <Entities.OrderMain> searchOrderMain(SysCustomizedListSearchArg arg, int page, int size, string role, string name) { var query = _sysOrderMainRepository.Table.Where(o => o.IsDeleted != true); if (role == "采购员") { query = query.Where(o => o.OrderSigner == name); } if (arg != null) { if (!String.IsNullOrEmpty(arg.itemno)) { query = query.Where(o => o.OrderNo.Contains(arg.itemno)); } if (!String.IsNullOrEmpty(arg.shipper)) { query = query.Where(o => o.SupplierCode.Contains(arg.shipper)); } if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.OrderSigner.Contains(arg.pono)); } if (!String.IsNullOrEmpty(arg.invcurr)) { query = query.Where(o => o.Project.Contains(arg.invcurr)); } if (arg.realreceivingdateend != null) { query = query.Where(o => o.OrderConfirmDate < arg.realreceivingdateend.Value.AddDays(1)); } if (arg.realreceivingdatestrat != null) { query = query.Where(o => o.OrderConfirmDate > arg.realreceivingdatestrat); } } query = query.OrderBy(o => o.OrderNo); return(new PagedList <Entities.OrderMain>(query, page, size)); }
public IActionResult ITLogisticsIndex(List <int> sysResource, SysCustomizedListSearchArg arg, int page = 1, int size = 20) { RolePermissionViewModel model = new RolePermissionViewModel(); var customizedList = _sysCustomizedListService.getByAccount("运输方式"); ViewData["ShippingMode"] = new SelectList(customizedList, "CustomizedValue", "CustomizedValue"); var customizedList3 = _sysCustomizedListService.getByAccount("送货要求"); ViewData["DeliveryRequiredDate"] = new SelectList(customizedList3, "CustomizedValue", "CustomizedValue"); var customizedList2 = _sysUserService.getPorkCustoms(); ViewData["PorkCustoms"] = new SelectList(customizedList2, "Port", "Port"); var customizedList4 = _sysUserService.getBuyer(); ViewData["Buyer"] = new SelectList(customizedList4, "Name", "Name"); ViewBag.QX = WorkContext.CurrentUser.Co; var pageList = _importTrans_main_recordService.searchListLogistics(arg, page, size); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.ImportTrans_main_record, SysCustomizedListSearchArg>("itLogistics", arg); return(View(dataSource));//sysImport }
public IActionResult InvoiceSchIndex(int id, SysCustomizedListSearchArg arg, int page = 1, int size = 20) { string s; if (id != 0) { Response.Cookies.Append("Inspection", Convert.ToString(id)); s = Convert.ToString(id); } else { Request.Cookies.TryGetValue("Inspection", out s); } int ida = Convert.ToInt32(s); RolePermissionViewModel model = new RolePermissionViewModel(); ViewBag.QX = WorkContext.CurrentUser.Co; var pageList = _sysInspectionService.searchInspection(arg, page, size, ida); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.Inspection, SysCustomizedListSearchArg>("inspection", arg); return(View(dataSource));//sysImport }
public IPagedList <Entities.ImportTrans_main_record_copy> searchListLogistics(SysCustomizedListSearchArg arg, int page, int size) { var query = _ImportTrans_main_record_copyRepository.Table.Where(o => o.IsDeleted != true); if (arg != null) { query = query.Where(o => o.Shipper.Contains(arg.shipper)); if (!String.IsNullOrEmpty(arg.pono)) { query = query.Where(o => o.PoNo.Contains(arg.pono)); } if (!String.IsNullOrEmpty(arg.invcurr)) { query = query.Where(o => o.Invcurr.Contains(arg.invcurr)); } } query = query.OrderBy(o => o.CreationTime); return(new PagedList <Entities.ImportTrans_main_record_copy>(query, page, size)); }