Exemplo n.º 1
0
        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;
        }
Exemplo n.º 2
0
 public bool login_money(Money mon)
 {
     return ms.login_money(mon);
 }