1using System;
 2using System.Collections.Generic;
 3using System.Linq;
 4using System.Text;
 5using System.Data;
 6using Entity;
 7
 8namespace DAL
 9...{
10    public class MessageDAL
11    ...{
12        public static DataTable GetMessage()
13        ...{
14            string sql = "select message.*,hoteluser.username from message inner join hoteluser on message.userid=hoteluser.userid";
15            return SQLHelp.FillTable(sql);
16        }
17        public static int InsertMessage(int userid, string message)
18        ...{
19            string sql = "insert into message (userid,message) values("+userid+",'"+message+"')";
20            return SQLHelp.ExecQuery(sql);
21        }
22    }
23}
24//该源码下载自www.51aspx.com(５１aspｘ．ｃｏｍ)
25