/// <summary>
/// 獲取下拉框參數數據
/// </summary>
/// <returns></returns>
public HttpResponseBase GetAppMessagePara()
{
string json = string.Empty;
try
{
if (!string.IsNullOrEmpty(Request.QueryString["paraType"]))
{
_iappmessageMgr = new AppmessageMgr(mySqlConnectionString);
string para = Request.Params["paraType"].ToString();
json = _iappmessageMgr.GetParaList(para);
}
}
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;
}
/// <summary>
/// 新增Message數據
/// </summary>
/// <returns></returns>
public HttpResponseBase AppMessageInsert()
{
Appmessage query = new Appmessage();
string json = string.Empty;
try
{
_iappmessageMgr = new AppmessageMgr(mySqlConnectionString);
query.title = Request.Form["title"] ?? "";
query.content = Request.Form["content"] ?? "";
query.linkurl = Request.Form["linkurl"] ?? "";
if (!string.IsNullOrEmpty(Request.Form["msg_start"]))
{
query.msg_start = uint.Parse(CommonFunction.GetPHPTime(Request.Form["msg_start"]).ToString());
}
if (!string.IsNullOrEmpty(Request.Form["msg_end"]))
{
query.msg_end = uint.Parse(CommonFunction.GetPHPTime(Request.Form["msg_end"]).ToString());
}
query.appellation = Request.Form["appellation"] ?? "";
query.fit_os = Request.Form["fit_os"] ?? "";
if (!string.IsNullOrEmpty(Request.Form["display_type"]))
{
query.display_type = int.Parse(Request.Form["display_type"]);
}
else
{
query.display_type = 1;
}
query.type = 1;
query.messagedate = uint.Parse(CommonFunction.GetPHPTime(DateTime.Now.ToString()).ToString());
int result = _iappmessageMgr.AppMessageInsert(query);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
//listUser是准备转换的对象
json = "{success:true,result:" + result + "}";
}
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,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <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;
}
