SQL output parameter Application

 

Code
// Return select *   From M3_user Where U_mask = @ Mask And @ RET
Create   Proc M3_user_login
@ Mask   Varchar ( 64 ),
@ Password   Varchar ( 64 ),
@ RET   Int Output
As  
Set Nocount On
Declare   @ Dbpwd   Varchar ( 64 )
If   Not   Exists ( Select   1   From M3_user Where U_mask = @ Mask )
  Set   @ RET   =   - 1
Else
  Begin
 
Select   @ Dbpwd   =   Isnull (U_passwd, '' ) From M3_user Where U_mask = @ Mask

If   @ Dbpwd   <>   @ Password  
Set   @ RET = 0
Else
Begin
Select   *   From M3_user Where U_mask = @ Mask
Set   @ RET   =   1
End
  End
Go

 

Code
Userdata ud = ( New Bll. User (). login (straccount, webhelper. putpwd (strpwd ), Out Nret );

Public Userdata login (string strmask, string strpassword, Out Int32 nret)
{
// Check account is card no
// Check Error Type 0,-1
Userdata = Dal. login (strmask, strpassword, Out Nret );
// That is, userdata is returned and out nret is also obtained.

If (Nret = (Int32) enum_ret_login.ret_success) // Based on nret
{

}
Else
{
Return Null;
}

}