/// <summary>
/// 查询可用商品入库成本明细
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryCostItems(CostChangeItemsQueryFilter queryFilter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "InventoryService/Inventory/QueryAvaliableCostInList";
restClient.QueryDynamicData(relativeUrl, queryFilter, callback);
}
public QueryResult QueryAvaliableCostInList(CostChangeItemsQueryFilter queryFilter)
{
QueryResult result = new QueryResult();
int getTotalCount = 0;
result.Data = ObjectFactory <IProductCostQueryDA> .Instance.QueryAvaliableCostInList(queryFilter, out getTotalCount);
result.TotalCount = getTotalCount;
return(result);
}
public CostChangeItemsQuery(int vendorSysNo, int pmSysNo)
{
InitializeComponent();
this.DataGrid.DataContext = m_queryReq = new CostChangeItemsQueryFilter()
{
VendorSysNo = vendorSysNo, PMSysNo = pmSysNo
};
//this.ucVendorPicker.SelectedVendorSysNo = vendorSysNo.ToString();
//this.ucPM.SelectedPMSysNo = pmSysNo;
this.Loaded += UCCostChangeItemsQuery_Loaded;
m_selectData = new Dictionary <string, CostItemInfoVM>();
}
/// <summary>
/// 查询商品入库成本明细
/// </summary>
/// <param name="queryFilter"></param>
/// <returns></returns>
public virtual DataTable QueryAvaliableCostInList(CostChangeItemsQueryFilter queryFilter, out int totalCount)
{
DataTable dt = new DataTable();
if (queryFilter == null)
{
totalCount = 0;
return(null);
}
var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryAvaliableCostInList");
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = queryFilter.PageInfo.SortBy,
StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize,
MaximumRows = queryFilter.PageInfo.PageSize
};
using (var sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, pagingInfo, "c.[Priority],c.SysNo"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.BillType",
DbType.Int32, "@BillType", QueryConditionOperatorType.Equal, (int)ECCentral.BizEntity.Inventory.InventoryAdjustContractInfo.CostBillType.PO);
if (queryFilter.ProductSysNo > 0)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.ProductSysNo",
DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, queryFilter.ProductSysNo);
}
else
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "0",
DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, queryFilter.ProductSysNo);
}
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pm.PMSysNo",
DbType.Int32, "@PMSysNo", QueryConditionOperatorType.Equal, queryFilter.PMSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pm.VendorSysNo",
DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, queryFilter.VendorSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.LeftQuantity-c.LockQuantity",
DbType.Int32, "@AvaliableQty", QueryConditionOperatorType.MoreThan, 0);
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
dt = dataCommand.ExecuteDataTable();
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
}
return(dt);
}
