//依照搜尋條件取得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));
}
