📄 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 + -