public List<VendorBrand> GetProductBrandList(VendorBrand brand, int hideOffGrade)
{
brand.Replace4MySQL();
//StringBuilder strSql = new StringBuilder("select brand_id,brand_name,vendor_id from vendor_brand where 1=1");
///edit by wwei0216w 2015/6/30 要去掉失格供應商下的品牌 所以添加INNER JOIN vendor v ON v.vendor_id = vb.vendor_id的內聯
StringBuilder sb = new StringBuilder();
try
{
sb.Append(@"SELECT vb.brand_id,vb.brand_name,vb.vendor_id
FROM vendor_brand vb
INNER JOIN vendor v ON v.vendor_id = vb.vendor_id");
sb.Append(" WHERE 1=1 ");
if (hideOffGrade == 1)
{
sb.Append(" and v.vendor_status != 3 ");
}
if (brand.Brand_Status != 0)
{
sb.AppendFormat(" AND vb.brand_status = {0}", brand.Brand_Status);
}
if (brand.Vendor_Id != 0)
{
sb.AppendFormat(" AND vb.vendor_id={0}", brand.Vendor_Id);
}
return _dbAccess.getDataTableForObj<VendorBrand>(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("VendorBrandDao-->GetProductBrandList" + ex.Message, ex);
}
}
public VendorBrand GetProductBrand(VendorBrand query)
{
query.Replace4MySQL();
StringBuilder strSql = new StringBuilder("select brand_id,vendor_id,brand_name,brand_sort,brand_status,image_name,image_status,image_link_mode,image_link_url,media_report_link_url,");
strSql.Append("brand_msg,brand_msg_start_time,brand_msg_end_time,brand_createdate,brand_updatedate,brand_ipfrom,cucumber_brand,event,promotion_banner_image,resume_image,");
strSql.Append("promotion_banner_image_link,resume_image_link from vendor_brand where 1=1 ");
if (query.Vendor_Id != 0)
{
strSql.AppendFormat(" and vendor_id={0}", query.Vendor_Id);
}
if (query.Brand_Id != 0)
{
strSql.AppendFormat(" and brand_id={0}", query.Brand_Id);
}
if (query.Brand_Name != "")
{
strSql.AppendFormat(" and brand_name='{0}'", query.Brand_Name);
}
return _dbAccess.getSinggleObj<VendorBrand>(strSql.ToString());
}
/// <summary>
/// 帶條件的品牌搜索
/// </summary>
/// <param name="brand">品牌搜索條件</param>
/// <param name="cid">根據館別搜索品牌</param>
/// <param name="hideOffGrade">失格供應商下的品牌是否顯示</param>
/// <returns></returns>
public List<VendorBrand> GetClassBrandList(VendorBrand brand, uint cid, int hideOffGrade = 0)
{
brand.Replace4MySQL();
StringBuilder strSql = new StringBuilder("select vb.brand_id,vb.brand_name from vendor_brand vb ");
if (cid != 0)
{
strSql.AppendFormat(" inner join vendor_brand_set vs on vb.brand_id=vs.brand_id and vs.class_id='{0}'", cid);
}
if (hideOffGrade == 1)
{
strSql.AppendFormat(" inner join vendor v on v.vendor_id =vb.vendor_id and v.vendor_status <> 3");
}
strSql.Append(" where 1=1 ");
if (brand.Brand_Status != 0)
{
strSql.AppendFormat(" and vb.brand_status = {0}", brand.Brand_Status);
}
return _dbAccess.getDataTableForObj<VendorBrand>(strSql.ToString());
}
