/// <summary> /// 消息主表添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddMsgInfo(MsgInfoModel model) { StringBuilder sql = new StringBuilder(); sql.AppendFormat(@"INSERT INTO TMsgInfo (TMIOpenId,TMIMsgType,TMIMsgRelative,TMISource,TMIContent,TMIAddTime) values ('{0}','{1}','{2}','{3}','{4}','{5}')" , model.TMIOpenId, model.TMIMsgType, model.TMIMsgRelative, model.TMISource, model.TMIContent, model.TMIAddTime); return(DBHelper.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// 获取消息主表的OpenId和消息的发送接收之间的唯一标识 /// </summary> /// <param name="id"></param> /// <returns></returns> public MsgInfoModel getModel(int id) { MsgInfoModel model = new MsgInfoModel(); string show = "TMIOpenId,TMIMsgRelative"; string where = " AND TMIId=" + id; DataTable dt = miBLL.ExecuteDataTable(show, where); if (ConvertHelper.checkData(dt)) { model.TMIOpenId = ConvertHelper.ToString(dt.Rows[0]["TMIOpenId"]); model.TMIMsgRelative = ConvertHelper.ToString(dt.Rows[0]["TMIMsgRelative"]); } return(model); }
/// <summary> /// 消息主表添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddMsgInfoBackId(MsgInfoModel model) { StringBuilder sql = new StringBuilder(); int backId = 0; sql.AppendFormat(@"INSERT INTO TMsgInfo (TMIOpenId,TMIMsgType,TMIMsgRelative,TMISource,TMIContent,TMIAddTime) values ('{0}','{1}','{2}','{3}','{4}','{5}')" , model.TMIOpenId, model.TMIMsgType, model.TMIMsgRelative, model.TMISource, model.TMIContent, model.TMIAddTime); if (DBHelper.ExecuteSql(sql.ToString()) > 0) { DataTable dt = DBHelper.ExecuteDataTable("SElECT top 1 TMIId from TMsgInfo order by TMIId desc"); if (ConvertHelper.checkData(dt)) { backId = ConvertHelper.ToInt(dt.Rows[0]["TMIId"]); } } return(backId); }
/// <summary> /// 消息主表添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddMsgInfo(MsgInfoModel model) { return(data.AddMsgInfo(model)); }
/// <summary> /// 消息主表添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddMsgInfoBackId(MsgInfoModel model) { return(data.AddMsgInfoBackId(model)); }
protected void Page_Load(object sender, EventArgs e) { id = ConvertHelper.ToInt(Request["id"]); getmodel = getModel(id);//根据消息主表Id获取相关信息 }