/// <summary>
/// 获取接收者短信息
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public DataSet MsgSelectAccepterMsg(MarriageMsg msg)
{
SqlParameter[] parms =
{
data.MakeInParam("@Accepter", SqlDbType.VarChar, 100, msg.Accepter),
};
return(data.RunProcReturn("SELECT * FROM v_msg where Accepter=@Accepter order by id desc", parms, "v_msg"));
}
/// <summary>
/// 添加短消息到数据库
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public int MsgAdd(MarriageMsg msg)
{
SqlParameter[] parms =
{
data.MakeInParam("@Sender", SqlDbType.VarChar, 100, msg.Sender),
data.MakeInParam("@Accepter", SqlDbType.VarChar, 100, msg.Accepter),
data.MakeInParam("@Msg", SqlDbType.Text, 0, msg.Msg),
};
return(data.RunProc("Insert into tb_Msg(Sender, Accepter,Msg) values (@Sender, @Accepter,@Msg)", parms));
}
