📄 default.aspx.cs
字号:
obj_Command.ExecuteNonQuery();
return (Convert.ToInt32(obj_Command.Parameters["returnValue"].Value));
}
public int ivr_GetVirtualNumByPhone(string phone)
{
strProc = "ivr_GetVirtualNumByPhone";
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);
obj_Command.ExecuteNonQuery();
return (Convert.ToInt32(obj_Command.Parameters["returnValue"].Value));
}
/*功能：判断用户的是否限制注册号码
*
*/
public int IVR_CanRegister(string phone)
{
strProc = "IVR_CanRegister";
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);
obj_Command.ExecuteNonQuery();
obj_Connection.Close();
return (Convert.ToInt32(obj_Command.Parameters["returnValue"].Value));
}
/*随机选号
*
*/
public string IVR_GetRandVirtualPhone()
{
strProc = "IVR_GetRandVirtualPhone";
SqlDataReader datareader = obj_Command.ExecuteReader();
if (datareader.Read())
{
return datareader[0].ToString();
}
return "";
}
/*
* 注册用户
*/
public SqlDataReader IVR_UserRegister(int Module_Id, string Phone, string UID, string Operter, string ServiceID)
{
strProc = "IVR_UserRegister";
SqlParameter parameterModuleId = new SqlParameter("@Module_Id", SqlDbType.Int, 4);
parameterModuleId.Value = Module_Id;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterModuleId);
SqlParameter parameterPhone = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
parameterPhone.Value = Phone;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterPhone);
SqlParameter parameterUID = new SqlParameter("@sUID", SqlDbType.VarChar, 10);
parameterUID.Value = UID;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterUID);
SqlParameter parameterOpserter = new SqlParameter("@Operator", SqlDbType.VarChar, 20);
parameterOpserter.Value = Operter;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterOpserter);
SqlParameter parameterServiceID = new SqlParameter("@ServiceID", SqlDbType.VarChar, 10);
parameterServiceID.Value = ServiceID;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterServiceID);
SqlDataReader datareader = obj_Command.ExecuteReader();
return datareader;
}
/*
* 注销单个UID
* @Module INT,
@Phone VARCHAR(20),
@sUID VARCHAR(20),
@Operator VARCHAR(20)
*/
public int IVR_UserCancelOneUID(int Module_ID, string Phone, string UID, string Operator)
{
strProc = "IVR_UserCancelOneUID";
SqlParameter parameterModuleId = new SqlParameter("@Module", SqlDbType.Int, 4);
parameterModuleId.Value = Module_ID;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterModuleId);
SqlParameter parameterPhone = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
parameterPhone.Value = Phone;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterPhone);
SqlParameter parameterUID = new SqlParameter("@sUID", SqlDbType.VarChar, 20);
parameterUID.Value = UID;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterUID);
SqlParameter parameterOperter = new SqlParameter("@Operator", SqlDbType.VarChar, 20);
parameterOperter.Value = Operator;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterOperter);
SqlParameter returnParameter = new SqlParameter("@OpState", SqlDbType.Int, 4);
returnParameter.Direction = ParameterDirection.ReturnValue;
obj_Command.Parameters.Add(returnParameter);
return (Convert.ToInt32(obj_Command.Parameters["@OpState"].Value));
}
/*注销所有UID
* @Module INT,
@Phone VARCHAR(20),
@Operator VARCHAR(20)
*/
public int IVR_UserCancelAllUID(int Module_ID, string Phone, string Operator)
{
strProc = "IVR_UserCancelOneUID";
SqlParameter parameterModuleId = new SqlParameter("@Module", SqlDbType.Int, 4);
parameterModuleId.Value = Module_ID;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterModuleId);
SqlParameter parameterPhone = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
parameterPhone.Value = Phone;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterPhone);
SqlParameter parameterOperter = new SqlParameter("@Operator", SqlDbType.VarChar, 20);
parameterOperter.Value = Operator;
parameterModuleId.Direction = ParameterDirection.Input;
obj_Command.Parameters.Add(parameterOperter);
SqlParameter returnParameter = new SqlParameter("State", SqlDbType.Int, 4);
returnParameter.Direction = ParameterDirection.ReturnValue;
obj_Command.Parameters.Add(returnParameter);
return (Convert.ToInt32(obj_Command.Parameters["State"].Value));
}
}
CDataCtrl dbctrl = new CDataCtrl("127.0.0.1","sa","123","FJGLHHApp");
public int DHTA_Db(string sSrcNumber,string sOrder)
{
int nUIDCount;
nUIDCount = dbctrl.ivr_GetVirtualNumByPhone(sSrcNumber);//获取用户UID数量
if (nUIDCount == 0)
{
if (sOrder.IndexOf("-DHTA") >= 0)
{
this.Loop_Reg(1,sSrcNumber);//注册1个虚拟号码
return 0;
}
else if (sOrder.IndexOf("-DHTB") >= 0)
{
this.Loop_Reg(2,sSrcNumber);//注册2个虚拟号码
return 0;
}
else if (sOrder.IndexOf("-DHTD") >= 0)
{
this.Loop_Reg(3,sSrcNumber);//注册3个虚拟号码
return 0;
}
}
else if (nUIDCount == 1)
{
if (sOrder.IndexOf("-DHTA") >= 0)
{
this.Loop_Reg(1,sSrcNumber);
return 0;
}
else if (sOrder.IndexOf("-DHTB") >= 0)
{
this.Loop_Reg(2,sSrcNumber);
return 0;
}
else if (sOrder.IndexOf("-DHTD") >= 0)
{
return 1;
}
}
else if (nUIDCount == 2)
{
if (sOrder.IndexOf("-DHTA") >= 0)
{
this.Loop_Reg(1,sSrcNumber);
return 0;
}
else if (sOrder.IndexOf("-DHTB") >= 0)
{
return 1;
}
else if (sOrder.IndexOf("-DHTD") >= 0)
{
return 1;
}
}
else//(nUIDCount >= 3)
{
return 1;
}
return 0;
}
/*
* nCount:循环次数
*/
public void Loop_Reg(int nCount,string sSrcNumber)
{
for(int i = 1;i <= nCount;i++)
{
dbctrl.IVR_UserRegister(1, sSrcNumber, "", "1001", "多号通");//注册虚拟号码
}
return;
}
/*
* nCount:取消1,2,3
*/
public int CancelUID_CheckTime(string sSrcNumber, int nCount)
{
int nUIDCount;
nUIDCount = dbctrl.ivr_GetVirtualNumByPhone(sSrcNumber);//获取用户UID数量
if (nCount > nUIDCount)
{
return 1;//取消次数过多
}
else
{
return 0;//可以取消
}
}
/*
* nCount:取消次数
*/
public int CancelUID(string sSrcNumber,int nCount)
{
SqlDataReader dbreader = dbctrl.IVR_GetUserUID(sSrcNumber);
for (int i = 0; i < nCount; i++)
{
if (dbreader.Read())
{
dbctrl.IVR_UserCancelOneUID(1, sSrcNumber, dbreader[i].ToString(), "1001");
}
}
return 0;
}
protected void button1_Click(object sender, EventArgs e)
{
}
private void Connect_ISMG()
{
Client c = new Client();
c.RequestMessageSend += new Client.MessageEventHandle(this.c_RequestMessageSend);
c.ResponseMessageReceive += new Client.MessageEventHandle(this.c_ResponseMessageReceive);
c.Connect("localhost", 7890, "901236", "1236", ++i);//连接服务器
}
private void c_ResponseMessageReceive(Client Sender, MessageEventArgs e)
{
Message_Header header = e.Header;
byte[] bytes = new byte[header.Total_Length];
header.ToBytes().CopyTo(bytes, 0);
e.BodyData.CopyTo(bytes, Message_Header.Length);
string sSrc_Number = "";//用户号码
string s = "";
if (header.Command_Id == CMPP_Command_Id.CMPP_ACTIVE_TEST_RESP)
{
CMPP_ACTIVE_TEST_RESP response = new CMPP_ACTIVE_TEST_RESP(bytes);
s = response.ToString();
}
else if (header.Command_Id == CMPP_Command_Id.CMPP_CONNECT_RESP)
{
CMPP_CONNECT_RESP response = new CMPP_CONNECT_RESP(bytes);
s = response.ToString();
}
else if (header.Command_Id == CMPP_Command_Id.CMPP_DELIVER)
{
CMPP_DELIVER response = new CMPP_DELIVER(bytes);
if (response.Registered_Delivery == 0)
{
s = String.Format("收到普通短信: \n{0}", response.ToString());
}
else
{
//该模拟器不能自动生成状态报告再下发!请自行键入下面短信内容后,发送
//状态报告短信: 00000001DELIVRD031213505003121350501391xxx11381391xxx11381391xx11380001
sSrc_Number = (Encoding.ASCII.GetBytes(response.Src_terminal_Id)).ToString();//取用户号码
sSrc_Number.Trim();
CMPP_Msg_Content x = new CMPP_Msg_Content(Encoding.ASCII.GetBytes(response.Msg_Content));//取短信内容
s = x.ToString();
if (Is_Number(s))
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -