public virtual DataTable QueryVendorInfoForBackOrderToday(BackOrderForTodayQueryFilter queryFilter, out int totalCount)
{
if (queryFilter == null)
{
totalCount = 0;
return(null);
}
DataTable dt = new DataTable();
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = queryFilter.PageInfo.SortBy,
StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize,
MaximumRows = queryFilter.PageInfo.PageSize
};
var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryVendorInfo");
StringBuilder sbSQL = new StringBuilder();
if (!string.IsNullOrEmpty(queryFilter.VendorSysNo) && queryFilter.VendorSysNo != "0")
{
sbSQL.Append(" AND SysNo=" + queryFilter.VendorSysNo);
}
if (!string.IsNullOrEmpty(queryFilter.VendorName))
{
sbSQL.Append(" AND VendorName LIKE " + "'" + queryFilter.VendorName + "%" + "'");
}
dataCommand.CommandText = dataCommand.CommandText.Replace("#StrWhere#", sbSQL.ToString());
using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, " SysNo"))
{
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
dt = dataCommand.ExecuteDataTable();
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
}
return(dt);
}
public QueryResult QueryVendorInfoListForBackOrderToday(BackOrderForTodayQueryFilter queryFilter)
{
QueryResult result = new QueryResult();
int getTotalCount = 0;
result.Data = ObjectFactory <IInventoryQueryDA> .Instance.QueryVendorInfoForBackOrderToday(queryFilter, out getTotalCount);
result.TotalCount = getTotalCount;
return(result);
}
public UCBackOrderAlertForToday()
{
InitializeComponent();
queryFilter = new BackOrderForTodayQueryFilter();
this.Loaded += new RoutedEventHandler(UCBackOrderAlertForToday_Loaded);
}
/// <summary>
/// 备货中心 - 当日需备货供应商查询
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryVendorInfoListForBackOrderToday(BackOrderForTodayQueryFilter queryFilter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "InventoryService/Inventory/QueryVendorInfoListForBackOrderToday";
restClient.QueryDynamicData(relativeUrl, queryFilter, callback);
}