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