sendingsmstowin.cs

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 42 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Web;
using System.Data.SqlClient;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common;


namespace DataAccess
{
    public class SendingSMSToWin
    {
        private Database db;
        private const string SQL_ADD_SENDINGSMS = "INSERT INTO SendingSMS (MessageContent,Mobile,Trade,SmsType,CitySchool,Date) VALUES " +
            "('{0}','{1}',{2},{3},'{4}','{5}')";
        public SendingSMSToWin()
        {
            db = DatabaseFactory.CreateDatabase("SmSConnString");
        }
        public int AddMainOfSendingSMS(string messageContent, string mobile, int trade, int smsType, string citySchool, string date)
        {
            string strSQL = string.Format(SQL_ADD_SENDINGSMS, messageContent, mobile, trade, smsType, citySchool, date);
            try
            {
                return db.ExecuteNonQuery(CommandType.Text, strSQL);
            }
            catch
            {
                return 0;
            }
        }

        public int MsgToMainDataBase(String mobile, String msg)
        {
            String strSql = String.Format("INSERT INTO SendingSMS (Mobile,MessageContent) VALUES('{0}','{1}')", mobile, msg);
            return db.ExecuteNonQuery(CommandType.Text, strSql);
        }
    }
}