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); }
public int Del(int id) { return(DataUtilities.ExcuteNonQuery("Account_Delete", CommandType.StoredProcedure, "@ID", id)); }