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