/// <summary> /// 查询Stock List /// </summary> /// <param name="queryFilter"></param> /// <param name="callback"></param> public void QueryStockList(StockQueryFilter queryFilter, EventHandler <RestClientEventArgs <List <StockInfo> > > callback) { queryFilter.CompanyCode = "8601"; string relativeUrl = "/InventoryService/Stock/QueryStockList"; restClient.Query <List <StockInfo> >(relativeUrl, queryFilter, callback); }
public ActionResult Maintain() { var stockQueryFilter = new StockQueryFilter(); //获得自贸仓库 ContainKJT设置为true stockQueryFilter.ContainKJT = false;//UserAuthHelper.GetCurrentUser().VendorStockType == Entity.Store.Vendor.VendorStockType.NEG; stockQueryFilter.MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo; stockQueryFilter.PageIndex = 0; stockQueryFilter.PageSize = 100000; var StockList = StockService.QueryStock(stockQueryFilter); ViewBag.StockList = StockList.ResultList; var shipTypeQueryFilter = new ShipTypeQueryFilter(); shipTypeQueryFilter.MerchantSysNo = 1; shipTypeQueryFilter.PageIndex = 0; shipTypeQueryFilter.PageSize = 100000; var ShipTypeList = ShipTypeService.QueryShipType(shipTypeQueryFilter); ViewBag.ShipTypeList = ShipTypeList.ResultList; if (Request["sysno"] == null || int.Parse(Request["sysno"]) == 0) { ViewBag.StockShipTypeInfo = new StockShipTypeInfo(); } else { ViewBag.StockShipTypeInfo = StockService.GetStockShipTypeInfo(int.Parse(Request["sysno"])); } return(View()); }
// // GET: /StockShipType/ public ActionResult List() { var stockQueryFilter = new StockQueryFilter(); //获得自贸仓库 ContainKJT设置为true stockQueryFilter.ContainKJT = false;//UserAuthHelper.GetCurrentUser().VendorStockType == Entity.Store.Vendor.VendorStockType.NEG; stockQueryFilter.MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo; stockQueryFilter.PageIndex = 0; stockQueryFilter.PageSize = 100000; var StockList = StockService.QueryStock(stockQueryFilter); ViewBag.StockList = StockList.ResultList; var shipTypeQueryFilter = new ShipTypeQueryFilter(); shipTypeQueryFilter.MerchantSysNo = 1; shipTypeQueryFilter.PageIndex = 0; shipTypeQueryFilter.PageSize = 100000; var ShipTypeList = ShipTypeService.QueryShipType(shipTypeQueryFilter); ViewBag.ShipTypeList = ShipTypeList.ResultList; return(View()); }
public QueryResult QueryStock(StockQueryFilter request) { int totalCount; var dataTable = ObjectFactory <IStockQueryDA> .Instance.QueryStock(request, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 获取渠道仓库列表 /// </summary> /// <param name="CompanyCode"></param> /// <returns>渠道仓库列表</returns> public virtual List <StockInfo> QueryStockList(StockQueryFilter request) { DataCommand cmd = DataCommandManager.GetDataCommand("Inventory_QueryStockList"); cmd.SetParameterValue("@WebChannelSysNo", request.WebChannelID); cmd.SetParameterValue("@WarehouseSysNo", request.WarehouseSysNo); cmd.SetParameterValue("@CompanyCode", request.CompanyCode); using (IDataReader reader = cmd.ExecuteDataReader()) { return(DataMapper.GetEntityList <StockInfo, List <StockInfo> >(reader)); } }
public void LoadStockByID(string StockID, EventHandler <RestClientEventArgs <dynamic> > callback) { StockQueryFilter filter = new StockQueryFilter(); filter.StockID = StockID; filter.CompanyCode = "8601";//CPApplication.Current.CompanyCode; filter.PagingInfo = new PagingInfo { PageIndex = 0, PageSize = int.MaxValue }; string relativeUrl = "/InventoryService/Stock/QueryStock"; restClient.QueryDynamicData(relativeUrl, filter, callback); }
/// <summary> /// 获取某一个商家的有效仓库信息列表 /// </summary> /// <param name="merchantSysNo"></param> /// <param name="vendorStockType"></param> /// <returns></returns> public static List <StockInfoQueryRestult> GetStockList(int merchantSysNo, VendorStockType vendorStockType) { StockQueryFilter queryFilter = new StockQueryFilter() { PageIndex = 0, PageSize = int.MaxValue, Status = StockStatus.Actived, SortFields = "s.SysNo DESC" }; queryFilter.MerchantSysNo = merchantSysNo; //所有商家都可以查看泰隆优选仓库 queryFilter.ContainKJT = true; return(StockService.QueryStock(queryFilter).ResultList); }
/// <summary> /// 查询商家的仓库列表 /// </summary> /// <param name="queryFilter"></param> /// <returns></returns> public static QueryResult <StockInfoQueryRestult> QueryStock(StockQueryFilter queryFilter) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryStock"); using (var sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, queryFilter, string.IsNullOrEmpty(queryFilter.SortFields) ? "s.SysNo ASC" : queryFilter.SortFields)) { if (!string.IsNullOrEmpty(queryFilter.StockID)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.StockID", DbType.String, "@StockID", QueryConditionOperatorType.Like, queryFilter.StockID); } if (queryFilter.SysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.SysNo", DbType.String, "@SysNo", QueryConditionOperatorType.Equal, queryFilter.SysNo.Value); } if (queryFilter.Status.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, queryFilter.Status.Value); } if (queryFilter.StockType.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.StockType", DbType.String, "@StockType", QueryConditionOperatorType.Equal, queryFilter.StockType.Value); } if (queryFilter.ContainKJT) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, string.Format("(s.MerchantSysNo = 1 OR s.MerchantSysNo = {0})", queryFilter.MerchantSysNo)); } else { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.MerchantSysNo", DbType.Int32, "@MerchantSysNo", QueryConditionOperatorType.Equal, queryFilter.MerchantSysNo); } if (!string.IsNullOrEmpty(queryFilter.StockName)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.StockName", DbType.String, "@StockName", QueryConditionOperatorType.Like, queryFilter.StockName); } command.CommandText = sqlBuilder.BuildQuerySql(); List <StockInfoQueryRestult> resultList = command.ExecuteEntityList <StockInfoQueryRestult>(); int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(new QueryResult <StockInfoQueryRestult>() { PageInfo = new PageInfo() { PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields }, ResultList = resultList }); } }
public void QueryStock(StockQueryVM model, EventHandler <RestClientEventArgs <dynamic> > callback) { StockQueryFilter filter = model.ConvertVM <StockQueryVM, StockQueryFilter>(); string relativeUrl = "/InventoryService/Stock/QueryStock"; restClient.QueryDynamicData(relativeUrl, filter, (obj, args) => { if (!args.FaultsHandle()) { foreach (var item in args.Result.Rows) { item.IsChecked = false; } callback(obj, args); } }); }
/// <summary> /// 查询商家的仓库列表 /// </summary> /// <param name="queryFilter"></param> /// <returns></returns> public static QueryResult <StockInfoQueryRestult> QueryStock(StockQueryFilter queryFilter) { return(StockDA.QueryStock(queryFilter)); }
/// <summary> /// 查询渠道仓库 /// </summary> /// <returns></returns> public virtual DataTable QueryStock(StockQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = SortFieldMapping(filter.PagingInfo.SortBy); pagingEntity.MaximumRows = filter.PagingInfo.PageSize; pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize; CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("Inventory_QueryStock"); using (var sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "a.SysNo DESC")) { bool isSysNo = false; //编号格式验证 if (filter.StockSysNo != null && Regex.IsMatch(filter.StockSysNo, @"^[,\. ]*\d+[\d,\. ]*$")) { filter.StockSysNo = String.Join(",", filter.StockSysNo.Split(new char[] { '.', ',', ' ' }, StringSplitOptions.RemoveEmptyEntries)); isSysNo = true; } else { filter.StockSysNo = null; } if (filter.StockID != null && Regex.IsMatch(filter.StockID, @"^[, ]*\w+[\w-#, ]*$")) { filter.StockID = "'" + String.Join("','", filter.StockID.Split(new char[] { ',', ' ' }, StringSplitOptions.RemoveEmptyEntries)) + "'"; isSysNo = true; } else { filter.StockID = null; } if (isSysNo) { sb.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); sb.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, "a.SysNo", QueryConditionOperatorType.In, filter.StockSysNo); sb.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, "a.StockID", QueryConditionOperatorType.In, filter.StockID); sb.ConditionConstructor.EndGroupCondition(); } sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.StockName", DbType.String, "@StockName", QueryConditionOperatorType.LeftLike, filter.StockName); sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Status", DbType.AnsiStringFixedLength, "@StockStatus", QueryConditionOperatorType.Equal, filter.StockStatus); sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.WarehouseSysNo", DbType.Int32, "@WarehouseSysNo", QueryConditionOperatorType.Equal, filter.WarehouseSysNo); sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.WebChannelSysNo", DbType.Int32, "@WebChannelSysNo", QueryConditionOperatorType.Equal, filter.WebChannelSysNo); sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); EnumColumnList enumColumnList = new EnumColumnList(); enumColumnList.Add("StockStatus", typeof(ValidStatus)); cmd.CommandText = sb.BuildQuerySql(); var resultData = cmd.ExecuteDataTable(enumColumnList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(resultData); } }
public List <StockInfo> QueryStockList(StockQueryFilter request) { return(ObjectFactory <IStockDA> .Instance.QueryStockList(request)); }