控制短信猫收发短信 (调用WebServices)

需求说明：

　　要求定时查询Doing表（待发短信）和短信猫中是否有数据，如果有信息则发送/接收。

表结构

　　Doing（ID MOBILID CONTEXT USERNAME DOTIME) －－待发送的短信
　　Done（ID MOBILID CONTEXT SENDTIME USERNAME )－－已发送的短信
　　Receive（ID MOBILID CONTEXT RECEIVETIME)－－接受道的短信

　　GSMMultiPort.dll－－控制猫的封装包（为提供）
　　里面有：
 ‘初始化’，
 ‘获取短信猫标识号码’，
 ‘获取设备的连接状态’，
 ‘断开连接并释放内存空间’，
 ‘取得错误信息’，
 ‘发送短信息’，
 ‘接收短信息’等方法。

Service.cs代码
<----------------------------------------------------------------------------------------------->
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlTypes;
using System.Collections;

[WebService(Namespace = "此处为自己设定的XML命名空间")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class Service : System.Web.Services.WebService
{
    public string myConnstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("lmtof.mdb");
    protected OleDbConnection myconn;
    protected OleDbCommand mycommand;
    protected OleDbDataAdapter myda;
    protected OleDbTransaction mytran;
    protected DataSet ds;

    public Service ()
    {
        myconn = new OleDbConnection(myConnstring);
        //如果使用设计的组件，请取消注释以下行
        //InitializeComponent();    
    }

    #region //发信息
    [WebMethod/*是否有数据要发送*/]
    public string checkSMS()
    {
        string selectsql = "SELECT * FROM doing";
        mycommand = new OleDbCommand(selectsql, myconn);
        try
        {
            myconn.Open();
            if (Convert.ToInt32(mycommand.ExecuteScalar()) > 0)
            {
                return "true";
            }
            else
            { return "false"; }
        }
        catch (Exception ee)
        {
            return "ErrorWebService:"+ee.ToString();
        }
        finally { myconn.Close(); }
    }

    [WebMethod]
    public DataSet getSMS(out string error)
    {
        error = "";
        DataSet info=new DataSet();
        string selectsql = "SELECT CStr(id) + '|' + mobilid + '|'+context+'|'+username+'|'+cstr(dotime) FROM doing";
        try
        {
            myda = new OleDbDataAdapter(selectsql, myconn);
            myda.Fill(info);
            return info;
        }
        catch (Exception ee)
        {
            error = "ErrorWebService:" + ee.ToString();
            return info;         
        }

    }

    [WebMethod]
    //winform发送信息后，删除信息
    //错误编码为‘ErrorWebService:’＋ 错误信息
    public string sendSMS(string uid ,string id , string mobilid, string context, string sendtime , string username )
    {
        if (uid != "oa.ftwsjd.gov.cn")
        {
            return "access denied";
        }
        try
        {
            //事务处理
            //myconn.Open();
            //mycommand = myconn.CreateCommand();
            //mytran = myconn.BeginTransaction();
            //mycommand.Transaction = mytran;
            //mycommand.CommandText = "INSERT INTO done(mobilid,context,username,sendtime) VALUES ('" + mobilid + "','" + context + "','" + username + "','" + sendtime + "')";
            //mycommand.ExecuteNonQuery();
            //mycommand.CommandText = "DELETE FROM doing WHERE id=" + id;
            //mycommand.ExecuteNonQuery();
            //mytran.Commit();
            return "true";
        }
        catch (Exception ee)
        {
            return "ErrorWebService:" + ee.ToString();
        }
        finally
        {
            myconn.Close();
        }
    }
    #endregion

    #region//收信息
    [WebMethod]
    //接收 SMS 插入Receive表中
    //错误编码为‘ErrorWebService:’＋ 错误信息
    public string ReceiveSMS(string MOBILID, string CONTEXT, DateTime RECEIVETIME)
    {
        try
        {
            myconn.Open();
            mycommand = myconn.CreateCommand();          
            mytran = myconn.BeginTransaction();
            mycommand.Transaction = mytran;
            mycommand.CommandText = "INSERT INTO receive(MOBILID,CONTEXT,RECEIVETIME) VALUES ('" + MOBILID + "','" + CONTEXT + "','" + RECEIVETIME + "')";
            mycommand.ExecuteNonQuery();
            mytran.Commit();
            return "true";
        }
        catch (Exception ee)
        {
            return "ErrorWebService:" + ee.ToString();
        }
        finally
        { myconn.Close(); }
    }
    #endregion
}
<----------------------------------------------------------------------------------------------->