// vissiter viss = new vissiter(); public bool login_admin(vissiter viss ) { //dbo.pro_loginvisster SqlCommand cmd = DBhelper.con.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "dbo.pro_loginvisster"; cmd.Parameters.Add("@adminName", SqlDbType.VarChar, 50).Value = viss.AdminName; cmd.Parameters.Add("@adminpwd", SqlDbType.VarChar, 15).Value = viss.AdminPwd; //返回值 SqlParameter parret = new SqlParameter("@retvalues",SqlDbType.Int); parret.Direction = ParameterDirection.ReturnValue; int ret = 0; cmd.Parameters.Add(parret); try { DBhelper.con.Open(); cmd.ExecuteNonQuery(); ret = (int)parret.Value; } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { DBhelper.con.Close(); DBhelper.con.Dispose(); } if (ret == 1) { return true; } else return false; }
public bool login_admin(vissiter viss) { return viser.login_admin(viss); }