//依照搜尋條件取得App資料 public List <Model.StringResult> GetAppSearch(AppMarketingAnalysis.Model.AppMarketingAnalysisData amad, string target) { return(AppMarketingAnalysisDao.GetAppSearch(amad, target)); }
/// <summary> /// 依照搜尋條件取得App資料 /// </summary> /// <param name="amad"></param> /// <returns></returns> public List <AppMarketingAnalysis.Model.AppMarketingAnalysisData> GetAppBySearch(AppMarketingAnalysis.Model.AppMarketingAnalysisData amad) { DataTable dt = new DataTable(); string sql = @"SELECT * FROM AppMarketingAnalysisData as AMAD WHERE (UPPER(AMAD.BOOK_NAME) LIKE UPPER('%'+@APP_NAME+'%') OR @APP_NAME = '') AND ORDER BY AMAD.APP_NAME DESC"; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@APP_NAME", amad.APP_NAME == null ? string.Empty : amad.APP_NAME)); SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd); sqlAdapter.Fill(dt); conn.Close(); } return(this.MapAppDataToList(dt)); }
//依照搜尋條件取得App資料 public List <AppMarketingAnalysis.Model.AppMarketingAnalysisData> GetAppBySearch(AppMarketingAnalysis.Model.AppMarketingAnalysisData amad) { return(AppMarketingAnalysisDao.GetAppBySearch(amad)); }