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));
}
