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));
}
