| | |
|---|
| | | public static string BuildDynamicQueryJson(string materialNumber = null, long FHStockId=0, long HOWNERID = 0) |
|---|
| | | { |
|---|
| | | // 创建动态过滤条件列表 |
|---|
| | | var filterList = new List<object>(); |
|---|
| | | var queryParams; |
|---|
| | | var filterList = new List<object>(); |
|---|
| | | if (HOWNERID!= 100038) |
|---|
| | | { |
|---|
| | | // 如果有物料编码，添加物料条件 |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 构建完整的查询参数 |
|---|
| | | queryParams = new |
|---|
| | | var queryParams = new |
|---|
| | | { |
|---|
| | | FormId = "STK_Inventory", |
|---|
| | | FieldKeys = "FMaterialId,FMaterialName,FModel,FStockUnitId,FBaseQty,FStockId,FStockLocId,FLot,FAuxPropId,FProduceDate,FExpiryDate,FStockOrgId", |
|---|
| | | FilterString = filterList |
|---|
| | | }; |
|---|
| | | return JsonConvert.SerializeObject(queryParams); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | |
|---|
| | | |
|---|
| | | //47 不支持上面的动态过滤条件 构建完整的查询参数 |
|---|
| | | queryParams = new |
|---|
| | | var queryParams1 = new |
|---|
| | | { |
|---|
| | | FormId = "STK_Inventory", |
|---|
| | | FieldKeys = "FMaterialId,FMaterialName,FModel,FStockUnitId,FBaseQty,FStockId,FStockLocId,FLot,FAuxPropId,FProduceDate,FExpiryDate,FStockOrgId", |
|---|
| | | FilterString = "" |
|---|
| | | }; |
|---|
| | | return JsonConvert.SerializeObject(queryParams1); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | return JsonConvert.SerializeObject(queryParams); |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | #endregion |
|---|
