?? default.aspx.cs
字號:
StringBuilder xmlResult = new StringBuilder("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
xmlResult.Append("<SOAP-ENV:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\">");
xmlResult.Append("<SOAP-ENV:Header>");
xmlResult.Append("<TransactionID xmlns=\"http://www.monternet.com/dsmp/schemas/\">" + TransactionID + "</TransactionID>");
xmlResult.Append("</SOAP-ENV:Header>");
xmlResult.Append("<SOAP-ENV:Body>");
xmlResult.Append("<SyncOrderRelationResp xmlns=\"http://www.monternet.com/dsmp/schemas/\">");
xmlResult.Append("<Version>" + Version + "</Version>");
xmlResult.Append("<MsgType>" + MsgType + "</MsgType>");
xmlResult.Append("<hRet>" + hRet.ToString() + "</hRet>");
xmlResult.Append("</SyncOrderRelationResp>");
xmlResult.Append("</SOAP-ENV:Body>");
xmlResult.Append("</SOAP-ENV:Envelope>");
Response.Write(xmlResult.ToString());
Response.End();
#endregion*/
}
public class ProvisionInfo
{
public ProvisionInfo() { }
//消息類型
private string msgType;
//該消息編號
private string transactionID;
//該接口消息的版本號，本次所有的接口消息的版本都為“1.5.0”
private string version;
//Send_Address節點與Dest_Address節點
/*發送方：設備類型
0：MISC
100：ISMG
101：WAP SP PROXY
1XX：其他業務網關
200：WAP PORTAL
201：WWW PORTAL
202：VOICE PORTAL
203：PDA PORTAL
2XX：其他門戶
300：MMSC
301：KJAVA SERVER
302：LSP
3XX：其它應用平臺 */
private int send_Address_DeviceType;
//發送方：設備編號，設備編號采用各設備的入網編號，例如短信網關使用網關ID、對SP使用其企業代碼，該設備編號由MISC分配，并且在同一設備類型中該編號唯一
private string send_Address_DeviceID;
//同上接收方
private int dest_Address_DeviceType;
//同上接收方
private string dest_Address_DeviceID;
//FeeUser_ID與DestUser_ID節點
//計費用戶標識：用戶標識類型 1：用手機號標識 2：用偽碼標識 3：兩者同時標識
private int feeUser_ID_UserIDType;
//計費用戶標識：用戶手機號
private string feeUser_ID_MSISDN;
//計費用戶標識：用戶偽碼
private string feeUser_ID_PseudoCode;
//同上使用用戶標識
private int destUser_ID_UserIDType;
//同上使用用戶標識
private string destUser_ID_MSISDN;
//同上使用用戶標識
private string destUser_ID_PseudoCode;
//臨時訂購關系的事務ID
private string linkID;
/*服務狀態管理動作代碼，具體值如下：
1： 開通服務；
2： 停止服務；
3： 激活服務；
4： 暫停服務；*/
private int actionID;
/*產生服務狀態管理動作原因的代碼，具體值如下：
1：用戶發起行為
2：Admin&1860發起行為
3：Boss停機
4：Boss開機
5：Boss過戶
6：Boss銷戶
7：Boss改號
8：扣費失敗導致的服務取消
9：其他*/
private int actionReasonID;
//該字段及對應屬性用于反向接口中Service_ID節點
private int serviceIDType;
//SP的企業代碼
private string spid;
//SP中該服務的服務代碼
private string spServiceID;
//服務的訪問方式 1：WEB 2：WAP 3：SMS
private int accessMode;
//服務訂購參數（base64加密），內容是長號碼＋空格＋用戶發送內容
private string featureStr;
public string MsgType
{
get { return this.msgType; }
set { this.msgType = value; }
}
public string TransactionID
{
get { return this.transactionID; }
set { this.transactionID = value; }
}
public string Version
{
get { return this.version; }
set { this.version = value; }
}
public int Send_Address_DeviceType
{
get { return this.send_Address_DeviceType; }
set { this.send_Address_DeviceType = value; }
}
public string Send_Address_DeviceID
{
get { return this.send_Address_DeviceID; }
set { this.send_Address_DeviceID = value; }
}
public int Dest_Address_DeviceType
{
get { return this.dest_Address_DeviceType; }
set { this.dest_Address_DeviceType = value; }
}
public string Dest_Address_DeviceID
{
get { return this.dest_Address_DeviceID; }
set { this.dest_Address_DeviceID = value; }
}
public int FeeUser_ID_UserIDType
{
get { return this.feeUser_ID_UserIDType; }
set { this.feeUser_ID_UserIDType = value; }
}
public string FeeUser_ID_MSISDN
{
get { return this.feeUser_ID_MSISDN; }
set { this.feeUser_ID_MSISDN = value; }
}
public string FeeUser_ID_PseudoCode
{
get { return this.feeUser_ID_PseudoCode; }
set { this.feeUser_ID_PseudoCode = value; }
}
public int DestUser_ID_UserIDType
{
get { return this.destUser_ID_UserIDType; }
set { this.destUser_ID_UserIDType = value; }
}
public string DestUser_ID_MSISDN
{
get { return this.destUser_ID_MSISDN; }
set { this.destUser_ID_MSISDN = value; }
}
public string DestUser_ID_PseudoCode
{
get { return this.destUser_ID_PseudoCode; }
set { this.destUser_ID_PseudoCode = value; }
}
public string LinkID
{
get { return this.linkID; }
set { this.linkID = value; }
}
public int ActionID
{
get { return this.actionID; }
set { this.actionID = value; }
}
public int ActionReasonID
{
get { return this.actionReasonID; }
set { this.actionReasonID = value; }
}
public int ServiceIDType
{
get { return this.serviceIDType; }
set { this.serviceIDType = value; }
}
public string SPID
{
get { return this.spid; }
set { this.spid = value; }
}
public string SPServiceID
{
get { return this.spServiceID; }
set { this.spServiceID = value; }
}
public int AccessMode
{
get { return this.accessMode; }
set { this.accessMode = value; }
}
public string FeatureStr
{
get { return this.featureStr; }
set { this.featureStr = value; }
}
}
class CDataCtrl
{
private SqlConnection obj_Connection;
private SqlCommand obj_Command;
private string strProc;//存儲過程名稱
public string ServerStr;//連接字符串
public CDataCtrl()
{
strProc = "";
ServerStr = "";
}
public CDataCtrl(string server, string uid, string pwd, string database)
{
try
{
ServerStr = "Initial Catalog='" + database + "';Server='" + server + "';User ID='" + uid + "';password='" + pwd + "'";
obj_Connection = new SqlConnection(ServerStr);
obj_Connection.Open();//連接數據庫
obj_Command = new SqlCommand(strProc, obj_Connection);
obj_Command.CommandType = CommandType.StoredProcedure;
}
catch (Exception e)
{
string s = e.Message;
}
}
/*
* 判斷是否為注冊用戶
*/
public int IVR_IsRegister(string phone)
{
strProc = "IVR_IsRegister";
SqlParameter Parameter_phone = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
Parameter_phone.Value = phone;
Parameter_phone.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(Parameter_phone);//增加參數
SqlParameter returnParameter = new SqlParameter("returnValue", SqlDbType.Int, 4);
returnParameter.Direction = ParameterDirection.ReturnValue;//指定該參數return值
obj_Command.Parameters.Add(returnParameter);
obj_Command.ExecuteNonQuery();//執行存儲過程并返回受影響的行
if (Convert.ToInt32(obj_Command.Parameters["returnValue"].Value) == 1)
{
return 1;
}
else
{
return 0;
}
}
public SqlDataReader IVR_GetUserUID(string phone)
{
strProc = "IVR_GetUserUID";
SqlParameter parameter_phone = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
parameter_phone.Value = phone;
parameter_phone.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameter_phone);
SqlDataReader datareader = obj_Command.ExecuteReader();
return datareader;
}
/*功能：獲取用戶手機UID數
*
*/
public int IVR_GetUserUIDCnt(string phone)
{
strProc = "IVR_GetUserUIDCnt";
SqlParameter parameter_phone = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
parameter_phone.Value = phone;
parameter_phone.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameter_phone);
SqlParameter returnParameter = new SqlParameter("returnValue", SqlDbType.Int, 4);
returnParameter.Direction = ParameterDirection.ReturnValue;
obj_Command.Parameters.Add(returnParameter);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -