public SearchResult SearchProductWarehouseMain(SearchProductWarehouseMainArgs args) { if (String.IsNullOrEmpty(args.OrderBy)) { args.OrderBy = "[BillNo] ASC"; } SqlCommand cmd = new SqlCommand(); StringBuilder mbBuilder = new StringBuilder(); mbBuilder.AppendFormat("("); mbBuilder.AppendFormat(@"SELECT [InID] ,[BillNo] ,[BE_ProductWarehouseMain].[OrderID] ,[BE_Order].[OrderNo] ,[BE_Order].[CustomerName] ,[BE_Order].[Address] ,[BE_Order].[LinkMan] ,[BE_Order].[Mobile] ,[BE_ProductWarehouseMain].[Created] ,[BE_ProductWarehouseMain].[CreatedBy] ,[BE_ProductWarehouseMain].[Modified] ,[BE_ProductWarehouseMain].[ModifiedBy] FROM [BE_ProductWarehouseMain] with(nolock) LEFT JOIN [BE_Order] with(nolock) on [BE_ProductWarehouseMain].[OrderID] = [BE_Order].[OrderID] WHERE 1=1" ); if (args.InID.HasValue) { this.SetParameters_Equals(mbBuilder, cmd, "InID", "mbInID", args.InID.Value); } if (args.OrderID.HasValue) { this.SetParameters_Equals(mbBuilder, cmd, "BE_ProductWarehouseMain].[OrderID", "mbOrderID", args.OrderID.Value); } if (!string.IsNullOrEmpty(args.BillNo)) { this.SetParameters_Contains(mbBuilder, cmd, "BillNo", "mbBillNo", args.BillNo); } if (!string.IsNullOrEmpty(args.CustomerName)) { this.SetParameters_Contains(mbBuilder, cmd, "BE_Order].[CustomerName", "mbCustomerName", args.CustomerName); } if (!string.IsNullOrEmpty(args.Address)) { this.SetParameters_Contains(mbBuilder, cmd, "BE_Order].[Address", "mbCustomerAddress", args.Address); } if (!string.IsNullOrEmpty(args.LinkMan)) { this.SetParameters_Contains(mbBuilder, cmd, "BE_Order].[LinkMan", "mbLinkMan", args.LinkMan); } if (!string.IsNullOrEmpty(args.OrderNo)) { this.SetParameters_Contains(mbBuilder, cmd, "OrderNo", "mbOrderNo", args.OrderNo); } mbBuilder.AppendFormat(") mb"); string baseSql = string.Format("(SELECT mb.* FROM {0}) baseSql", mbBuilder.ToString()); return(this.SearchBaseSqls(baseSql, cmd, args.OrderBy, args.RowNumberFrom, args.RowNumberTo)); }