Olá,
Uma útima tentativa, antes de partir para session:
Tenho na procedure;
ALTER PROCEDURE [dbo].[USP_Pec_01_Usuarios_Seleciona]
@LOGIN AS varchar(50),
@SENHA AS varchar(255),
@SITUACAO AS varchar(7),
@CH_TIPO AS int OUTPUT
As
if (@login Is Not Null)
Begin
SET NOCOUNT ON
SELECT a.Descricao, a.ch_top from Tb_Pec_01_Usuarios_Grupos a
INNER JOIN Tb_Pec_01_Usuarios b ON a.ch_top=b.grupo WHERE Login = @Login AND Senha = @Senha And Situacao = @Situacao
SELECT ch_top from Tb_Pec_01_Usuarios WHERE Login = @Login AND Senha = @Senha And Situacao = @Situacao
SET @CH_TIPO = (SELECT ch_top from Tb_Pec_01_Usuarios WHERE Login = @Login AND Senha = @Senha And Situacao = @Situacao )
update Tb_Pec_01_Usuarios
set situacao = 'Inativo' WHERE Data_Vencimento > Data_Cadastro + 3650
SET NOCOUNT OFF
End
Else
Begin
SET NOCOUNT ON
Select nome From tbl_pec_01_Usuarios
SET NOCOUNT OFF
End
RETURN
.................
Tenho essa seleção
SELECT ch_top from Tb_Pec_01_Usuarios WHERE Login = @Login AND Senha = @Senha And Situacao = @Situacao
Tem outra forma de recuperar este valor na rotina sem usar o SqlParameter?
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["E-IndustriasConnectionString"].ConnectionString);
clsCript cript = new clsCript();
senha = cript.encrypt(txtSenha.Text);
SqlCommand cmd = new SqlCommand("USP_Pec_01_Usuarios_Seleciona", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter Login = new SqlParameter("@Login", SqlDbType.VarChar, 50);
Login.Value = this.txtLogin.Text.Trim();
cmd.Parameters.Add(Login);
SqlParameter Senha = new SqlParameter("@Senha", SqlDbType.VarChar, 255);
Senha.Value = senha;
cmd.Parameters.Add(Senha);
SqlParameter Situacao = new SqlParameter("@Situacao", SqlDbType.VarChar, 7);
Situacao.Value = "Ativo";
cmd.Parameters.Add(Situacao);
SqlParameter prChTipo;
prChTipo = new SqlParameter("@CH_TIPO", SqlDbType.Int, 4);
prChTipo.Value = 0;
cmd.Parameters.Add(prChTipo);
prChTipo.Direction = ParameterDirection.InputOutput;
try
{
conn.Open();
grupo = Convert.ToString(cmd.ExecuteScalar());
Session["Codigo"] = prChTipo.Value.ToString();
Session["CHTIPO"] = prChTipo.Value.ToString();
conn.Close();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
if (grupo == "")
{
this.lblMensagem.Visible = true;
}
else
{
string encTik;
HttpCookie Cookie;
FormsAuthenticationTicket tik;
tik = new FormsAuthenticationTicket(1, txtLogin.Text, DateTime.Now, DateTime.Now.AddDays(1), chkLembrar.Checked, grupo);
encTik = FormsAuthentication.Encrypt(tik);
Cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTik);
if (chkLembrar.Checked)
{
Cookie.Expires = DateTime.Now.AddDays(1);
}
Response.Cookies.Add(Cookie);
Response.Redirect(FormsAuthentication.GetRedirectUrl(txtLogin.Text, chkLembrar.Checked));
conn.Close();
}
}
}
DMA2
