sendobject.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace DataAccess.TableAccessor
{
    public class SendObject
    {
        private Database db = null;
        public SendObject()
        {
            db = DatabaseFactory.CreateDatabase("Connection String");
        }

        public int AddSendObject(int smsID,String city,String county,String village,String operationType,
            String particularOperation,String organise,String trader)
        {
            String strSql = string.Format("INSERT INTO SendObject(SMSID, City, County, Village, " +
                "OperationType, ParticularOperation, Organise, Trader) VALUES ({0},'{1}','{2}'," +
                "'{3}','{4}','{5}','{6}','{7}')", smsID, city, county, village, operationType, particularOperation,
                organise, trader);
            return db.ExecuteNonQuery(CommandType.Text, strSql);
        }

        public DataTable GetSingleSubmissionSMS(int smsID)
        {
            String strSql = string.Format("SELECT City, County, Village, OperationType, ParticularOperation, " +
                "Organise, Trader FROM SendObject WHERE (SMSID = {0})", smsID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
    }
}