receivedsms.cs

该服务平台解决了计算机网络与移动网络之间信息交换问题

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Collections;
using System.Data.Common;
using DataAccess.TableDefine;
using DataAccess.TableAccessor;
using Microsoft.Practices.EnterpriseLibrary.Data;
namespace DataAccess.TableAccessor
{
    
    public class ReceivedSMS
    {
        private Database db = null;

        public ReceivedSMS()
        {
            db = DatabaseFactory.CreateDatabase("SmSConnString");
        }
        public DataTable Countreplay()
        {
            String strSql = "select Deliver.DeliverID,Deliver.MsCentent,Deliver.Mobile,Deliver.DeliverTime ,CompanyID from Deliver where DeliverID <> 0 and CompanyID='62221368001'ORDER BY DeliverTime DESC";
            return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        }
        /// <summary>
        /// 按日期查询
        /// </summary>
        /// <param name="deliverDate"></param>
        /// <returns></returns>
        public DataTable CountSMSreplyByDate(String deliverDate)
        {

            String strSql = String.Format("select Deliver.DeliverID,Deliver.MsCentent,Deliver.Mobile,Deliver.DeliverTime,CompanyID from Deliver where CompanyID='62221368001' and DeliverTime like '{0}%' ORDER BY DeliverTime DESC", deliverDate);
            return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        }
        /// <summary>
        /// 结束日期查询
        /// </summary>
        /// <param name="endDate"></param>
        /// <returns></returns>
        public DataTable CountSMSreplyByendDate(String endDate)
        {

            String strSql = String.Format("select Deliver.DeliverID,Deliver.MsCentent,Deliver.Mobile,Deliver.DeliverTime,CompanyID from Deliver where CompanyID='62221368001' and DeliverTime like '{0}%' ORDER BY DeliverTime DESC", endDate);
            return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        }
        /// <summary>
        /// 开始和结束
        /// </summary>
        /// <param name="endDate"></param>
        /// <returns></returns>
        public DataTable CountSMSreplyByDateInfo(String beginDate,string enddate)
        {

            String strSql = String.Format("select Deliver.DeliverID,Deliver.MsCentent,Deliver.Mobile,Deliver.DeliverTime,CompanyID from Deliver where CompanyID='62221368001' and (DeliverTime between  '{0}' and '{1}') or DeliverTime like '{1}%' ORDER BY DeliverTime DESC", beginDate, enddate);
            return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        }


        public DataTable CountSMSreplyByMobile(String mobile)
        {
            String strSql = String.Format("select Deliver.DeliverID,Deliver.MsCentent,Deliver.Mobile,Deliver.DeliverTime,CompanyID from Deliver where Mobile= '{0}'and CompanyID='62221368001'", mobile);
            return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        }

        public DataTable GetSMSContent(int deliverID)
        {
            string strSql = string.Format("select DeliverID, MsCentent from Deliver where DeliverID ={0}", deliverID);
            return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        }
        //public DataTable CountSMSreplyByDate(String beginDate, String endDate)
        //{
        //    String strSql = String.Format("select Deliver.MsCentent,Deliver.Mobile,Deliver.DeliverTime from Deliver where DeliverTime between '{0}' and '{1}'", beginDate, endDate);
        //    return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        //}
        //public DataTable looktheContent(String deliverID)
        //{
        //    String strSql = String.Format("select Deliver.DeliverID,Deliver.MsCentent,Deliver.Mobile,Deliver.DeliverTime from Deliver where DeliverID= '{0}'", deliverID);
        //    return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        //}
    
    
    }
}