public static bool MessageAdd(Model.MemberMessage msg) { string sql = @"Insert Into MemberMessage(FromNumber,ToNumber,MessageDate,MessageIP,[Content]) Values(@FromNumber,@ToNumber,@MessageDate,@MessageIP,@Content)"; SqlParameter[] para = { new SqlParameter("@FromNumber", SqlDbType.NVarChar, 30), new SqlParameter("@ToNumber", SqlDbType.NVarChar, 30), new SqlParameter("@MessageDate", SqlDbType.NVarChar, 30), new SqlParameter("@MessageIP", SqlDbType.NVarChar, 30), new SqlParameter("@Content", SqlDbType.Text, 4000) }; para[0].Value = msg.FromNumber; para[1].Value = msg.ToNumber; para[2].Value = msg.MessageDate; para[3].Value = msg.MessageIP; para[4].Value = msg.Content; int count = (int)DBHelper.ExecuteNonQuery(sql, para, CommandType.Text); if (count == 0) { return(false); } return(true); }
public static bool MessageAdd(Model.MemberMessage Msg) { return(DAL.PersonalSpace.Message.MessageAdd(Msg)); }