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