/// <summary>
/// 獲取列表
/// </summary>
/// <param name="appmsg"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<AppmessageQuery> GetAppmessageList(AppmessageQuery appmsg, out int totalCount)
{
try
{
return _iappmessageImplDao.GetAppmessageList(appmsg, out totalCount);
}
catch (Exception ex)
{
throw new Exception("AppmessageMgr-->GetAppmessageList-->" + ex.Message, ex);
}
}
/// <summary>
/// 查找列表數據
/// </summary>
/// <param name="appmsg"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<AppmessageQuery> GetAppmessageList(AppmessageQuery appmsg, out int totalCount)
{
StringBuilder sql = new StringBuilder();
StringBuilder sqlcount = new StringBuilder();
StringBuilder sqlwhere = new StringBuilder();
CommonFunction.GetPHPTime();
sql.AppendFormat("SELECT message_id,`type`,title,content,FROM_UNIXTIME(messagedate) as messagedate_time,`group`,linkurl,display_type,FROM_UNIXTIME(msg_start) as msg_start_time,FROM_UNIXTIME(msg_end) as msg_end_time,fit_os,appellation,need_login FROM appmessage where 1=1 ");
sqlcount.AppendFormat("SELECT message_id FROM appmessage where 1=1 ");
if (appmsg.msg_start_first != 0)
{
sqlwhere.AppendFormat(" and msg_start >= {0}", appmsg.msg_start_first);
}
if (appmsg.msg_start_second != 0)
{
sqlwhere.AppendFormat(" and msg_start <= {0}", appmsg.msg_start_second);
}
if (appmsg.msg_end_first != 0)
{
sqlwhere.AppendFormat(" and msg_end >= {0} ", appmsg.msg_end_first);
}
if (appmsg.msg_end_second != 0)
{
sqlwhere.AppendFormat(" and msg_end <= {0} ", appmsg.msg_end_second);
}
totalCount = 0;
try
{
sqlcount.AppendFormat(sqlwhere.ToString());
sql.AppendFormat(sqlwhere.ToString());
if (appmsg.IsPage)
{
System.Data.DataTable _dt = _access.getDataTable(sqlcount.ToString());
if (_dt != null && _dt.Rows.Count > 0)
{
totalCount = _dt.Rows.Count;
}
sql.AppendFormat(" limit {0},{1}", appmsg.Start, appmsg.Limit);
}
return _access.getDataTableForObj<AppmessageQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("AppmessageDao.GetAppmessageList-->" + ex.Message + sql.ToString(), ex);
}
}
/// <summary>
/// 獲取表單數據
/// </summary>
/// <returns></returns>
public HttpResponseBase GetAppMessageList()
{
List<AppmessageQuery> stores = new List<AppmessageQuery>();
string json = string.Empty;
try
{
AppmessageQuery query = new AppmessageQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
if (!string.IsNullOrEmpty(Request.Form["msg_start_first"]))//判斷分類一是否為空
{
//query.msg_start_first = uint.Parse(CommonFunction.GetPHPTime(Request.Form["msg_start_first"]).ToString());
//modify by jiaohe0625j
query.msg_start_first = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["msg_start_first"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Form["msg_start_second"]))//判斷分類一是否為空
{
//query.msg_start_second = uint.Parse(CommonFunction.GetPHPTime(Request.Form["msg_start_second"]).ToString()) + 86399;
//時間戳，86399表示時間是23時59分59秒，用於比較時間的大小進行查詢
//modify by jiaohe0625j
query.msg_start_second = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["msg_start_second"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Form["msg_end_first"]))//判斷分類一是否為空
{
//query.msg_end_first = uint.Parse(CommonFunction.GetPHPTime(Request.Form["msg_end_first"]).ToString());
//modify by jiaohe0625j
query.msg_end_first = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["msg_end_first"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Form["msg_end_second"]))//判斷分類一是否為空
{
//query.msg_end_second = uint.Parse(CommonFunction.GetPHPTime(Request.Form["msg_end_second"]).ToString()) + 86399;
//modify by jiaohe0625j
query.msg_end_second = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["msg_end_second"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
_iappmessageMgr = new AppmessageMgr(mySqlConnectionString);
int totalCount = 0;
stores = _iappmessageMgr.GetAppmessageList(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
//listUser是准备转换的对象
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Formatting.Indented, timeConverter) + "}";
//返回json數據
}
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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}