/// <summary>
/// 插入數據
/// </summary>
/// <param name="appmsg"></param>
/// <returns></returns>
public int AppMessageInsert(Appmessage appmsg)
{
try
{
return _iappmessageImplDao.AppMessageInsert(appmsg);
}
catch (Exception ex)
{
throw new Exception("AppmessageMgr-->AppcategoryDelete-->" + ex.Message, ex);
}
}
/// <summary>
/// 插入新數據
/// </summary>
/// <param name="appmsg"></param>
/// <returns></returns>
public int AppMessageInsert(Appmessage appmsg)
{
StringBuilder sql = new StringBuilder();
try
{
sql.Append(@"insert into appmessage (`type`,title,content,messagedate,linkurl,display_type,msg_end,msg_start,fit_os,appellation)");
sql.AppendFormat(@" values('{0}','{1}','{2}','{3}','{4}','{5}'", appmsg.type, appmsg.title, appmsg.content, appmsg.messagedate, appmsg.linkurl, appmsg.display_type);
sql.AppendFormat(@",'{0}','{1}','{2}','{3}');", appmsg.msg_end, appmsg.msg_start, appmsg.fit_os, appmsg.appellation);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("AppmessageDao.AppMessageInsert-->" + ex.Message + sql.ToString(), ex);
}
}
/// <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;
}
