public bool login_money(Money mon)
{
SqlCommand cmd = DBhelper.con.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Moneylogin";
cmd.Parameters.Add("@MoneyName", SqlDbType.VarChar, 50).Value = mon.Moneyname;
cmd.Parameters.Add("@Moneypwd", SqlDbType.VarChar, 15).Value = mon.MoneyPwd;
//返回值
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_money(Money mon)
{
return ms.login_money(mon);
}