/// <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); } }