/// <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; }