public void Create(SelfStockGroup stockGroup)
        {
            var parameters = new IDataParameter[]
            {
                new MySqlParameter("@P_USERID", stockGroup.UserId),
                new MySqlParameter("@P_GROUPNAME", stockGroup.Name),
                new MySqlParameter("@P_RETURN_VALUE",MySqlDbType.Int32){ Direction = ParameterDirection.Output }
            };

            var returnCode = this.DbRequest.ExecuteNonQuery(this.ConnectionString, "P_STOCK_GROUP_CREATE", parameters);
        }
        public void Update(SelfStockGroup stockGroup)
        {
            var parameters = new IDataParameter[]
            {
                new MySqlParameter("@P_ID", stockGroup.Id),
                new MySqlParameter("@P_UserId", stockGroup.UserId),
                new MySqlParameter("@P_GroupName", stockGroup.Name),
                new MySqlParameter("@P_DisplayOrder", stockGroup.DisplayOrder),
                new MySqlParameter("@P_IsHidden", stockGroup.IsHidden),
            };

            var returnCode = this.DbRequest.ExecuteNonQuery(this.ConnectionString, "P_STOCK_GROUP_UPDATE", parameters);
        }