CSWDAL/DALmessage.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using DBUtility;
using CSWModel;
namespace CSWDAL
{
   public class DALmessage
   {
       #region 留言信息分页
       /// <summary>
       /// 分页
       /// </summary>
       /// <param name="PageIndex"></param>
       /// <param name="PageSize"></param>
       /// <param name="PageCount"></param>
       /// <param name="RecordCount"></param>
       /// <param name="strWhere"></param>
       /// <returns></returns>
       public static DataTable GetAllMessage(int PageIndex, int PageSize, out int PageCount, out int RecordCount, string strWhere)
       {
           string strsql = "select * from csw_message";
           string strShow = " * ";
           return (new AcsHelper().ExecutePager(PageIndex, PageSize, "id", strShow, strsql, strWhere, " id DESC ", out PageCount, out RecordCount));
       }
       #endregion

       #region 删除指定id的留言信息
       public static bool DeleteMessage(string MessageId)
       {
           string strsql = "delete from csw_message where id in("+MessageId+")";
           int reValue = new AcsHelper().ExecuteNonQuery(strsql);
           if (reValue > 0)
           {
               return true;
           }
           else
           {
               return false;
           }
       }
       #endregion

       #region 读取指定id信息
       public static List<ModelMessage> ReadMessageInfo(string MessageId)
       {
           List<ModelMessage> lt = new List<ModelMessage>();
           ModelMessage mes = new ModelMessage();
           string str = "select * from csw_message where id="+MessageId;
           DataSet ds = new AcsHelper().ExecuteDataSet(str);
           if (ds.Tables[0].Rows.Count > 0)
           {
               mes.csw_name = ds.Tables[0].Rows[0][1].ToString();
               mes.csw_post = ds.Tables[0].Rows[0][2].ToString();
               mes.csw_tel = ds.Tables[0].Rows[0][3].ToString();
               mes.csw_email = ds.Tables[0].Rows[0][4].ToString();
               mes.csw_companyname = ds.Tables[0].Rows[0][5].ToString();
               mes.csw_contents = ds.Tables[0].Rows[0][6].ToString();