public HttpResponseBase GetPromotionBannerList()
{
string json = string.Empty;
int totalCount = 0;
PromotionBannerQuery query = new PromotionBannerQuery();
List<PromotionBannerQuery> store = new List<PromotionBannerQuery>();
try
{
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量
if (!string.IsNullOrEmpty(Request.Params["dateCon"]))
{
query.dateCon = Convert.ToInt32(Request.Params["dateCon"]);
}
if (!string.IsNullOrEmpty(Request.Params["date_start"]))
{
query.date_start =Convert.ToDateTime( Request.Params["date_start"]);
query.date_start = Convert.ToDateTime(query.date_start.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["date_end"]))
{
query.date_end =Convert.ToDateTime( Request.Params["date_end"]);
query.date_end = Convert.ToDateTime(query.date_end.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["activeStatus"]))
{
query.pb_status = Convert.ToInt32(Request.Params["activeStatus"]);
}
if (!string.IsNullOrEmpty(Request.Params["showStatus"]))
{
query.showStatus = Convert.ToInt32(Request.Params["showStatus"]);
}
if (!string.IsNullOrEmpty(Request.Params["brand_name"]))
{
query.brand_name = Request.Params["brand_name"].Trim(); ;
}
if (!string.IsNullOrEmpty(Request.Params["brand_id"]))
{
query.singleBrand_id = Convert.ToUInt32(Request.Params["brand_id"]);
}
_promotionBannerMgr = new PromotionBannerMgr(mySqlConnectionString);
store = _promotionBannerMgr.GetPromotionBannerList(query, out totalCount);
foreach (var item in store)
{
if (!string.IsNullOrEmpty(item.pb_image))
{
string folder5 = item.pb_image.Substring(0, 2) + "/"; //圖片名前兩碼
string folder6 = item.pb_image.Substring(2, 2) + "/"; //圖片名第三四碼
item.pb_image = imgServerPath + brandPath + folder5 + folder6 + item.pb_image;
}
else
{
item.pb_image = defaultImg;
}
if (!string.IsNullOrEmpty(item.pb_image_link))
{
item.pb_image_link = item.pb_image_link.Replace("''", "'");
}
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json.ToString());
this.Response.End();
return this.Response;
}
