Esempio n. 1
0
        public void Insert(Models.Account ac)
        {
            SqlParameter[] pars = new SqlParameter[13];
            pars[0]  = new SqlParameter("@UserName", ac.UserName);
            pars[1]  = new SqlParameter("@Pass", ac.Pass);
            pars[2]  = new SqlParameter("@Name", ac.Name);
            pars[3]  = new SqlParameter("@Email", ac.Email);
            pars[4]  = new SqlParameter("@SexID", ac.SexID);
            pars[5]  = new SqlParameter("@Birthday", ac.Birthday);
            pars[6]  = new SqlParameter("@Address", ac.Address);
            pars[7]  = new SqlParameter("@Balance", ac.Balance);
            pars[8]  = new SqlParameter("@VBalance", ac.VBalance);
            pars[9]  = new SqlParameter("@Point", ac.Point);
            pars[10] = new SqlParameter("@FailCard", ac.FailCard);
            pars[11] = new SqlParameter("@GroupRole", ac.GroupRole);
            pars[12] = new SqlParameter("@Status", ac.Status);

            DataUtilities.ExcuteNonQuery("Account_Insert",
                                         CommandType.StoredProcedure, pars);
        }
Esempio n. 2
0
 public int Del(int id)
 {
     return(DataUtilities.ExcuteNonQuery("Account_Delete", CommandType.StoredProcedure, "@ID", id));
 }