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()); }
/// <summary> /// 查询配送方式 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryShipTypeList(ShipTypeQueryFilter filter, out int totalCount) { MapSortField(filter); PagingInfoEntity pagingEntity = new PagingInfoEntity(); if (filter.PageInfo == null) { pagingEntity = null; } else { pagingEntity.SortField = filter.PageInfo.SortBy; pagingEntity.MaximumRows = filter.PageInfo.PageSize; pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize; } var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ShipType_QueryShipType"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "ST.SysNo DESC")) { //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ST.ShipTypeID", DbType.String, "@ShipTypeID", QueryConditionOperatorType.Equal, filter.ShipTypeID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ST.ShipTypeName", DbType.String, "@ShipTypeName", QueryConditionOperatorType.Like, filter.ShipTypeName); //if(filter.IsOnlineShow.HasValue&&filter.IsOnlineShow.Value==ECCentral.BizEntity.Common.HYNStatus.Hide) // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ST.IsOnlineShow", DbType.Int32, "@IsOnlineShow", QueryConditionOperatorType.NotEqual, ECCentral.BizEntity.Common.HYNStatus.Hide); //else if (filter.IsOnlineShow != null) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ST.IsOnlineShow", DbType.Int32, "@IsOnlineShow", QueryConditionOperatorType.Equal, filter.IsOnlineShow.GetHashCode()); } if (filter.IsWithPackFee != null) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ST.IsWithPackFee", DbType.Int32, "@IsWithPackFee", QueryConditionOperatorType.Equal, filter.IsWithPackFee.GetHashCode()); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ST.OnlyForStockSysNo", DbType.Int32, "@StockSysNo", QueryConditionOperatorType.Equal, filter.StockSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ST.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList enumList = new EnumColumnList(); enumList.Add("IsOnlineShow", typeof(ECCentral.BizEntity.Common.HYNStatus)); enumList.Add("IsWithPackFee", typeof(ECCentral.BizEntity.MKT.NYNStatus)); enumList.Add("DeliveryPromise", typeof(ECCentral.BizEntity.Common.DeliveryStatusFor24H)); enumList.Add("PackStyle", typeof(ECCentral.BizEntity.Common.ShippingPackStyle)); enumList.Add("ShipTypeEnum", typeof(ECCentral.BizEntity.Common.ShippingTypeEnum)); enumList.Add("DeliveryType", typeof(ECCentral.BizEntity.Common.ShipDeliveryType)); enumList.Add("StoreType", typeof(ECCentral.BizEntity.IM.StoreType)); //CodeNamePairColumnList pairList = new CodeNamePairColumnList(); //pairList.Add("PackStyle", "Common", "ShippingPackStyle"); //pairList.Add("ShipTypeEnum", "Common", "ShipTypeEnum"); //pairList.Add("DeliveryType", "Common", "DeliveryType"); var dt = cmd.ExecuteDataTable(enumList);//<ECCentral.BizEntity.MKT.ADStatus>("Status"); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt);//.Tables[0]; } }
public virtual QueryResult QueryShipTypeList(ShipTypeQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <IShipTypeQueryDA> .Instance.QueryShipTypeList(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
public static List <ShipTypeInfoQueryResult> GetShipTypeList(int merchantSysNo) { ShipTypeQueryFilter queryFilter = new ShipTypeQueryFilter() { PageIndex = 0, PageSize = int.MaxValue, }; queryFilter.MerchantSysNo = merchantSysNo; return(ShipTypeService.QueryShipType(queryFilter).ResultList); }
private static void MapSortField(ShipTypeQueryFilter filter) { if (filter.PageInfo != null && !string.IsNullOrEmpty(filter.PageInfo.SortBy)) { var index = 0; index = filter.PageInfo.SortBy.Contains("asc") ? 4 : 5; var sort = filter.PageInfo.SortBy.Substring(0, filter.PageInfo.SortBy.Length - index); var sortFiled = filter.PageInfo.SortBy; switch (sort) { case "SysNo": filter.PageInfo.SortBy = sortFiled.Replace("SysNo", "ST.SysNo"); break; } } }
/// <summary> /// 查询商家的配送方式 /// </summary> /// <param name="queryFilter"></param> /// <returns></returns> public static QueryResult <ShipTypeInfoQueryResult> QueryShipType(ShipTypeQueryFilter queryFilter) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryShipType"); using (var sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, queryFilter, string.IsNullOrEmpty(queryFilter.SortFields) ? "st.SysNo ASC" : queryFilter.SortFields)) { if (queryFilter.MerchantSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "st.MerchantSysNo", DbType.Int32, "@MerchantSysNo", QueryConditionOperatorType.Equal, queryFilter.MerchantSysNo); } if (!string.IsNullOrEmpty(queryFilter.ShipTypeID)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "st.ShipTypeID", DbType.String, "@ShipTypeID", QueryConditionOperatorType.Like, queryFilter.ShipTypeID); } if (queryFilter.SysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "st.SysNo", DbType.String, "@SysNo", QueryConditionOperatorType.Equal, queryFilter.SysNo.Value); } if (queryFilter.IsOnlineShow.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "st.IsOnlineShow", DbType.String, "@IsOnlineShow", QueryConditionOperatorType.Equal, queryFilter.IsOnlineShow.Value); } if (queryFilter.IsWithPackFee.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "st.IsWithPackFee", DbType.String, "@IsWithPackFee", QueryConditionOperatorType.Equal, queryFilter.IsWithPackFee.Value); } if (!string.IsNullOrEmpty(queryFilter.ShipTypeName)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "st.ShipTypeName", DbType.String, "@ShipTypeName", QueryConditionOperatorType.Like, queryFilter.ShipTypeName); } command.CommandText = sqlBuilder.BuildQuerySql(); List <ShipTypeInfoQueryResult> resultList = command.ExecuteEntityList <ShipTypeInfoQueryResult>(); int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(new QueryResult <ShipTypeInfoQueryResult>() { PageInfo = new PageInfo() { PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields }, ResultList = resultList }); } }
/// <summary> /// 查询商家的配送方式 /// </summary> /// <param name="queryFilter"></param> /// <returns></returns> public static QueryResult <ShipTypeInfoQueryResult> QueryShipType(ShipTypeQueryFilter queryFilter) { return(ShipTypeDA.QueryShipType(queryFilter)); }