if (string.IsNullOrEmpty(UserName.Text.Trim().ToString()) || string.IsNullOrEmpty(Name.Text.Trim().ToString()) || string.IsNullOrEmpty(password.Text.Trim().ToString()))
{
Response.Write("<Script>alert('用户名或姓名或密码为空,请输入');history.go(-1)</Script>");
Response.End();
}
else
{
ZWDC_XT_USEREntity UserEntity = new ZWDC_XT_USEREntity();
UserEntity.USER_NAME = UserName.Text.Trim().ToString();
UserEntity.USER_CNAME = Name.Text.Trim().ToString();
UserEntity.USER_PWD = password.Text.Trim().ToString();
// LoginStr DLogin = new LoginStr();
// DLogin.SysLogin(UserEntity); OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["OracleConn"].ToString());
if (conn.State != ConnectionState.Open) { conn.Open(); }
// string oracleStr = "loginstr";//存储过程
OracleParameter[] LoginOP ={
new OracleParameter(":uname2",UserEntity.USER_NAME),
new OracleParameter(":namec2",UserEntity.USER_CNAME),
new OracleParameter(":pasd2", UserEntity.USER_PWD)
}; OracleCommand cmd = new OracleCommand("LOGINSTR", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(LoginOP);
int a = cmd.ExecuteNonQuery(); 提示信息为:内部 .Net Framework 数据提供程序错误 30。
if (a > 0)
{
Response.Write("1"); }
else { Response.Write("0");
}
}
{
Response.Write("<Script>alert('用户名或姓名或密码为空,请输入');history.go(-1)</Script>");
Response.End();
}
else
{
ZWDC_XT_USEREntity UserEntity = new ZWDC_XT_USEREntity();
UserEntity.USER_NAME = UserName.Text.Trim().ToString();
UserEntity.USER_CNAME = Name.Text.Trim().ToString();
UserEntity.USER_PWD = password.Text.Trim().ToString();
// LoginStr DLogin = new LoginStr();
// DLogin.SysLogin(UserEntity); OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["OracleConn"].ToString());
if (conn.State != ConnectionState.Open) { conn.Open(); }
// string oracleStr = "loginstr";//存储过程
OracleParameter[] LoginOP ={
new OracleParameter(":uname2",UserEntity.USER_NAME),
new OracleParameter(":namec2",UserEntity.USER_CNAME),
new OracleParameter(":pasd2", UserEntity.USER_PWD)
}; OracleCommand cmd = new OracleCommand("LOGINSTR", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(LoginOP);
int a = cmd.ExecuteNonQuery(); 提示信息为:内部 .Net Framework 数据提供程序错误 30。
if (a > 0)
{
Response.Write("1"); }
else { Response.Write("0");
}
}
create or replace procedure loginstr(UName out varchar2, pasd out varchar2,namec out varchar2,UName2 IN VARCHAR2,pasd2 IN VARCHAR2,namec2 in varchar2) is
begin
select User_name,User_pwd,User_Cname into Uname,pasd,namec from zwdc_xt_user where User_name=Uname2 and User_pwd=pasd2 and User_Cname=namec2;
end loginstr;
OracleCommand cmd = new OracleCommand("LOGINSTR", conn);
cmd.CommandType = CommandType.StoredProcedure;
跟这里的有关。就是不知道怎么解决这个办法。