/// <summary>
/// 更新一个品牌
/// </summary>
/// <param name="brand"></param>
/// <returns></returns>
public static bool UpdateBrand(BrandModel brand)
{
string sqlCmd = String.Format(UpdateBrandSqlCmdTemplate, brand.BrandName, brand.Status, brand.BrandLogo, brand.OrderNum, brand.C1SysNo, brand.C2SysNo, brand.C3SysNo, brand.IsRecommend, brand.IsPromoted, brand.RecommendOrderNum, brand.PromotionOrderNum, brand.BrandSysNo);
try
{
if (new SqlDBHelper().ExecuteNonQuery(sqlCmd) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 获得品牌信息
/// </summary>
/// <param name="brandId"></param>
/// <returns></returns>
public static BrandModel GetBrandById(string brandId)
{
DataTable data = new SqlDBHelper().ExecuteQuery(String.Format(GetSingleBrandsSqlCmdTemplate, brandId));
BrandModel brand = new BrandModel()
{
BrandName = data.Rows[0]["BrandName"].ToString().Trim(),
BrandSysNo = int.Parse(data.Rows[0]["BrandSysNo"].ToString().Trim()),
BrandLogo = data.Rows[0]["BrandIcon"].ToString().Trim(),
Status = int.Parse(data.Rows[0]["Status"].ToString().Trim()),
OrderNum = int.Parse(data.Rows[0]["OrderNum"].ToString().Trim()),
C1SysNo = int.Parse(data.Rows[0]["C1SysNo"].ToString().Trim()),
C2SysNo = int.Parse(data.Rows[0]["C2SysNo"].ToString().Trim()),
C3SysNo = int.Parse(data.Rows[0]["C3SysNo"].ToString().Trim()),
IsRecommend = int.Parse(data.Rows[0]["IsRecommend"].ToString().Trim()),
IsPromoted = int.Parse(data.Rows[0]["IsPromoted"].ToString().Trim()),
PromotionOrderNum = int.Parse(data.Rows[0]["PromotionOrderNum"].ToString().Trim()),
RecommendOrderNum = int.Parse(data.Rows[0]["RecommendOrderNum"].ToString().Trim()),
};
return(brand);
}
/// <summary>
/// 获得商品的品牌
/// </summary>
/// <returns></returns>
public static BrandModel GetProductBrand(string productSysNo)
{
DataTable data = new SqlDBHelper().ExecuteQuery(String.Format(GetProductBrandSqlCmdTemplate, productSysNo));
if (data.Rows.Count > 0)
{
BrandModel brand = new BrandModel()
{
BrandName = data.Rows[0]["BrandName"].ToString().Trim(),
BrandSysNo = int.Parse(data.Rows[0]["BrandSysNo"].ToString().Trim()),
BrandLogo = data.Rows[0]["BrandIcon"].ToString().Trim(),
};
return brand;
}
else
{
BrandModel brand = new BrandModel()
{
BrandName = String.Empty,
BrandSysNo = 0,
BrandLogo = String.Empty,
};
return brand;
}
}
/// <summary>
/// 更新一个品牌
/// </summary>
/// <param name="brand"></param>
/// <returns></returns>
public static bool UpdateBrand(BrandModel brand)
{
string sqlCmd = String.Format(UpdateBrandSqlCmdTemplate, brand.BrandName, brand.Status, brand.BrandLogo, brand.OrderNum, brand.C1SysNo, brand.C2SysNo, brand.C3SysNo, brand.IsRecommend, brand.IsPromoted, brand.RecommendOrderNum, brand.PromotionOrderNum, brand.BrandSysNo);
try
{
if (new SqlDBHelper().ExecuteNonQuery(sqlCmd) > 0)
{
return true;
}
else
{
return false;
}
}
catch
{
return false;
}
}
/// <summary>
/// 获得品牌信息
/// </summary>
/// <param name="brandId"></param>
/// <returns></returns>
public static BrandModel GetBrandById(string brandId)
{
DataTable data = new SqlDBHelper().ExecuteQuery(String.Format(GetSingleBrandsSqlCmdTemplate, brandId));
BrandModel brand = new BrandModel()
{
BrandName = data.Rows[0]["BrandName"].ToString().Trim(),
BrandSysNo = int.Parse(data.Rows[0]["BrandSysNo"].ToString().Trim()),
BrandLogo = data.Rows[0]["BrandIcon"].ToString().Trim(),
Status = int.Parse(data.Rows[0]["Status"].ToString().Trim()),
OrderNum = int.Parse(data.Rows[0]["OrderNum"].ToString().Trim()),
C1SysNo = int.Parse(data.Rows[0]["C1SysNo"].ToString().Trim()),
C2SysNo = int.Parse(data.Rows[0]["C2SysNo"].ToString().Trim()),
C3SysNo = int.Parse(data.Rows[0]["C3SysNo"].ToString().Trim()),
IsRecommend = int.Parse(data.Rows[0]["IsRecommend"].ToString().Trim()),
IsPromoted = int.Parse(data.Rows[0]["IsPromoted"].ToString().Trim()),
PromotionOrderNum = int.Parse(data.Rows[0]["PromotionOrderNum"].ToString().Trim()),
RecommendOrderNum = int.Parse(data.Rows[0]["RecommendOrderNum"].ToString().Trim()),
};
return brand;
}