下面是数据库的实现代码:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
namespace CMPP
{
class SMSData
{
private string errMessage;
private OleDbConnection oleConn;
private OleDbCommand oleGetSynOrderRelation;
private OleDbCommand oleGetWillSendSM_CM;
private OleDbCommand oleGetWillSendSM_UC;
private OleDbCommand oleRegistSPNumber;
private OleDbCommand oleSaveRecievedSM;
private OleDbCommand oleSaveSyncOrderRelation;
private OleDbCommand oleSetSendSMDoneTime;
private OleDbCommand oleSetSendSMFlag;
private OleDbCommand oleSetSendSMMsgId;
private OleDbCommand oleUpdateSynOrderRelationFlag;
public SMSData()
{
this.InitializeComponent();
}
public int GetWillSendSM_CM(ref long id, ref CMPP_SUBMIT mess)
{
int num1 = 0;
try
{
OleDbDataAdapter adapter1 = new OleDbDataAdapter(this.oleGetWillSendSM_CM);
DataTable table1 = new DataTable("tbl_SendSM");
if (adapter1.Fill(table1) > 0)
{
id = Convert.ToInt64(table1.Rows[0]["id"].ToString());
mess.Pk_total = 0;
mess.Pk_number = 0;
if (table1.Rows[0]["Registered_Delivery"].ToString().Trim().Length > 0)
{
mess.Registered_Delivery = Convert.ToByte(table1.Rows[0]["Registered_Delivery"].ToString());
}
else
{
mess.Registered_Delivery = 1;
}
if (table1.Rows[0]["Msg_level"].ToString().Trim().Length > 0)
{
mess.Msg_level = Convert