public JsonResult AjaxQueryStoreNavigationList()
{
var user = UserAuthHelper.GetCurrentUser();
StorePageListQueryFilter qFilter = BuildQueryFilterEntity <StorePageListQueryFilter>();
var result = StoreService.QueryStoreNavigationList(qFilter, user.SellerSysNo);
return(AjaxGridJson(result));
}
public static QueryResult <StoreNavigation> QueryStoreNavigationList(StorePageListQueryFilter filter, int SellSysno)
{
var result = StoreDA.QueryStoreNavigationList(filter, SellSysno);
//insert home to first
var home = QueryHomePage(SellSysno);
if (home != null)
{
var navHome = new StoreNavigation();
navHome.LinkUrl = string.Format("/Store/{0}/{1}", SellSysno, home.SysNo.Value);
navHome.Content = "首页";
result.ResultList.Insert(0, navHome);
}
return(result);
}
/// <summary>
/// 查询店铺导航
/// </summary>
/// <param name="queryFilter"></param>
/// <returns></returns>
public static QueryResult <StoreNavigation> QueryStoreNavigationList(StorePageListQueryFilter queryFilter, int SellSysno)
{
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryStoreNavigationList");
using (var sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, queryFilter, string.IsNullOrEmpty(queryFilter.SortFields) ? "s.SysNo ASC" : queryFilter.SortFields))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.[SellerSysNo]", DbType.Int32, "@SellerSysNo", QueryConditionOperatorType.Equal, SellSysno);
command.CommandText = sqlBuilder.BuildQuerySql();
List <StoreNavigation> resultList = command.ExecuteEntityList <StoreNavigation>();
int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(new QueryResult <StoreNavigation>()
{
PageInfo = new PageInfo()
{
PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields
},
ResultList = resultList
});
}
}
public static QueryResult <VendorAgentInfo> QueryStoreAgentInfosByPage(StorePageListQueryFilter queryFilter, int SellSysno)
{
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryStoreAgentInfosByPage");
using (var sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, queryFilter, string.IsNullOrEmpty(queryFilter.SortFields) ? "AgentSysNo ASC" : queryFilter.SortFields))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.[VendorSysNo]", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, SellSysno);
sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "a.Status in (0,2)");
command.CommandText = sqlBuilder.BuildQuerySql();
List <VendorAgentInfo> resultList = command.ExecuteEntityList <VendorAgentInfo>();
int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
var xmlSer = new XmlSerializer(typeof(VendorStagedSaleRuleEntity));
resultList.ForEach(p =>
{
if (!string.IsNullOrEmpty(p.VendorCommissionInfo.StagedSaleRuleItemsXml))
{
//p.VendorCommissionInfo.SaleRuleEntity
using (var stream = new MemoryStream(Encoding.GetEncoding("UTF-16").GetBytes(p.VendorCommissionInfo.StagedSaleRuleItemsXml)))
{
p.VendorCommissionInfo.SaleRuleEntity = (VendorStagedSaleRuleEntity)xmlSer.Deserialize(stream);
p.VendorCommissionInfo.StagedSaleRuleItemsXml = "";
}
}
});
return(new QueryResult <VendorAgentInfo>()
{
PageInfo = new PageInfo()
{
PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields
},
ResultList = resultList
});
}
}
/// <summary>
/// 分页查询商家代理
/// </summary>
/// <param name="filter"></param>
/// <param name="SellSysno"></param>
/// <returns></returns>
public static QueryResult <VendorAgentInfo> QueryStoreAgentInfosByPage(StorePageListQueryFilter filter, int SellSysno)
{
return(StoreDA.QueryStoreAgentInfosByPage(filter, SellSysno));
}
public static QueryResult <StoreNavigation> QueryStoreNavigationList(StorePageListQueryFilter filter, int SellSysno)
{
return(StoreDA.QueryStoreNavigationList(filter, SellSysno));
}
public ActionResult QueryStoreAgentInfosByPage()
{
StorePageListQueryFilter filter = BuildQueryFilterEntity <StorePageListQueryFilter>();
return(AjaxGridJson(StoreService.QueryStoreAgentInfosByPage(filter, CurrUser.SellerSysNo)));
}
