/// <summary>
/// 获取广告类目配置列表
/// </summary>
/// <returns></returns>
public static IEnumerable <AdvertCategoryModel> SelectAdvertCategoryList(string categoryid)
{
DataTable resulTable = DALChangeCategory.SelectAdvertCategoryList(categoryid);
if (resulTable != null && resulTable.Rows.Count > 0)
{
return(resulTable.Rows.Cast <DataRow>().Select(dr => new AdvertCategoryModel(dr)));
}
else
{
return(new AdvertCategoryModel[0]);
}
}
/// <summary>
/// 根据文章ID获取子类目文章具体信息列表
/// </summary>
/// <returns></returns>
public static IEnumerable <GaiZhuangRelateArticleModel> SelectArticleCategoryByArticleId(int articleId)
{
DataTable resulTable = DALChangeCategory.SelectArticleCategoryByArticleId(articleId);
if (resulTable != null && resulTable.Rows.Count > 0)
{
return(resulTable.Rows.Cast <DataRow>().Select(dr => new GaiZhuangRelateArticleModel(dr)));
}
else
{
return(new GaiZhuangRelateArticleModel[0]);
}
}
/// <summary>
/// 获取类目配置列表
/// </summary>
/// <returns></returns>
public static IEnumerable <GaiZhuangCategoryModel> SelectChangeCategoryList()
{
DataTable resulTable = DALChangeCategory.SelectChangeCategoryList();
if (resulTable != null && resulTable.Rows.Count > 0)
{
return(resulTable.Rows.Cast <DataRow>().Select(dr => new GaiZhuangCategoryModel(dr)));
}
else
{
return(new GaiZhuangCategoryModel[0]);
}
}
/// <summary>
/// 获取文章匹配车型列表
/// </summary>
/// <returns></returns>
public static IEnumerable <ArticleAdaptVehicleModel> SelectArticleVehicleCategoryList(int articleId)
{
DataTable resulTable = DALChangeCategory.SelectArticleVehicleCategoryList(articleId);
if (resulTable != null && resulTable.Rows.Count > 0)
{
return(resulTable.Rows.Cast <DataRow>().Select(dr => new ArticleAdaptVehicleModel(dr)));
}
else
{
return(new ArticleAdaptVehicleModel[0]);
}
}
/// <summary>
/// 根据子类目ID获取已关联的商品
/// </summary>
/// <returns></returns>
public static List <GaiZhuangRelateProductModel> GetSelectedRelateProductListByCategoryID(int categoryid)
{
try
{
return(DALChangeCategory.GetSelectedRelateProductListByCategoryID(categoryid));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
throw ex;
}
}
public static List <CategoryModel> GetProductCategoryList()
{
try
{
return(DALChangeCategory.GetProductCategoryList());
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据选中的商品类目获取已选商品
/// </summary>
/// <returns></returns>
public static List <SelectedRelateProductModel> GetSelectedRelateProductListByProductItems(string productItems, int pageSize, int pageIndex, out int recordCount)
{
try
{
return(DALChangeCategory.GetSelectedRelateProductListByProductItems(productItems, pageSize, pageIndex, out recordCount));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据选中的商品类目获取关联商品
/// </summary>
/// <returns></returns>
public static List <RelateProductModel> GetRelateProductListByProductItemsNoPage(string productItems)
{
try
{
return(DALChangeCategory.GetRelateProductListByProductItemsNoPage(productItems));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据商品PID获取关联商品
/// </summary>
/// <returns></returns>
public static List <RelateProductModel> GetRelateProductListByProductPID(string pid, int pageSize, int pageIndex, out int recordCount)
{
try
{
return(DALChangeCategory.GetRelateProductListByProductPID(pid, pageSize, pageIndex, out recordCount));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据选中的类目获取已选商品
/// </summary>
/// <returns></returns>
public static List <SelectedRelateProductModel> GetSelectedRelateProductListByCategoryId(int categoryId, string[] brands)
{
try
{
var list = DALChangeCategory.GetSelectedRelateProductListByCategoryId(categoryId, brands);
var dic = list.GroupBy(r => r.PKID).ToDictionary(r => r.Key, r => r.ToList());
var list2 = new List <SelectedRelateProductModel>();
foreach (var value in dic.Values)
{
var model = new SelectedRelateProductModel()
{
PKID = value.FirstOrDefault().PKID,
CategoryId = value.FirstOrDefault().CategoryId,
PID = value.FirstOrDefault().PID,
ProductName = value.FirstOrDefault().ProductName,
ProductType = value.FirstOrDefault().ProductType,
OnSale = value.FirstOrDefault().OnSale,
CityType = value.FirstOrDefault().CityType,
Brand = value.FirstOrDefault().Brand,
Sort = value.FirstOrDefault().Sort,
RegionIds = new List <int>()
};
foreach (var item in value)
{
if (item.RegionId != null)
{
model.RegionIds.Add(item.RegionId.GetValueOrDefault());
}
}
if (model.RegionIds.Any())
{
model.StrCityIDs = string.Join("|", model.RegionIds);
model.StrCityNames = ShippingManager.SelectCityNameByCityIDs(model.RegionIds);
}
list2.Add(model);
}
return(list2);
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新城市
/// </summary>
/// <returns></returns>
public static int UpdateRegion(string fkid, List <int> regionids, int type)
{
try
{
using (var dbhelper = new SqlDbHelper(ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString))
{
var delresult = DALChangeCategory.DelRegionid(dbhelper, fkid);
foreach (var regionId in regionids)
{
foreach (var item in fkid.Split(','))
{
var insertResult = DALChangeCategory.InsertCityId(dbhelper, item, regionId, type);
}
}
}
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加类目
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertChangeCategoryModel(GaiZhuangCategoryModel model)
{
var result = DALChangeCategory.InsertChangeCategoryModel(model);
return(result);
}
/// <summary>
/// 编辑关联商品排序字段
/// </summary>
/// <param name="pkid"></param>
/// <param name="sort"></param>
/// <returns></returns>
public static bool UpdateRelateProduct(int pkid, string sort)
{
return(DALChangeCategory.UpdateRelateProduct(pkid, sort));
}
public static GaiZhuangCategoryModel GetChangeCategoryModelByPKID(int pkid)
{
var dr = DALChangeCategory.GetChangeCategoryModelByPKID(pkid);
return(new GaiZhuangCategoryModel(dr));
}
public static bool UpdateChangeCategoryModel(GaiZhuangCategoryModel model)
{
return(DALChangeCategory.UpdateChangeCategoryModel(model));
}
/// <summary>
/// 添加文章返回主键
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int InsertArticleCategory(GaiZhuangRelateArticleModel model)
{
var result = DALChangeCategory.InsertArticleCategory(model);
return(result);
}
/// <summary>
/// 根据PKID删除已关联商品
/// </summary>
/// <param name="pkid"></param>
/// <returns></returns>
public static bool DeleteRelateProductByPkids(string pkids)
{
return(DALChangeCategory.DeleteRelateProductByPkids(pkids));
}
/// <summary>
/// 根据PKID获取广告类目配置
/// </summary>
/// <returns></returns>
public static AdvertCategoryModel GetAdvertCategoryModelByPKID(int pkid)
{
var dr = DALChangeCategory.GetAdvertCategoryModelByPKID(pkid);
return(new AdvertCategoryModel(dr));
}
/// <summary>
/// 批量添加子类目关联商品
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool BulkSaveRelateProduct(DataTable dt)
{
var result = DALChangeCategory.BulkSaveRelateProduct(dt);
return(result);
}
public static bool UpdateArticleVehicleCategoryModel(GaiZhuangRelateArticleModel model)
{
return(DALChangeCategory.UpdateArticleCategoryModel(model));
}
/// <summary>
/// 根据PKID获取文章
/// </summary>
/// <returns></returns>
public static GaiZhuangRelateArticleModel GetRelateArticleByPKID(int pkid)
{
var dr = DALChangeCategory.GetRelateArticleByPKID(pkid);
return(new GaiZhuangRelateArticleModel(dr));
}
/// <summary>
/// 根据PKID查询单个关联商品ID
/// </summary>
/// <param name="pkid"></param>
/// <returns></returns>
public static SelectedRelateProductModel EditRelateProduct(int pkid)
{
var dr = DALChangeCategory.EditRelateProduct(pkid);
return(new SelectedRelateProductModel(dr));
}
public static GetPCodeModel GetPromotionModelByRuleID(string getGuid)
{
var dr = DALChangeCategory.GetPromotionModelByRuleID(getGuid);
return(new GetPCodeModel(dr));
}
/// <summary>
/// 根据PKID删除文章
/// </summary>
/// <param name="pkid"></param>
/// <returns></returns>
public static bool DeleteArticleVehicleCategoryModel(List <ArticleAdaptVehicleModel> list)
{
return(DALChangeCategory.DeleteArticleVehicleCategoryModel(list));
}
/// <summary>
/// 根据PKID删除类目
/// </summary>
/// <param name="pkid"></param>
/// <returns></returns>
public static bool DeleteChangeCategoryModelByPkid(int pkid)
{
return(DALChangeCategory.DeleteChangeCategoryModelByPkid(pkid));
}
public static bool UpdateAdvertCategoryModel(AdvertCategoryModel model)
{
return(DALChangeCategory.UpdateAdvertCategoryModel(model));
}
/// <summary>
/// 根据PKID删除已关联商品
/// </summary>
/// <param name="pkid"></param>
/// <returns></returns>
public static bool DeleteRelateProductByPkid(int pkid)
{
return(DALChangeCategory.DeleteRelateProductByPkid(pkid));
}
/// <summary>
/// 批量添加文章匹配车型
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool BulkSaveAriticleVehicle(DataTable dt)
{
var result = DALChangeCategory.BulkSaveAriticleVehicle(dt);
return(result);
}
