private void dgProductCostResult_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e)
{
queryFilter = EntityConverter <ProductCostQueryVM, ProductCostQueryFilter> .Convert(queryVM);
this.queryFilter.PagingInfo = new QueryFilter.Common.PagingInfo();
this.queryFilter.PagingInfo.PageIndex = e.PageIndex;
this.queryFilter.PagingInfo.PageSize = e.PageSize;
this.queryFilter.PagingInfo.SortBy = e.SortField;
#region 获取自己能访问到的PM
//queryFilter.UserSysNo = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.LoginUser.UserSysNo;
queryFilter.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode;
serviceFacade.QueryProductCostInList(queryFilter, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
dgProductCostQueryResult.TotalCount = args.Result.TotalCount;
dgProductCostQueryResult.ItemsSource = args.Result.Rows.ToList("IsCheck", false);
});
#endregion
}
public void QueryProductCostInList(ProductCostQueryFilter queryFilter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "InventoryService/Inventory/QueryProductCostInList";
restClient.QueryDynamicData(relativeUrl, queryFilter, callback);
}
public QueryResult QueryProductCostInList(ProductCostQueryFilter queryFilter)
{
QueryResult result = new QueryResult();
int getTotalCount = 0;
result.Data = ObjectFactory <IProductCostQueryDA> .Instance.QueryProductCostInList(queryFilter, out getTotalCount);
result.TotalCount = getTotalCount;
return(result);
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
this.queryFilter = EntityConverter <ProductCostQueryVM, ProductCostQueryFilter> .Convert(this.queryVM);
if (queryFilter == null || !queryFilter.ProductSysNo.HasValue)
{
Window.Alert(string.Format("请输入商品编号"));
return;
}
this.dgProductCostQueryResult.Bind();
}
public virtual DataTable QueryProductCostInList(ProductCostQueryFilter queryFilter, out int totalCount)
{
DataTable dt = new DataTable();
if (queryFilter == null)
{
totalCount = 0;
return(null);
}
var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryProductCostInList");
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = queryFilter.PagingInfo.SortBy,
StartRowIndex = queryFilter.PagingInfo.PageIndex * queryFilter.PagingInfo.PageSize,
MaximumRows = queryFilter.PagingInfo.PageSize
};
using (var sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, pagingInfo, "c.[Priority],c.SysNo"))
{
if (queryFilter.IsAvailableInventory)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.LeftQuantity",
DbType.Int32, "@LeftQuantity", QueryConditionOperatorType.MoreThan, 0);
}
else
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.LeftQuantity",
DbType.Int32, "@LeftQuantity", QueryConditionOperatorType.MoreThanOrEqual, 0);
}
if (queryFilter.ProductSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.ProductSysNo",
DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal,
queryFilter.ProductSysNo.Value);
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
dt = dataCommand.ExecuteDataTable();
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
}
else
{
totalCount = 0;
}
}
return(dt);
}
public override void OnPageLoad(object sender, EventArgs e)
{
base.OnPageLoad(sender, e);
queryFilter = new ProductCostQueryFilter();
queryVM = new ProductCostQueryVM();
serviceFacade = new ProductCostQueryFacade(this);
string getParam = this.Request.Param;
if (!string.IsNullOrEmpty(getParam))
{
queryVM.ProductSysNo = Convert.ToInt32(getParam.Trim());
this.DataContext = queryVM;
btnSearch_Click(null, null);
}
else
{
this.DataContext = queryVM;
}
}
