/// <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获取相关信息
}
