/// <summary>
/// 根據商品id、站點id、會員等級、用戶id查詢price_master_id
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public uint QueryPriceMasterId(PriceMaster query)
{
query.Replace4MySQL();
string strSql = string.Format("select price_master_id from price_master where product_id={0} and site_id={1} and user_level={2} and user_id={3} ", query.product_id, query.site_id, query.user_level, query.user_id);
if (_dbAccess.getSinggleObj<PriceMaster>(strSql) != null) //edit by wangwei0216w 2014/08/06 (增加對_dbAccess.getSinggleObj<PriceMaster>(strSql)是否為空的判斷,以解決匯入失敗的情況)
{
uint price_master_id = _dbAccess.getSinggleObj<PriceMaster>(strSql).price_master_id;
return price_master_id;
}
else
{
return 0;
}
}
/// <summary>
/// 查询User_Id 为零的价格信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List<PriceMaster> QueryByUserId(PriceMaster query)
{
query.Replace4MySQL();
try
{
StringBuilder stb = new StringBuilder("select price_master_id,product_id,site_id,user_level,user_id,");
stb.Append("product_name,bonus_percent,default_bonus_percent,same_price,event_start,event_end,");
stb.Append("price_status,price,event_price,cost,event_cost,child_id,apply_id");
stb.Append(" from price_master where 1=1");
if (query.user_id != 0)
{
stb.AppendFormat(" and user_id = {0}", query.user_id);
}
else
{
stb.Append(" and user_id = 0");
}
if (query.product_id != 0)
{
stb.AppendFormat(" and product_id = {0}", query.product_id);
}
if (query.site_id != 0)
{
stb.AppendFormat(" and site_id = {0}", query.site_id);
}
return _dbAccess.getDataTableForObj<PriceMaster>(stb.ToString());
}
catch (Exception ex)
{
throw new Exception("PriceMasterDao.QueryByUserId(PriceMaster query)-->" + ex.Message, ex);
}
}