DAL/DAlmessage.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;

using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
namespace DAL
{
    public class DALmessage
    {
        public int post(message mes)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into message(_title,_content,_ip) values(@title,@content,@ip)");

            SqlParameter[] pra = { 
                               new SqlParameter("@title",SqlDbType.VarChar,50),
                               new SqlParameter("@content",SqlDbType.VarChar,250),
                               new SqlParameter("@ip",SqlDbType.VarChar,50)
                               };
            pra[0].Value = mes.title;
            pra[1].Value = mes.content;
            pra[2].Value = mes.ip;


            return Common.DbHelperSQL.ExecuteSql(sql.ToString(), pra);
        }

        public DataSet select(int pageindex, int pagesize, string table)
        {
            //StringBuilder sql = new StringBuilder();
            //sql.Append("select * from message where _state=" + 1 + "");
            //return Common.DbHelperSQL.Query(sql.ToString());

            string sql = "select * from message where _state=" + 1 + "";
            DataSet ds = Common.DB.PagedataSet(sql, pageindex, pagesize, table);
            return ds;

        }

        public DataSet messelect(int pageindex, int pagesize, string table,string title)
        {
            string sql = "select * from message where _title like '%" + title + "%'";
            DataSet ds = Common.DB.PagedataSet(sql, pageindex, pagesize, table);
            return ds;
        
        }

        public int mes_select(string title)
        {

            string sqlstr = "select count(*) from message where _title like '%"+title+"%' ";
            int result;
            if (Common.DB.ExecuteScalar(sqlstr) == null)
            {
                result = 0;

            }
            else